Hello,
I have two separate csv files that contain a list of [Account_name, Balance] for different time (2017 and 2018, respectfully).
However, the csv files themselves don't have the date mentioned anywhere.
How would I make so the data from the first file had "2017" date, and "2018" for the second?
How would I prevent data for the same account being overwritten?
So that I end up with something like this:
Balance | Something else |
---|
2017 | 2018 | |
Account | Balance | Account | Balance | |
some account | some balance | same account | some new balance | |
Thanks in advance!