I am trying to read a .csv file which has 1048575 rows and 3 columns, there might be some missing indexes.
The .csv file looks like this
I wrote this line of code to read the .csv file using Pandas
df=pd.read_csv('GHI.csv',thousands=r',',sep=';',usecols=['Time','Value']).
The dataframe which is, however, read incorrectly as the length of the dataframe and the tail of it shows me incorrect timestamps.
Can someone please let me know how to parse this file properly and make the timestamps timezone aware.
Thanks, Debayan