Astro Pi 2021 Team PIoneers – Map Code

import reverse_geocoder as rg
import csv
import pandas as pd
import os
df=pd.read_csv(r'D:\pioneers\PIoneers_data.csv')
df.insert(0, 'Recno', range(1, 1 + len(df)))
df.to_csv(r'D:\pioneers\temp.csv')
df.head()


new_rows_list = []
new_header=[]
mno=0
with open(r'D:\pioneers\temp.csv', mode='r') as tempi:
    reader = csv.reader(tempi)
    for row in reader:
      reader = csv.reader(tempi)
      if(mno>0): 
        pos = (float(row[3]), float(row[4]))
        location_name = rg.get(pos, mode=1)['name']
        location_admin1 = rg.get(pos, mode=1)['admin1']
        location_admin2 = rg.get(pos, mode=1)['admin2']
        location_cc = rg.get(pos, mode=1)['cc']
        new_row = [row[1],location_name,location_admin1,location_admin2,location_cc]
        new_rows_list.append(new_row)
      else:
        new_row = ['Recno','location_name','location_admin1','location_admin2','cc']
        new_rows_list.append(new_row)
      mno=mno+1
    tempi.close()   
os.remove(r'D:\pioneers\temp.csv')

with open(r'D:\pioneers\temp.csv', mode='w') as tempe:
    writer = csv.writer(tempe)
    writer.writerows(new_rows_list)
    tempe.close()

df1=pd.read_csv(r'D:\pioneers\temp.csv')
df2=pd.read_csv(r'D:\pioneers\Country_code.csv')
df3=df1.merge(df2,on='cc', how='left')
os.remove(r'D:\pioneers\temp.csv')

df=pd.read_csv(r'D:\pioneers\PIoneers_data.csv')
df.insert(0, 'Recno', range(1, 1 + len(df)))
df4=df.merge(df3,on='Recno', how='left')

df5=pd.read_csv(r'D:\pioneers\Photo_link.csv')
df6=df4.merge(df5,on='Picture number', how='left')
df6['ISS location']=df6['Recno'].apply(str)+"---"+df6['Continent name']+"---"+df6['Country']+"---"+df6['location_name']
df6['ISS Pressure']="P: "+df6['Pressure'].apply(str)
df6['ISS Temperature']="T: "+df6['Temperature'].apply(str)
df6['ISS Humidity']="H: "+df6['Humidity'].apply(str)
df6['Picture_brightness']="B: "+df6['Picture brightness'].apply(str)

df7 = df6[['ISS location','ISS  photo link','Picture number', 'Date/time','Latitude','Longitude','Picture_brightness','Keep/delete algorithm','Keep/delete period','Picture verdict','ISS Pressure','ISS Temperature','ISS Humidity']].copy()
KEEP=df7[(df7['Picture verdict']=='K')]
KEEP.to_csv(r'D:\pioneers\KEEP.csv')

DELETE=df7[(df7['Picture verdict']=='D')]
DELETE.to_csv(r'D:\pioneers\DELETE.csv')
print("Stop")