Mercurial > repos > siwaa > redelac_stics_e

comparison redelacPlanExpander.py @ 3:ecbd096ba43b draft default tip

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
"planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/b4ec8ff39b5d159c4f9def1a6a450b1fbcd698a2/tools/REDELACplanExpander commit b4ec8ff39b5d159c4f9def1a6a450b1fbcd698a2-dirty"
author siwaa
date Tue, 07 May 2024 11:45:15 +0000
parents 47dafd3de5ef
children
comparison
equal deleted inserted replaced
2:47dafd3de5ef 3:ecbd096ba43b
1 import sys 1 import sys
2 import pandas as pd 2 import pandas as pd
3 import numpy as np 3 import numpy as np
4 4
5 typeOfRotation = sys.argv [1] 5 # typeOfRotation = sys.argv [1]
6 USMsFileName = sys.argv[2] 6 USMsFileName = sys.argv[1]
7 Liste_plantesFileName = sys.argv[3] 7 Liste_plantesFileName = sys.argv[2]
8 planFileName = sys.argv[4] 8 planFileName = sys.argv[3]
9 maillesFileName = sys.argv[5] 9 maillesFileName = sys.argv[4]
10 expandedPlanFileName = sys.argv[6] 10 expandedPlanFileName = sys.argv[5]
11 successiveFileName = sys.argv[7] 11 successiveFileName = sys.argv[6]
12 StationsFileName = sys.argv[8] 12 StationsFileName = sys.argv[7]
13 aclimParHorizonFileName = sys.argv[9] 13 aclimParHorizonFileName = sys.argv[8]
14 latitudeMailleDriasDFileName= sys.argv[10] 14 latitudeMailleDriasDFileName= sys.argv[9]
15 expandedStationsFileName = sys.argv[11] 15 expandedStationsFileName = sys.argv[10]
16 16
17 # 1) reading the base list of USMs 17 # 1) reading the base list of USMs
18 18
19 #USMsDf = pd.read_excel(basePlanFileName, sheet_name='USMs') 19 #USMsDf = pd.read_excel(basePlanFileName, sheet_name='USMs')
20 USMsDf = pd.read_csv(USMsFileName, sep=";", keep_default_na=False, na_filter = False) 20 USMsDf = pd.read_csv(USMsFileName, sep=";", keep_default_na=False, na_filter = False)
60 expandedStationsDf.to_csv(expandedStationsFileName, index = False, sep = ';') 60 expandedStationsDf.to_csv(expandedStationsFileName, index = False, sep = ';')
61 61
62 62
63 # a new dataFrame to host the list of USMs in expansion 63 # a new dataFrame to host the list of USMs in expansion
64 expandedDf = pd.DataFrame() 64 expandedDf = pd.DataFrame()
65
66 # define the type of rotation according to content
67
68 if USMsDf.iloc[0]['rotation'] == 'PP' :
69 typeOfRotation = 'PP'
70 else :
71 typeOfRotation = 'GC'
65 72
66 for i, row in planDf.iterrows(): 73 for i, row in planDf.iterrows():
67 tmpDf = USMsDf 74 tmpDf = USMsDf
68 75
69 safran = int(row['upc'].split('_')[1]) 76 safran = int(row['upc'].split('_')[1])