Python - Manipulating & Analyzing Data in Pandas DataFrames

Python 3    |    Intermediate
  • 10 Videos | 48m 10s
  • Includes Assessment
  • Earns a Badge
Likes 137 Likes 137
Explore advanced data manipulation and analysis with Pandas DataFrames, a Python library that shares similarities with relational databases. To take this course, prior basic experience is needed with Pandas DataFrames, data loading, and Jupyter Notebook data manipulation. You will learn to iterate data in your DataFrame. See how to export data to Excel files, JSON (JavaScript Object Notation) files, and CSV (comma separated values) files. Sort the contents of a DataFrame and manage missing data. Group data with a multi-index. Merge disparate data into a single DataFrame through join and concatenate operations. Finally, you will determine when and where to integrate data with structured queries, similar to SQL.

WHAT YOU WILL LEARN

  • learn how to iterate over a DataFrame's rows and columns
    export the contents of a DataFrame into files of various formats
    describe and apply the different techniques involved in handling datasets where some information is missing
    describe and apply the different techniques involved in handling datasets where some information is missing
    implement a hierarchical index and access the DataFrame's contents based on that index
  • combine two similar DataFrames using the concat operation
    apply a join operation on two related but dissimilar DataFrames using the merge function
    load data into a Pandas DataFrame from a table in a relational database
    use Pandas for advanced tabular data manipulation

IN THIS COURSE

  • Playable
    1. 
    Course Overview
    2m 8s
    UP NEXT
  • Playable
    2. 
    Iterating Over the Contents of a DataFrame
    3m 24s
  • Locked
    3. 
    Exporting a DataFrame
    3m 27s
    FREE ACCESS
  • Locked
    4. 
    Sorting
    4m 46s
    FREE ACCESS
  • Locked
    5. 
    Handling Missing Data
    5m 36s
    FREE ACCESS
  • Locked
    6. 
    Grouping with a Multi-Index
    5m 17s
    FREE ACCESS
  • Locked
    7. 
    Merging DataFrames
    3m 24s
    FREE ACCESS
  • Locked
    8. 
    Applying Join Operations on DataFrames
    5m 13s
    FREE ACCESS
  • Locked
    9. 
    Pandas and Relational Databases
    6m 34s
    FREE ACCESS
  • Locked
    10. 
    Exercise: Pandas for Advanced Data Manipulation
    4m 20s
    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

COURSE Python - Using Pandas to Work with Series & DataFrames
Likes 86 Likes 86  
COURSE Analyzing Data Using Python: Data Analytics Using Pandas
Likes 0 Likes 0  
COURSE Analyzing Data Using Python: Filtering Data in Pandas
Likes 0 Likes 0  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Python - Introduction to NumPy for Multi-dimensional Data
Likes 218 Likes 218  
COURSE Python - Pandas Advanced Features
Likes 88 Likes 88  
COURSE Python for Data Science: Advanced Data Visualization Using Seaborn
Likes 68 Likes 68