So I tried loading some data through pandas to practice manipulating it, but I ran into a slight problem. Basically, the pandas loads the data improperly. And it does so consistently. Let me show you what I mean.
I think you can more or less see how it looks here. However, when I load it in Pandas, I get this:
As you can see there's a clear distortion. For one thing, the Date column has been pushed from the first column in the spreadsheet to the second in the csv. Its values have also been replaced with what looks to me like a copy of the "Travels" column. Moving on, you can also see that the column I'm interested in ("Total Direct Remittances") is totally incorrect. In the spreadsheet it starts with 342, but when loaded it starts with 23423, and the rest of its values are completely off.
Here's the code:
import pandas as pd data = pd.read_csv("/home/user/Downloads/IntPayments26102020.csv")
You can get a copy of the data here. Any ideas guys?