Charles Kelly explains how to use grouping for Pandas data structures.
- View Offline
- Exercise Files
- [Instructor] In this video, I'll provide one example…that illustrates how Panda's functions…are similar to SQL, the grouping file from…your exercises file folder is prepopulated…with import statements for Pandas and Nunpai…and a statement to create a data frame…with information read from an Excel file.…Begin by placing your cursor in the import cell…and execute it by pressing Shift Enter.…Next, look at this cell and the line…that starts with file name string.…
You'll need to change this string…so that it points to the exercise's file folder…on your computer, after you've done that,…execute the cell, after you've executed the cell,…you can display the data.…Next, we'll group the data within the data frame…by department and then we'll use the sum function…to calculate the number of years of service…for the employees within each department.…Here you can see the sum of the employees…in the accounting department is 47,…engineering 60, and marketing 52.…
This was a very quick example of how Panda's functions…are similar to SQL, in particular,…
Watch this course to gain an overview of Pandas. Charles Kelly helps you get started with time series, data frames, panels, plotting, and visualization. All you need is a copy of the free and interactive Jupyter Notebook app to practice and follow along.
- Using the Markdown language and Jupyter Notebook
- Creating objects
- Selecting objects
- Using operations
- Merging data
- Creating series
- Creating data frames
- Creating panels
- Annotating plots and data frame plots
Skill Level Intermediate
Introduction to Data Analysis with Pythonwith Michele Vallisneri2h 16m Intermediate
NumPy Data Science Essential Trainingwith Charles Kelly3h 54m Intermediate
SQL for Data Reporting and Analysiswith Emma Saunders2h 16m Intermediate
1. Introduction to Notebooks
2. Pandas Overview
4. Data Frames and Panels
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.