Seeking help regarding Python code
Debasree Banerjee
debasreebnrj at gmail.com
Thu Jul 11 01:54:21 EDT 2019
Hi,
I have a dataset like this:
RecTime
NO2_RAW
NO2
LAQN_NO2
10980
06/6/19 01:45
17.95444444
53.46255556
17.7
10981
06/6/19 01:45
17.94444444
53.44344444
17.7
10982
06/6/19 01:45
17.92111111
53.39877778
17.7
I want to calculate the difference between LAQN_NO2 and NO2_RAW everyday at
04:00 and add that value to NO2_RAW values in all rows on a particular day.
I have 2 months of data and I want to do this for each day.
So, I want a table like this
RecTime
NO2_RAW
NO2
LAQN_NO2
NO2_Cal
10980
06/6/19 01:45
17.95444444
53.46255556
17.7
(LAQN_NO2-NO2_RAW)+NO2_RAW
10981
06/6/19 01:45
17.94444444
53.44344444
17.7
10982
06/6/19 01:45
17.92111111
53.39877778
17.7
Can someone please help?
Thanks
Debasree
More information about the Python-list
mailing list