Move from Excel to Python with Pandas Transcripts
Chapter: Intro to Pandas
Lecture: Concept: Working with columns

Login or purchase this course to watch this video and the rest of the course contents.
0:00 Now let's summarize some of the column work that we did in the previous exercise so
0:05 that she can reference this in the future.
0:08 If you want to do math on a single column,
0:11 use the brackets. Put the column name in there.
0:13 In this example, you can do this sum or the average on the extended amount column
0:17 You can count or do number of unique values on a column.
0:24 If you want to do a frequency table and see how many products and how many
0:28 examples or instances of that product there are,
0:33 you can use value counts. And then,
0:35 if you want to add a new column in this example,
0:38 if you want to do a mathematical calculation in this example,
0:41 we multiply our extended amount times 0.15 or you can enter in a string.
0:46 And then pandas will make sure that everything is copied down,
0:51 essentially to all of the other values in the data frame.
0:56 And then, when you want to work with multiple columns,
0:59 you put a list inside the brackets,
1:01 and then this example will show the average for the price and the quantity,
1:06 and you can do this for as many columns as you want in your data frame