Analyzing Data Using Python: Cleaning & Analyzing Data in Pandas

Python    |    Intermediate
  • 13 videos | 1h 53m 17s
  • Includes Assessment
  • Earns a Badge
Rating 4.4 of 35 users Rating 4.4 of 35 users (35)
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

  • 3m 17s
  • 6m 29s
  • Locked
    3.  Categorizing and Binning Data
    6m 48s
  • Locked
    4.  Computing Aggregations on Data
    10m 42s
  • Locked
    5.  Grouping and Aggregating Data
    12m 54s
  • Locked
    6.  Viewing Data Using Pivot Tables
    9m 50s
  • Locked
    7.  Summarizing Data Using Pivot Tables
    13m 10s
  • Locked
    8.  Combining Data in DataFrames
    10m 19s
  • Locked
    9.  Implementing Inner Joins
    8m 32s
  • Locked
    10.  Implementing Left and Right Joins
    7m 50s
  • Locked
    11.  Performing Joins Using DataFrame Indexes
    7m 20s
  • Locked
    12.  Analyzing Time Series Data
    13m 25s
    In this video, you'll learn how to manipulate and analyze time series data. You'll learn that this is a brand new Jupyter Notebook. You'll make use of import statements to carry out important work. FREE ACCESS
  • Locked
    13.  Course Summary
    2m 41s

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

Course Python - Using Pandas to Work with Series & DataFrames
Rating 4.4 of 81 users Rating 4.4 of 81 users (81)
Book Python Data Analytics: With Pandas, NumPy, and Matplotlib, 3rd Edition
Journey Data Analyst to Data Scientist
Rating 5.0 of 3 users Rating 5.0 of 3 users (3)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course CompTIA IT Fundamentals: Basic IT Concepts
Rating 4.7 of 114 users Rating 4.7 of 114 users (114)
Course Analyzing Data Using Python: Importing, Exporting, & Analyzing Data With Pandas
Rating 4.6 of 19 users Rating 4.6 of 19 users (19)
Course Excel with Python: Performing Advanced Operations
Rating 4.5 of 43 users Rating 4.5 of 43 users (43)