Author: ITExamAnswers
3.1.5.5 Lab – Correlation Analysis in Python (Instructor Version) Objectives Part 1: The Dataset Part 2: Scatterplot Graphs and Correlatable Variables Part 3: Calculating Correlation with Python Part 4: Visualizing Scenario/Background Correlation is an important statistical relationship that can indicate whether the variable values are linearly related. In …
3.1.4.6 Lab – Descriptive Statistics in Python (Instructor Version) Objectives Part 1: Analyzing the Data Part 2: Visualizing the Data Scenario/Background In this lab, you will import a data set into a pandas frame and generate descriptive statistics from the data. You will format text strings report the …
2.5.2.5 Lab – Internet Meter SQL (Instructor Version) Objectives Part 1: Set up your Database Part 2: Connect to the Database Part 3: Manipulate the Data with Pandas Part 4: Join Tables with Pandas </b> Scenario/Background In this lab you will learn how to connect to a relational …
2.5.2.4 Lab – Working with Python and SQLite (Instructor Version) Objectives Part 1: Create the Database Part 2: Enter Data and Query the Database Part 3: Automate the Process with Python </b> Scenario/Background In this lab you will learn how to connect to a relational database, place queries, …
2.5.1.4 Lab – Internet Meter Data Analysis (Instructor Version) Objectives **Part 1: Collect and Store Data** **Part 2: Manipulate Data** Scenario/Background In this lab, you will acquire Internet speed statistics and store the live data in a comma separated values (csv) file. You will also load the stored …
2.4.1.5 Lab – Ethics of Using Big Data (Instructor Version) Objective Use the discussion boards to start, or contribute to, a topic based on the ethics of using Big Data. Scenario Big Data is used by governments, companies, and web sites to determine answers to questions based on …
2.3.2.7 Lab – Preparing Data (Instructor Version) Objectives Part 1: Import the Data into Microsoft Excel Part 2: Get the Month out of a Date Part 3: Split Full Name Column into Different Columns Part 4: Concatenate Columns Background / Scenario Preparing the data is a critical step …
2.2.4.5 Lab – San Francisco Crime (Instructor Version) Objectives Demonstrate your knowledge of the Data Analysis Lifecycle using a given set of data and the tools, Python and Jupyter Notebook Part 1: Import the Python Packages Part 2: Load the Data Part 3: Prepare the Data Part 4: …
2.2.2.5 Lab – Basic Data Analysis (Instructor Version) Objectives Use very simple methods to describe existing data, fill-in missing data values and to make simple predictions. Part 1: Learn how to Use Data as Information Part 2: Plot data and predict values Background/Scenario Data is meaningless in and …
1.3.2.9 Lab – Take the Python Challenge (Instructor Version) This is an optional exercise to test your understanding of Python basics. However, we strongly suggest the student to complete these exercises to prepare yourself for the rest of this course. If you don’t know how to solve them, …
