comparison redelacxlsx2csv.py @ 1:b91beff0963c draft default tip

"planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/b275711eca6a471af5cb60ae996e0bd6c11461d6/tools/REDELACxlsx2csv commit b275711eca6a471af5cb60ae996e0bd6c11461d6-dirty"
author siwaa
date Thu, 06 Jul 2023 10:16:26 +0000
parents dd02fab383bf
children
comparison
equal deleted inserted replaced
0:dd02fab383bf 1:b91beff0963c
27 USMsPdf['rcp'] = USMsPdf['rcp'].astype('string') 27 USMsPdf['rcp'] = USMsPdf['rcp'].astype('string')
28 28
29 USMsPdf['Début'] = pd.to_datetime(USMsPdf['Début'], dayfirst = True) 29 USMsPdf['Début'] = pd.to_datetime(USMsPdf['Début'], dayfirst = True)
30 USMsPdf['Fin'] = pd.to_datetime(USMsPdf['Fin'], dayfirst = True) 30 USMsPdf['Fin'] = pd.to_datetime(USMsPdf['Fin'], dayfirst = True)
31 31
32 USMsPdf.loc[USMsPdf['culturean'] != 1, 'culturean'] = 0
33
32 # saving to csv 34 # saving to csv
33 35
34 USMsPdf.to_csv(redelacUSMsOutputFile, sep=';', date_format='%d/%m/%Y', decimal = ',', index=False) 36 USMsPdf.to_csv(redelacUSMsOutputFile, sep=';', date_format='%d/%m/%Y', decimal = ',', index=False)
35 TecPdf.to_csv(redelacTecOutputFile, sep=';', date_format='%d/%m/%Y', decimal = ',', float_format='%.2f', index=False) 37 TecPdf.to_csv(redelacTecOutputFile, sep=';', date_format='%d/%m/%Y', decimal = ',', float_format='%.2f', index=False)
36 IniPdf.to_csv(redelacIniOutputFile, sep=';', date_format='%d/%m/%Y', decimal = ',', index=False) 38 IniPdf.to_csv(redelacIniOutputFile, sep=';', date_format='%d/%m/%Y', decimal = ',', index=False)