Analyzing Data Using Python: Importing, Exporting, & Analyzing Data With Pandas

Python 3.8    |    Intermediate
  • 10 videos | 1h 22m 35s
  • Includes Assessment
  • Earns a Badge
Likes 20 Likes 20
You can analyze a myriad of data formats through pandas - all you need to know is how. In this course, you'll bring various data types into pandas and perform several operations on the data. You'll practice using common file types such as CSV, Excel, JSON, and HTML through pandas. You'll not only learn how to open and read files of different types, but you'll also serialize objects and copy them to the in-memory clipboard. You'll move on to perform various fundamental operations on DataFrame objects. Lastly, you'll learn to compute basic statistics, access metadata, and modify and sort data in rows.

WHAT YOU WILL LEARN

  • discover the key concepts covered in this course
    import and export data in CSV files
    import and export data using HTML and JSON files
    serialize data to Excel and Pickle files
    perform basic data manipulation operations on DataFrames
  • explore and edit data in DataFrames
    sort records based on column values
    compute basic statistics on data stored in DataFrames
    compute statistical summaries on data stored in DataFrames
    summarize the key concepts covered in this course

IN THIS COURSE

  • Playable
    1.  Course Overview
    2m 15s
  • Playable
    2.  Importing and Exporting CSV Files
    8m 36s
    In this video, you'll learn how to import and export data in CSV files. You'll discover that DataFrames and Pandas organize data into rows and columns. Every row can be identified using a unique value of the index. The… FREE ACCESS
  • Locked
    3.  Importing and Exporting Data in HTML and JSON Files
    12m 46s
    In this session, we will be working with the HTML and JSON file formats. HTML files are used to store data in a human-readable format, while JSON files are used to store data in a machine-readable format. We will first… FREE ACCESS
  • Locked
    4.  Reading and Writing Excel Files Using DataFrames
    9m 34s
    In this video, you'll learn how to serialize data to Excel and Pickle files. You'll follow along with a demo in which you'll turn your attention to the common file format, the Excel file format. Along the way, you'll also… FREE ACCESS
  • Locked
    5.  Performing Basic DataFrame Operations
    12m 29s
    In this video, you will learn that there are many common operations on pandas DataFrames. You will learn how to perform basic data manipulation operations on DataFrames, including sorting and filtering. FREE ACCESS
  • Locked
    6.  Computing Unique Values and Renaming Columns
    7m 27s
    In this video, you will learn how to discover and edit data in DataFrames. You will follow along onscreen as you learn about exploratory data analysis operations using Python DataFrames. You will also encounter a common… FREE ACCESS
  • Locked
    7.  Sorting Data Based on Specific Columns
    7m 9s
    In this video, you'll learn how to sort records based on column values. You'll discover that there's nothing wrong with sorting the values in a DataFrame. Instead, you'll learn to understand it carefully because the first… FREE ACCESS
  • Locked
    8.  Computing Basic Statistics
    6m 53s
    This session is about computing basic statistics on data stored in a pandas DataFrame. The presenter will discuss how to use the describe function, drop method, head method, and idxmax function. FREE ACCESS
  • Locked
    9.  Computing Univariate and Bivariate Statistics
    12m 37s
    In this video, you'll learn how to compute statistical summaries on data stored in DataFrames. You'll start by exploring the mean. Next, you'll calculate the median, which is also called the 50th percentile. Then, you'll… FREE ACCESS
  • Locked
    10.  Course Summary
    2m 49s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Channel Data Wrangling in Python Bootcamp
Likes 105 Likes 105  
Book Pandas in Action
Course Data Visualization: Getting Started with Plotly
Likes 7 Likes 7  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Python - Manipulating & Analyzing Data in Pandas DataFrames
Likes 217 Likes 217  
Course Analyzing Data Using Python: Cleaning & Analyzing Data in Pandas
Likes 6 Likes 6  
Course Functions in Python: Introduction
Likes 598 Likes 598