Charles Kelly explains how to select, add, and delete data from Pandas data frames.
- [Instructor] In this video we'll examine…how to select, add and delete columns from a data frame.…The select file in your exercises files folders…is prepopulated with import statements…for pandas and num pi.…Execute the cell by pressing shift+enter.…If we create a data frame from the pandas cookbook…we can reference columns in the data frame…using a dictionary like syntax.…In this cell we reference the second column…with the string BBB.…
We can use these string references…or these string selections in arithmetic…vectorized operations.…Copying from the final version of your file,…we can take the column BBB and multiply…every value in the column by every column…in the column CCC.…Here we see we have ten times a hundred,…twenty times fifty, thirty times -30…and forty times -50.…There are two ways that we can release columns…from a data frame, the DEL or delete operator…and the pop function.…
In this cell we use the delete function…to remove the middle column.…As you can see BBB is now missing.…In this cell we use the pop function…
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
NumPy Data Science Essential Trainingwith Charles Kelly3h 54m Intermediate
SQL: 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.