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

Python    |    Intermediate
  • 10 videos | 1h 22m 35s
  • Includes Assessment
  • Earns a Badge
Rating 4.6 of 19 users Rating 4.6 of 19 users (19)
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

  • 2m 15s
  • 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 unique value is called the label and every column can be identified using the column header. 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 create a CSV file containing data in the form of objects, and then export that data to a JSON file. 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 see how pandas DataFrames can be serialized and deserialized, and how they can be written to the clipboard. 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 but nasty pandas gotcha. 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 input argument into sort_values is a column name and the second input argument is the sort type. 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 learn that the mode is the most commonly occurring value or set of values. 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

Course CompTIA Data+: Data Analytics Tools
Rating 4.3 of 32 users Rating 4.3 of 32 users (32)
Course Python Development: Creating Classes, Handling Errors, & Importing Modules
Rating 4.7 of 201 users Rating 4.7 of 201 users (201)
Channel Data Wrangling in Python Bootcamp
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Analyzing Data Using Python: Cleaning & Analyzing Data in Pandas
Rating 4.4 of 35 users Rating 4.4 of 35 users (35)
Course Python Fundamentals Bootcamp: Session 3 Replay
Rating 4.5 of 124 users Rating 4.5 of 124 users (124)
Course CompTIA Cloud+: Troubleshooting Cloud Security Issues
Rating 4.7 of 25 users Rating 4.7 of 25 users (25)