Move from Excel to Python with Pandas Transcripts
Chapter: Aggregating, grouping, and merging
Lecture: Concept: Appending data
Login or
purchase this course
to watch this video and the rest of the course contents.
0:00
to recap if we want a pin to data frames together similar to what you do with an excel copy and paste,
0:08
you would use PD can cat with each data frame that you want to stack on top of each other, assuming the calm names with same.
0:16
If you want to merge data similar to an XlV look up, you would use PD merge and you can specify the column names if they're not the
0:25
same. You can also specify the type of joint that you would like to execute