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

Talk Python's Mastodon Michael Kennedy's Mastodon