Mercurial > repos > siwaa > redelac_stics_e

annotate 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
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
0
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
1 import sys
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
2 import pandas as pd
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
3 import numpy as np
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
4
3
ecbd096ba43b "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/b4ec8ff39b5d159c4f9def1a6a450b1fbcd698a2/tools/REDELACplanExpander commit b4ec8ff39b5d159c4f9def1a6a450b1fbcd698a2-dirty"
siwaa
parents: 2
diff changeset
5 # typeOfRotation = sys.argv [1]
ecbd096ba43b "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/b4ec8ff39b5d159c4f9def1a6a450b1fbcd698a2/tools/REDELACplanExpander commit b4ec8ff39b5d159c4f9def1a6a450b1fbcd698a2-dirty"
siwaa
parents: 2
diff changeset
6 USMsFileName = sys.argv[1]
ecbd096ba43b "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/b4ec8ff39b5d159c4f9def1a6a450b1fbcd698a2/tools/REDELACplanExpander commit b4ec8ff39b5d159c4f9def1a6a450b1fbcd698a2-dirty"
siwaa
parents: 2
diff changeset
7 Liste_plantesFileName = sys.argv[2]
ecbd096ba43b "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/b4ec8ff39b5d159c4f9def1a6a450b1fbcd698a2/tools/REDELACplanExpander commit b4ec8ff39b5d159c4f9def1a6a450b1fbcd698a2-dirty"
siwaa
parents: 2
diff changeset
8 planFileName = sys.argv[3]
ecbd096ba43b "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/b4ec8ff39b5d159c4f9def1a6a450b1fbcd698a2/tools/REDELACplanExpander commit b4ec8ff39b5d159c4f9def1a6a450b1fbcd698a2-dirty"
siwaa
parents: 2
diff changeset
9 maillesFileName = sys.argv[4]
ecbd096ba43b "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/b4ec8ff39b5d159c4f9def1a6a450b1fbcd698a2/tools/REDELACplanExpander commit b4ec8ff39b5d159c4f9def1a6a450b1fbcd698a2-dirty"
siwaa
parents: 2
diff changeset
10 expandedPlanFileName = sys.argv[5]
ecbd096ba43b "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/b4ec8ff39b5d159c4f9def1a6a450b1fbcd698a2/tools/REDELACplanExpander commit b4ec8ff39b5d159c4f9def1a6a450b1fbcd698a2-dirty"
siwaa
parents: 2
diff changeset
11 successiveFileName = sys.argv[6]
ecbd096ba43b "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/b4ec8ff39b5d159c4f9def1a6a450b1fbcd698a2/tools/REDELACplanExpander commit b4ec8ff39b5d159c4f9def1a6a450b1fbcd698a2-dirty"
siwaa
parents: 2
diff changeset
12 StationsFileName = sys.argv[7]
ecbd096ba43b "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/b4ec8ff39b5d159c4f9def1a6a450b1fbcd698a2/tools/REDELACplanExpander commit b4ec8ff39b5d159c4f9def1a6a450b1fbcd698a2-dirty"
siwaa
parents: 2
diff changeset
13 aclimParHorizonFileName = sys.argv[8]
ecbd096ba43b "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/b4ec8ff39b5d159c4f9def1a6a450b1fbcd698a2/tools/REDELACplanExpander commit b4ec8ff39b5d159c4f9def1a6a450b1fbcd698a2-dirty"
siwaa
parents: 2
diff changeset
14 latitudeMailleDriasDFileName= sys.argv[9]
ecbd096ba43b "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/b4ec8ff39b5d159c4f9def1a6a450b1fbcd698a2/tools/REDELACplanExpander commit b4ec8ff39b5d159c4f9def1a6a450b1fbcd698a2-dirty"
siwaa
parents: 2
diff changeset
15 expandedStationsFileName = sys.argv[10]
0
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
16
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
17 # 1) reading the base list of USMs
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
18
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
19 #USMsDf = pd.read_excel(basePlanFileName, sheet_name='USMs')
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
20 USMsDf = pd.read_csv(USMsFileName, sep=";", keep_default_na=False, na_filter = False)
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
21
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
22 # 2) reading the list of plant
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
23
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
24 #plantsDf = pd.read_excel(basePlanFileName, sheet_name='Liste_plantes')
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
25 plantsDf = pd.read_csv(Liste_plantesFileName, sep=";")
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
26
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
27 # 3) reading the plan
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
28
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
29 planDf = pd.read_csv(planFileName, sep=";")
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
30
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
31 # 4) reading the "mailles" file
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
32 maillesDf = pd.read_csv(maillesFileName, sep=";")
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
33
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
34 # 5) reading the stations template
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
35 StationsDf = pd.read_csv(StationsFileName, sep=";")
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
36
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
37 aclimParHorizonDf = pd.read_csv(aclimParHorizonFileName, sep=";")
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
38
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
39 latitudeMailleDriasDf = pd.read_csv(latitudeMailleDriasDFileName, sep=";")
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
40
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
41 # a new dataframe to hosts the stations in expansion
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
42 expandedStationsDf = pd.DataFrame()
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
43
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
44 for i, row in planDf.iterrows():
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
45 tmpDf = StationsDf
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
46
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
47 safran = int(row['upc'].split('_')[1])
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
48 drias = maillesDf[maillesDf["maille_safran"] == safran].reset_index(drop=True)["maille_drias"][0]
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
49
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
50 tmpDfBis = tmpDf;
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
51
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
52 for j, rowS in tmpDf.iterrows():
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
53 horizon = rowS['Sta_name'].split('_')[1]
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
54 tmpDfBis.at[j, 'Sta_name'] = str(drias) + '_' + horizon + '_sta.xml'
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
55 tmpDfBis.at[j, 'aclim'] = aclimParHorizonDf[(aclimParHorizonDf['maille_DRIAS'] == drias) & (aclimParHorizonDf['horizon'] == horizon)].reset_index(drop=True)["aclim"][0]
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
56 tmpDfBis.at[j, 'latitude'] = latitudeMailleDriasDf[(latitudeMailleDriasDf['maille_DRIAS'] == drias)].reset_index(drop=True)["latitude"][0]
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
57
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
58 expandedStationsDf = pd.concat([expandedStationsDf, tmpDfBis])
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
59
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
60 expandedStationsDf.to_csv(expandedStationsFileName, index = False, sep = ';')
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
61
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
62
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
63 # a new dataFrame to host the list of USMs in expansion
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
64 expandedDf = pd.DataFrame()
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
65
3
ecbd096ba43b "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/b4ec8ff39b5d159c4f9def1a6a450b1fbcd698a2/tools/REDELACplanExpander commit b4ec8ff39b5d159c4f9def1a6a450b1fbcd698a2-dirty"
siwaa
parents: 2
diff changeset
66 # define the type of rotation according to content
ecbd096ba43b "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/b4ec8ff39b5d159c4f9def1a6a450b1fbcd698a2/tools/REDELACplanExpander commit b4ec8ff39b5d159c4f9def1a6a450b1fbcd698a2-dirty"
siwaa
parents: 2
diff changeset
67
ecbd096ba43b "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/b4ec8ff39b5d159c4f9def1a6a450b1fbcd698a2/tools/REDELACplanExpander commit b4ec8ff39b5d159c4f9def1a6a450b1fbcd698a2-dirty"
siwaa
parents: 2
diff changeset
68 if USMsDf.iloc[0]['rotation'] == 'PP' :
ecbd096ba43b "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/b4ec8ff39b5d159c4f9def1a6a450b1fbcd698a2/tools/REDELACplanExpander commit b4ec8ff39b5d159c4f9def1a6a450b1fbcd698a2-dirty"
siwaa
parents: 2
diff changeset
69 typeOfRotation = 'PP'
ecbd096ba43b "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/b4ec8ff39b5d159c4f9def1a6a450b1fbcd698a2/tools/REDELACplanExpander commit b4ec8ff39b5d159c4f9def1a6a450b1fbcd698a2-dirty"
siwaa
parents: 2
diff changeset
70 else :
ecbd096ba43b "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/b4ec8ff39b5d159c4f9def1a6a450b1fbcd698a2/tools/REDELACplanExpander commit b4ec8ff39b5d159c4f9def1a6a450b1fbcd698a2-dirty"
siwaa
parents: 2
diff changeset
71 typeOfRotation = 'GC'
ecbd096ba43b "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/b4ec8ff39b5d159c4f9def1a6a450b1fbcd698a2/tools/REDELACplanExpander commit b4ec8ff39b5d159c4f9def1a6a450b1fbcd698a2-dirty"
siwaa
parents: 2
diff changeset
72
0
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
73 for i, row in planDf.iterrows():
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
74 tmpDf = USMsDf
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
75
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
76 safran = int(row['upc'].split('_')[1])
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
77 drias = maillesDf[maillesDf["maille_safran"] == safran].reset_index(drop=True)["maille_drias"][0]
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
78
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
79 tmpDf['upc'] = row['upc']
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
80 tmpDf['ucs'] = row['ucs']
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
81 tmpDf['num_sol'] = row['num_sol']
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
82
2
47dafd3de5ef "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/50303b4ec07c7fe49c61f47d37917bb860c9e281/tools/REDELACplanExpander commit 50303b4ec07c7fe49c61f47d37917bb860c9e281-dirty"
siwaa
parents: 0
diff changeset
83 if typeOfRotation == 'GC' :
0
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
84 tmpDf['Norg_sols'] = row['Norg_sols_GC']
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
85 tmpDf['nom_sol_sans_point'] = row['nom_sols_GC_dans_USM']
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
86 else :
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
87 tmpDf['Norg_sols'] = row['Norg_sols_PP']
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
88 tmpDf['nom_sol_sans_point'] = row['nom_sols_PP_dans_USM']
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
89
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
90 tmpDf['maille_drias'] = drias
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
91
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
92 # Updating the id_simu column
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
93 # alias =CONCATENATE(F2;"-";G2;"_";H2;"-";I2;"-";K2;"-";L2;"-";M2)
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
94 # new alias = =CONCATENATE(F2;"-";I2;"-";J2;"-";L2;"-";M2;"-";N2)
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
95
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
96 tmpDf['id_simu'] = \
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
97 tmpDf.upc + '-' + \
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
98 tmpDf['nom_sol_sans_point'].astype(str) + '-' + \
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
99 tmpDf['systeme'].astype(str) + '-' + \
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
100 tmpDf['code_rotation'].astype(str) + '-' + \
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
101 tmpDf['tete_rotation'].astype(str) + '-' + \
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
102 tmpDf['horizon '].astype(str)
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
103
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
104 # Merging 2 sheets in order to solve the VLOOKUP
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
105 plantsDf.rename(columns = {'Nom_plante':'culture'}, inplace = True)
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
106 tmpDf = pd.merge(tmpDf,plantsDf, how='left', on='culture', sort=False)
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
107
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
108 # Updating the usm_name column
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
109 # alias =CONCATENATE(F2;"-";G2;"_";H2;"-";I2;"-";K2;"-";L2;"-";M2;"-";N2;"-";VLOOKUP(O2;$Liste_plantes.$A$2:$B$7;2;0))
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
110 # newalias ==CONCATENATE(F2;"-";I2;"-";J2;"-";L2;"-";M2;"-";N2;"-";P2;"-";VLOOKUP(Q2;$Liste_plantes.$A$2:$B$7;2;0))
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
111
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
112 tmpDf['usm_name'] = \
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
113 tmpDf.upc + '-' + \
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
114 tmpDf['nom_sol_sans_point'].astype(str) + '-' + \
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
115 tmpDf['systeme'].astype(str) + '-' + \
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
116 tmpDf['code_rotation'].astype(str) + '-' + \
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
117 tmpDf['tete_rotation'].astype(str) + '-' + \
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
118 tmpDf['horizon '].astype(str) + '-' + \
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
119 tmpDf['annee_fin'].astype(str) + '-' + \
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
120 tmpDf['Code_plante']
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
121
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
122
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
123 # Updating the nomsol column
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
124 # alias =CONCATENATE(G2;"_";H2)
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
125
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
126 tmpDf['nomsol'] = \
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
127 tmpDf['num_sol'].astype(str) + '_' + \
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
128 tmpDf['Norg_sols'].astype(str)
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
129
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
130
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
131 # Updating the fstation column
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
132 # alias =CONCATENATE($E2;"_";M2;"_sta.xml")
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
133
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
134 tmpDf['fstation'] = \
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
135 tmpDf['maille_drias'].astype(str) + '_' + \
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
136 tmpDf['horizon '].astype(str) + '_sta.xml'
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
137
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
138 # Updating the fclim1 column
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
139 # alias =CONCATENATE($E2;".";YEAR(R2))
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
140
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
141 tmpDf['fclim1'] = \
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
142 tmpDf['maille_drias'].astype(str) + '.' + \
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
143 pd.to_datetime(tmpDf['Début'], dayfirst = True).dt.year.astype(str)
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
144
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
145 # Updating the fclim2 column
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
146 # alias =CONCATENATE($E2;".";YEAR(S2))
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
147
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
148 tmpDf['fclim2'] = \
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
149 tmpDf['maille_drias'].astype(str) + '.' + \
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
150 pd.to_datetime(tmpDf['Fin'], dayfirst = True).dt.year.astype(str)
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
151
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
152 expandedDf = pd.concat([expandedDf, tmpDf])
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
153
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
154 # now getting the list of simu
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
155
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
156 sucessDf = pd.DataFrame()
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
157
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
158 listOfSuccessWithNA = expandedDf['id_simu'].unique()
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
159
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
160 # en raison des NA on filtre
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
161
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
162 listOfSuccess = [x for x in listOfSuccessWithNA if not x.endswith('NA')]
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
163
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
164 nbL = len(listOfSuccess)
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
165
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
166 # fixing first station before to save
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
167
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
168 fi = 0
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
169
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
170 expandedDf.reset_index(inplace = True)
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
171
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
172 for succ in listOfSuccess:
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
173
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
174 li = expandedDf[expandedDf['id_simu'] == succ].index.max()
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
175
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
176 expandedDf.loc[fi:li - 1, 'fstation'] = expandedDf['fstation'][fi + 5]
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
177
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
178 fi = li + 1
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
179
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
180 expandedDf.drop(['ucs', 'Code_plante', 'Fichier_plante_STICS'], axis = 1, inplace = True)
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
181 expandedDf.to_csv(expandedPlanFileName, index=False, sep = ';')
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
182
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
183 fi = 0
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
184
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
185 for succ in listOfSuccess:
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
186
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
187 li = expandedDf[expandedDf['id_simu'] == succ].index.max()
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
188
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
189 listUofSuccDf = expandedDf.loc[fi:li, "usm_name"].to_frame().reset_index(drop=True)
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
190
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
191 fi = li + 1
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
192
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
193 # Adding the USM Columns Name
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
194 listUofSuccDf['USM'] = 'USM_' + (listUofSuccDf.index + 1).astype(str)
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
195
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
196 # Number of usms inside the succession
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
197 nbUofSucc = listUofSuccDf.shape[0]
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
198
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
199 # in order to prepare the transposition set USM column as index
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
200 listUofSuccDf = listUofSuccDf.set_index('USM')
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
201
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
202 listUofSuccDf = listUofSuccDf.transpose()
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
203
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
204 # complete the data
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
205
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
206 listUofSuccDf['Number_USM'] = nbUofSucc
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
207 listUofSuccDf['Treatment'] = succ
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
208
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
209 # reorder the columns
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
210
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
211 cols = listUofSuccDf.columns.tolist()
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
212 cols = cols[-1:] + cols[-2:-1] + cols [:-2]
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
213
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
214 listUofSuccDf = listUofSuccDf[cols]
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
215
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
216 # complete the list of sucessions
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
217 sucessDf = pd.concat([sucessDf,listUofSuccDf])
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
218
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
219 sucessDf.to_csv(successiveFileName, index=False, sep = ';')