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
0:04 with an excel copy and paste,
0:07 you would use PD can cat with each data frame that you want to stack on
0:12 top of each other, assuming the calm names with same.
0:15 If you want to merge data similar to an XlV look up,
0:19 you would use PD merge and you can specify the column names if they're not the
0:24 same. You can also specify the type of joint that you would like to execute