Analyzing Data Using Python: Cleaning & Analyzing Data in Pandas

Python 3.8    |    Intermediate
  • 13 Videos | 1h 53m 17s
  • Includes Assessment
  • Earns a Badge
Likes 6 Likes 6
For data analysis to be useful and accurate, the analyzed data needs to be cleaned and curated. There are copious methods to achieve this in pandas. In this course, you'll learn how to identify and eliminate duplicates in pandas. You'll start by using the pandas cut method to discretize data into bins, using bins to plot histograms and identify outliers using box-and-whisker plots. You'll parse and work with datetime objects read in from strings and convert string columns to datetime using the dateutils python library. Moving on, you'll master different pandas methods for aggregating data - including the groupby, pivot, and pivot_table methods. Lastly, you'll perform various joins - inner, left outer, right outer, and full outer - using both the merge and join methods.

WHAT YOU WILL LEARN

  • discover the key concepts covered in this course
    identify and deal with duplicate records
    summarize records into bins or categories
    compute aggregations on data
    perform common grouping and aggregation operations
    use pivot tables to explore data
    use pivot tables to summarize data
  • combine and merge records
    perform inner join operations using the merge() method
    perform left and right join operations using the merge() method
    implement joins using the join() method
    manipulate and analyze time series data
    summarize the key concepts covered in this course

IN THIS COURSE

  • Playable
    1. 
    Course Overview
    3m 17s
    UP NEXT
  • Playable
    2. 
    Identifying Duplicates in Data
    6m 29s
  • Locked
    3. 
    Categorizing and Binning Data
    6m 48s
    FREE ACCESS
  • Locked
    4. 
    Computing Aggregations on Data
    10m 42s
    FREE ACCESS
  • Locked
    5. 
    Grouping and Aggregating Data
    12m 54s
    FREE ACCESS
  • Locked
    6. 
    Viewing Data Using Pivot Tables
    9m 50s
    FREE ACCESS
  • Locked
    7. 
    Summarizing Data Using Pivot Tables
    13m 10s
    FREE ACCESS
  • Locked
    8. 
    Combining Data in DataFrames
    10m 19s
    FREE ACCESS
  • Locked
    9. 
    Implementing Inner Joins
    8m 32s
    FREE ACCESS
  • Locked
    10. 
    Implementing Left and Right Joins
    7m 50s
    FREE ACCESS
  • Locked
    11. 
    Performing Joins Using DataFrame Indexes
    7m 20s
    FREE ACCESS
  • Locked
    12. 
    Analyzing Time Series Data
    13m 25s
    FREE ACCESS
  • Locked
    13. 
    Course Summary
    2m 41s
    FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

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

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

BOOK Data Analysis with Python and PySpark
COURSE Analyzing Data Using Python: Importing, Exporting, & Analyzing Data With Pandas
Likes 6 Likes 6  
CHANNEL Data Wrangling in Python Bootcamp
Likes 105 Likes 105  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Python - Using Pandas for Visualizations and Time-Series Data
Likes 115 Likes 115  
COURSE Excel with Python: Performing Advanced Operations
Likes 77 Likes 77  
COURSE Complete Guide to Excel 365: Pivot, PowerPivot, & Financial Modeling
Likes 60 Likes 60