Pandas loads a csv file incorrectly, but without throwing an error
You need to read the file with the index_col=False argument:
# wrong way:
df = pd.read_csv(&quot;IntPayments26102020.csv&quot;)
print(df.head())
# result :
                  Date     Travels  ...  Debt Services And Payments  Total
10/12/2003   234234.00     23424.0  ...                3.574570e+05    NaN
1/12/2005        12.00         2.0  ...                1.160000e+02    NaN
4/28/2006   7119901.48   9950000.0  ...                3.887479e+08    NaN
5/2/2006        346.00    345435.0  ...                4.632060e+05    NaN
5/12/2006    152204.22  11500000.0  ...                4.743224e+08    NaN

[5 rows x 11 columns]


# correct way:
df = pd.read_csv(&quot;IntPayments26102020.csv&quot;, index_col=False)
print(df.head())
# result :

         Date     Travels  ...  Debt Services And Payments         Total
0  10/12/2003   234234.00  ...                    23423.00  3.574570e+05
1   1/12/2005       12.00  ...                       21.00  1.160000e+02
2   4/28/2006  7119901.48  ...                 45602245.83  3.887479e+08
3    5/2/2006      346.00  ...                    34534.00  4.632060e+05
4   5/12/2006   152204.22  ...                 71560790.20  4.743224e+08

[5 rows x 11 columns]

From the docs:

index_col : int, str, sequence of int / str, or False, default None
Column(s) to use as the row labels of the DataFrame, either given as string name or column index. If a sequence of int / str is given, a
MultiIndex is used.
Note: index_col=False can be used to force pandas to not use the first column as the index, e.g. when you have a malformed file with
delimiters at the end of each line.

From where you can arguably guess why the default setting index_col=None will not work with your data - your rows are also separated by comma ,:
&quot;Date&quot;,&quot;Travels&quot;,&quot;Inward Money Transfers&quot;,&quot;Cash Sales to BDC And Banks&quot;,&quot;Letters of Credit&quot;,&quot;Total Direct Remittances&quot;,&quot;Remittances to Travelex&quot;,&quot;Remittances to Amex&quot;,&quot;WDAS&quot;,&quot;Debt Services And Payments&quot;,&quot;Total&quot;
&quot;10/12/2003&quot;,&quot;234234&quot;,&quot;23424&quot;,&quot;23423&quot;,&quot;2342&quot;,&quot;342&quot;,&quot;23423&quot;,&quot;3423&quot;,&quot;23423&quot;,&quot;23423&quot;,&quot;357457&quot;,
&quot;1/12/2005&quot;,&quot;12&quot;,&quot;2&quot;,&quot;12&quot;,&quot;12&quot;,&quot;21&quot;,&quot;12&quot;,&quot;12&quot;,&quot;12&quot;,&quot;21&quot;,&quot;116&quot;,