Month: May 2022
3.2.1.6 Lab - Internet Meter Visualization (Instructor Version) Objectives Part 1: Clean and Analyze Data Part 2: Visualize Data Scenario/Background In this lab, you will learn how to use the pandas library to perform the preliminary steps that are needed before perfoming any data analysis. This includes removing …
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 …
