Charles Kelly explains how to use categorical data within Pandas.
- [Instructor] Categoricals are a pandas data type…which correspond to categorical variables and statistics,…in particular a variable that only takes on…a discrete number of possible values.…The categorical data file from your exercises file folder…is prepopulated with import statements…for pandas and num pi and a data frame…that is created by importing data from an Excel file.…Note the file name string, you'll need to change…this so that it points to a location on your computer…that corresponds to the location for the exercise files.…
Once you've done that execute this cell…by pressing shift + enter.…We can look at the information in the data frame…by copying the name of the data frame,…pasting it into a new cell and executing that cell.…Note that the data in the grade column,…A, B, C, D, F are strings.…Let's use panda's as type function…to convert the string data to categorical data.…Now we'll rename the data A, B, C, D, F…into categories that correspond…to excellent, good, acceptable, poor and unacceptable.…
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?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
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.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.