Data aggregation is one huge Data Scientist job. More times than I can remember, I ended up with multiple files that I had to aggregate.
Aggregation can be very helpful when you want to compare results against a certain variable. (e.g. Sales per month over a few years but you only have yearly sales reports).
Here is the code
How to combine by rows
How to combine by columns
Here you are! You now know how to combine two DataFrame together either by rows or columns.
More on DataFrames
If you want to know more about DataFrame and Pandas. Check out the other articles I wrote on the topic, just here :