Mercurial > repos > siwaa > redelac_stics_e

annotate redelacPlanExpander.py @ 4:a7463ad6a389 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/179e64aac208ae8af4d7416a7d5ff4b9da572850/tools/REDELACplanExpander commit 179e64aac208ae8af4d7416a7d5ff4b9da572850-dirty"
author siwaa
date Mon, 16 Feb 2026 11:45:40 +0000
parents ecbd096ba43b
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]
4
a7463ad6a389 "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/179e64aac208ae8af4d7416a7d5ff4b9da572850/tools/REDELACplanExpander commit 179e64aac208ae8af4d7416a7d5ff4b9da572850-dirty"
siwaa
parents: 3
diff changeset
16 SafranOrDrias = sys.argv[11] == "SAFRAN"
a7463ad6a389 "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/179e64aac208ae8af4d7416a7d5ff4b9da572850/tools/REDELACplanExpander commit 179e64aac208ae8af4d7416a7d5ff4b9da572850-dirty"
siwaa
parents: 3
diff changeset
17
a7463ad6a389 "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/179e64aac208ae8af4d7416a7d5ff4b9da572850/tools/REDELACplanExpander commit 179e64aac208ae8af4d7416a7d5ff4b9da572850-dirty"
siwaa
parents: 3
diff changeset
18 print( sys.argv[11])
a7463ad6a389 "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/179e64aac208ae8af4d7416a7d5ff4b9da572850/tools/REDELACplanExpander commit 179e64aac208ae8af4d7416a7d5ff4b9da572850-dirty"
siwaa
parents: 3
diff changeset
19
a7463ad6a389 "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/179e64aac208ae8af4d7416a7d5ff4b9da572850/tools/REDELACplanExpander commit 179e64aac208ae8af4d7416a7d5ff4b9da572850-dirty"
siwaa
parents: 3
diff changeset
20 print( sys.argv[11] == "SAFRAN")
a7463ad6a389 "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/179e64aac208ae8af4d7416a7d5ff4b9da572850/tools/REDELACplanExpander commit 179e64aac208ae8af4d7416a7d5ff4b9da572850-dirty"
siwaa
parents: 3
diff changeset
21
0
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
22
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
23 # 1) reading the base list of USMs
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
24
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
25 #USMsDf = pd.read_excel(basePlanFileName, sheet_name='USMs')
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
26 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
27
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
28 # 2) reading the list of plant
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
29
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
30 #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
31 plantsDf = pd.read_csv(Liste_plantesFileName, sep=";")
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
32
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
33 # 3) reading the plan
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
34
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
35 planDf = pd.read_csv(planFileName, 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 # 4) reading the "mailles" file
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
38 maillesDf = pd.read_csv(maillesFileName, sep=";")
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
39
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
40 # 5) reading the stations template
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
41 StationsDf = pd.read_csv(StationsFileName, sep=";")
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
42
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
43 aclimParHorizonDf = pd.read_csv(aclimParHorizonFileName, sep=";")
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
44
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
45 latitudeMailleDriasDf = pd.read_csv(latitudeMailleDriasDFileName, sep=";")
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 # 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
48 expandedStationsDf = pd.DataFrame()
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 for i, row in planDf.iterrows():
4
a7463ad6a389 "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/179e64aac208ae8af4d7416a7d5ff4b9da572850/tools/REDELACplanExpander commit 179e64aac208ae8af4d7416a7d5ff4b9da572850-dirty"
siwaa
parents: 3
diff changeset
51
a7463ad6a389 "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/179e64aac208ae8af4d7416a7d5ff4b9da572850/tools/REDELACplanExpander commit 179e64aac208ae8af4d7416a7d5ff4b9da572850-dirty"
siwaa
parents: 3
diff changeset
52 print("I")
a7463ad6a389 "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/179e64aac208ae8af4d7416a7d5ff4b9da572850/tools/REDELACplanExpander commit 179e64aac208ae8af4d7416a7d5ff4b9da572850-dirty"
siwaa
parents: 3
diff changeset
53 print(i)
a7463ad6a389 "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/179e64aac208ae8af4d7416a7d5ff4b9da572850/tools/REDELACplanExpander commit 179e64aac208ae8af4d7416a7d5ff4b9da572850-dirty"
siwaa
parents: 3
diff changeset
54
0
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
55 tmpDf = StationsDf
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
56
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
57 safran = int(row['upc'].split('_')[1])
4
a7463ad6a389 "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/179e64aac208ae8af4d7416a7d5ff4b9da572850/tools/REDELACplanExpander commit 179e64aac208ae8af4d7416a7d5ff4b9da572850-dirty"
siwaa
parents: 3
diff changeset
58
a7463ad6a389 "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/179e64aac208ae8af4d7416a7d5ff4b9da572850/tools/REDELACplanExpander commit 179e64aac208ae8af4d7416a7d5ff4b9da572850-dirty"
siwaa
parents: 3
diff changeset
59 print("safran:")
a7463ad6a389 "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/179e64aac208ae8af4d7416a7d5ff4b9da572850/tools/REDELACplanExpander commit 179e64aac208ae8af4d7416a7d5ff4b9da572850-dirty"
siwaa
parents: 3
diff changeset
60 print(safran)
a7463ad6a389 "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/179e64aac208ae8af4d7416a7d5ff4b9da572850/tools/REDELACplanExpander commit 179e64aac208ae8af4d7416a7d5ff4b9da572850-dirty"
siwaa
parents: 3
diff changeset
61
0
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
62 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
63
4
a7463ad6a389 "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/179e64aac208ae8af4d7416a7d5ff4b9da572850/tools/REDELACplanExpander commit 179e64aac208ae8af4d7416a7d5ff4b9da572850-dirty"
siwaa
parents: 3
diff changeset
64 print("drias:")
a7463ad6a389 "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/179e64aac208ae8af4d7416a7d5ff4b9da572850/tools/REDELACplanExpander commit 179e64aac208ae8af4d7416a7d5ff4b9da572850-dirty"
siwaa
parents: 3
diff changeset
65 print(drias)
a7463ad6a389 "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/179e64aac208ae8af4d7416a7d5ff4b9da572850/tools/REDELACplanExpander commit 179e64aac208ae8af4d7416a7d5ff4b9da572850-dirty"
siwaa
parents: 3
diff changeset
66
0
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
67 tmpDfBis = tmpDf;
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
68
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
69 for j, rowS in tmpDf.iterrows():
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
70 horizon = rowS['Sta_name'].split('_')[1]
4
a7463ad6a389 "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/179e64aac208ae8af4d7416a7d5ff4b9da572850/tools/REDELACplanExpander commit 179e64aac208ae8af4d7416a7d5ff4b9da572850-dirty"
siwaa
parents: 3
diff changeset
71 if SafranOrDrias :
a7463ad6a389 "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/179e64aac208ae8af4d7416a7d5ff4b9da572850/tools/REDELACplanExpander commit 179e64aac208ae8af4d7416a7d5ff4b9da572850-dirty"
siwaa
parents: 3
diff changeset
72 tmpDfBis.at[j, 'Sta_name'] = str(safran) + '_' + horizon + '_sta.xml'
a7463ad6a389 "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/179e64aac208ae8af4d7416a7d5ff4b9da572850/tools/REDELACplanExpander commit 179e64aac208ae8af4d7416a7d5ff4b9da572850-dirty"
siwaa
parents: 3
diff changeset
73
a7463ad6a389 "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/179e64aac208ae8af4d7416a7d5ff4b9da572850/tools/REDELACplanExpander commit 179e64aac208ae8af4d7416a7d5ff4b9da572850-dirty"
siwaa
parents: 3
diff changeset
74 tmpDfBis.at[j, 'aclim'] = aclimParHorizonDf[(aclimParHorizonDf['maille_SAFRAN'] == safran) & (aclimParHorizonDf['horizon'] == horizon)].reset_index(drop=True)["aclim"][0]
a7463ad6a389 "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/179e64aac208ae8af4d7416a7d5ff4b9da572850/tools/REDELACplanExpander commit 179e64aac208ae8af4d7416a7d5ff4b9da572850-dirty"
siwaa
parents: 3
diff changeset
75 tmpDfBis.at[j, 'latitude'] = latitudeMailleDriasDf[(latitudeMailleDriasDf['maille_DRIAS'] == drias)].reset_index(drop=True)["latitude"][0]
a7463ad6a389 "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/179e64aac208ae8af4d7416a7d5ff4b9da572850/tools/REDELACplanExpander commit 179e64aac208ae8af4d7416a7d5ff4b9da572850-dirty"
siwaa
parents: 3
diff changeset
76 else :
a7463ad6a389 "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/179e64aac208ae8af4d7416a7d5ff4b9da572850/tools/REDELACplanExpander commit 179e64aac208ae8af4d7416a7d5ff4b9da572850-dirty"
siwaa
parents: 3
diff changeset
77 tmpDfBis.at[j, 'Sta_name'] = str(drias) + '_' + horizon + '_sta.xml'
a7463ad6a389 "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/179e64aac208ae8af4d7416a7d5ff4b9da572850/tools/REDELACplanExpander commit 179e64aac208ae8af4d7416a7d5ff4b9da572850-dirty"
siwaa
parents: 3
diff changeset
78
a7463ad6a389 "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/179e64aac208ae8af4d7416a7d5ff4b9da572850/tools/REDELACplanExpander commit 179e64aac208ae8af4d7416a7d5ff4b9da572850-dirty"
siwaa
parents: 3
diff changeset
79 tmpDfBis.at[j, 'aclim'] = aclimParHorizonDf[(aclimParHorizonDf['maille_DRIAS'] == drias) & (aclimParHorizonDf['horizon'] == horizon)].reset_index(drop=True)["aclim"][0]
a7463ad6a389 "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/179e64aac208ae8af4d7416a7d5ff4b9da572850/tools/REDELACplanExpander commit 179e64aac208ae8af4d7416a7d5ff4b9da572850-dirty"
siwaa
parents: 3
diff changeset
80 tmpDfBis.at[j, 'latitude'] = latitudeMailleDriasDf[(latitudeMailleDriasDf['maille_DRIAS'] == drias)].reset_index(drop=True)["latitude"][0]
0
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
81
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
82 expandedStationsDf = pd.concat([expandedStationsDf, tmpDfBis])
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
83
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
84 expandedStationsDf.to_csv(expandedStationsFileName, index = False, sep = ';')
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
85
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
86
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
87 # 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
88 expandedDf = pd.DataFrame()
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
89
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
90 # 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
91
ecbd096ba43b "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/b4ec8ff39b5d159c4f9def1a6a450b1fbcd698a2/tools/REDELACplanExpander commit b4ec8ff39b5d159c4f9def1a6a450b1fbcd698a2-dirty"
siwaa
parents: 2
diff changeset
92 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
93 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
94 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
95 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
96
0
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
97 for i, row in planDf.iterrows():
4
a7463ad6a389 "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/179e64aac208ae8af4d7416a7d5ff4b9da572850/tools/REDELACplanExpander commit 179e64aac208ae8af4d7416a7d5ff4b9da572850-dirty"
siwaa
parents: 3
diff changeset
98
a7463ad6a389 "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/179e64aac208ae8af4d7416a7d5ff4b9da572850/tools/REDELACplanExpander commit 179e64aac208ae8af4d7416a7d5ff4b9da572850-dirty"
siwaa
parents: 3
diff changeset
99 print("I")
a7463ad6a389 "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/179e64aac208ae8af4d7416a7d5ff4b9da572850/tools/REDELACplanExpander commit 179e64aac208ae8af4d7416a7d5ff4b9da572850-dirty"
siwaa
parents: 3
diff changeset
100 print(i)
a7463ad6a389 "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/179e64aac208ae8af4d7416a7d5ff4b9da572850/tools/REDELACplanExpander commit 179e64aac208ae8af4d7416a7d5ff4b9da572850-dirty"
siwaa
parents: 3
diff changeset
101
0
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
102 tmpDf = USMsDf
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 safran = int(row['upc'].split('_')[1])
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
105 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
106
4
a7463ad6a389 "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/179e64aac208ae8af4d7416a7d5ff4b9da572850/tools/REDELACplanExpander commit 179e64aac208ae8af4d7416a7d5ff4b9da572850-dirty"
siwaa
parents: 3
diff changeset
107 print("safran:")
a7463ad6a389 "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/179e64aac208ae8af4d7416a7d5ff4b9da572850/tools/REDELACplanExpander commit 179e64aac208ae8af4d7416a7d5ff4b9da572850-dirty"
siwaa
parents: 3
diff changeset
108 print(safran)
a7463ad6a389 "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/179e64aac208ae8af4d7416a7d5ff4b9da572850/tools/REDELACplanExpander commit 179e64aac208ae8af4d7416a7d5ff4b9da572850-dirty"
siwaa
parents: 3
diff changeset
109
a7463ad6a389 "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/179e64aac208ae8af4d7416a7d5ff4b9da572850/tools/REDELACplanExpander commit 179e64aac208ae8af4d7416a7d5ff4b9da572850-dirty"
siwaa
parents: 3
diff changeset
110 print("drias:")
a7463ad6a389 "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/179e64aac208ae8af4d7416a7d5ff4b9da572850/tools/REDELACplanExpander commit 179e64aac208ae8af4d7416a7d5ff4b9da572850-dirty"
siwaa
parents: 3
diff changeset
111 print(drias)
a7463ad6a389 "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/179e64aac208ae8af4d7416a7d5ff4b9da572850/tools/REDELACplanExpander commit 179e64aac208ae8af4d7416a7d5ff4b9da572850-dirty"
siwaa
parents: 3
diff changeset
112
0
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
113 tmpDf['upc'] = row['upc']
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
114 tmpDf['ucs'] = row['ucs']
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
115 tmpDf['num_sol'] = row['num_sol']
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
116
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
117 if typeOfRotation == 'GC' :
0
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
118 tmpDf['Norg_sols'] = row['Norg_sols_GC']
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
119 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
120 else :
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
121 tmpDf['Norg_sols'] = row['Norg_sols_PP']
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
122 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
123
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
124 tmpDf['maille_drias'] = drias
4
a7463ad6a389 "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/179e64aac208ae8af4d7416a7d5ff4b9da572850/tools/REDELACplanExpander commit 179e64aac208ae8af4d7416a7d5ff4b9da572850-dirty"
siwaa
parents: 3
diff changeset
125 tmpDf['maille_safran'] = safran
0
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
126
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
127 # Updating the id_simu column
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
128 # 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
129 # 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
130
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
131 tmpDf['id_simu'] = \
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
132 tmpDf.upc + '-' + \
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
133 tmpDf['nom_sol_sans_point'].astype(str) + '-' + \
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
134 tmpDf['systeme'].astype(str) + '-' + \
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
135 tmpDf['code_rotation'].astype(str) + '-' + \
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
136 tmpDf['tete_rotation'].astype(str) + '-' + \
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
137 tmpDf['horizon '].astype(str)
4
a7463ad6a389 "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/179e64aac208ae8af4d7416a7d5ff4b9da572850/tools/REDELACplanExpander commit 179e64aac208ae8af4d7416a7d5ff4b9da572850-dirty"
siwaa
parents: 3
diff changeset
138
a7463ad6a389 "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/179e64aac208ae8af4d7416a7d5ff4b9da572850/tools/REDELACplanExpander commit 179e64aac208ae8af4d7416a7d5ff4b9da572850-dirty"
siwaa
parents: 3
diff changeset
139
a7463ad6a389 "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/179e64aac208ae8af4d7416a7d5ff4b9da572850/tools/REDELACplanExpander commit 179e64aac208ae8af4d7416a7d5ff4b9da572850-dirty"
siwaa
parents: 3
diff changeset
140 print(tmpDf['id_simu'])
0
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
141
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
142 # 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
143 plantsDf.rename(columns = {'Nom_plante':'culture'}, inplace = True)
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
144 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
145
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
146 # Updating the usm_name column
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
147 # 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
148 # 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
149
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
150 tmpDf['usm_name'] = \
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
151 tmpDf.upc + '-' + \
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
152 tmpDf['nom_sol_sans_point'].astype(str) + '-' + \
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
153 tmpDf['systeme'].astype(str) + '-' + \
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
154 tmpDf['code_rotation'].astype(str) + '-' + \
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
155 tmpDf['tete_rotation'].astype(str) + '-' + \
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
156 tmpDf['horizon '].astype(str) + '-' + \
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
157 tmpDf['annee_fin'].astype(str) + '-' + \
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
158 tmpDf['Code_plante']
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
159
4
a7463ad6a389 "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/179e64aac208ae8af4d7416a7d5ff4b9da572850/tools/REDELACplanExpander commit 179e64aac208ae8af4d7416a7d5ff4b9da572850-dirty"
siwaa
parents: 3
diff changeset
160 print(tmpDf['usm_name'])
0
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 # Updating the nomsol column
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
163 # alias =CONCATENATE(G2;"_";H2)
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
164
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
165 tmpDf['nomsol'] = \
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
166 tmpDf['num_sol'].astype(str) + '_' + \
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
167 tmpDf['Norg_sols'].astype(str)
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
168
4
a7463ad6a389 "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/179e64aac208ae8af4d7416a7d5ff4b9da572850/tools/REDELACplanExpander commit 179e64aac208ae8af4d7416a7d5ff4b9da572850-dirty"
siwaa
parents: 3
diff changeset
169 if SafranOrDrias :
a7463ad6a389 "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/179e64aac208ae8af4d7416a7d5ff4b9da572850/tools/REDELACplanExpander commit 179e64aac208ae8af4d7416a7d5ff4b9da572850-dirty"
siwaa
parents: 3
diff changeset
170 # Updating the fstation column
a7463ad6a389 "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/179e64aac208ae8af4d7416a7d5ff4b9da572850/tools/REDELACplanExpander commit 179e64aac208ae8af4d7416a7d5ff4b9da572850-dirty"
siwaa
parents: 3
diff changeset
171 # alias =CONCATENATE($E2;"_";M2;"_sta.xml")
0
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
172
4
a7463ad6a389 "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/179e64aac208ae8af4d7416a7d5ff4b9da572850/tools/REDELACplanExpander commit 179e64aac208ae8af4d7416a7d5ff4b9da572850-dirty"
siwaa
parents: 3
diff changeset
173 tmpDf['fstation'] = \
a7463ad6a389 "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/179e64aac208ae8af4d7416a7d5ff4b9da572850/tools/REDELACplanExpander commit 179e64aac208ae8af4d7416a7d5ff4b9da572850-dirty"
siwaa
parents: 3
diff changeset
174 tmpDf['maille_safran'].astype(str) + '_' + \
a7463ad6a389 "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/179e64aac208ae8af4d7416a7d5ff4b9da572850/tools/REDELACplanExpander commit 179e64aac208ae8af4d7416a7d5ff4b9da572850-dirty"
siwaa
parents: 3
diff changeset
175 tmpDf['horizon '].astype(str) + '_sta.xml'
a7463ad6a389 "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/179e64aac208ae8af4d7416a7d5ff4b9da572850/tools/REDELACplanExpander commit 179e64aac208ae8af4d7416a7d5ff4b9da572850-dirty"
siwaa
parents: 3
diff changeset
176
a7463ad6a389 "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/179e64aac208ae8af4d7416a7d5ff4b9da572850/tools/REDELACplanExpander commit 179e64aac208ae8af4d7416a7d5ff4b9da572850-dirty"
siwaa
parents: 3
diff changeset
177 # Updating the fclim1 column
a7463ad6a389 "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/179e64aac208ae8af4d7416a7d5ff4b9da572850/tools/REDELACplanExpander commit 179e64aac208ae8af4d7416a7d5ff4b9da572850-dirty"
siwaa
parents: 3
diff changeset
178 # alias =CONCATENATE($E2;".";YEAR(R2))
a7463ad6a389 "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/179e64aac208ae8af4d7416a7d5ff4b9da572850/tools/REDELACplanExpander commit 179e64aac208ae8af4d7416a7d5ff4b9da572850-dirty"
siwaa
parents: 3
diff changeset
179
a7463ad6a389 "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/179e64aac208ae8af4d7416a7d5ff4b9da572850/tools/REDELACplanExpander commit 179e64aac208ae8af4d7416a7d5ff4b9da572850-dirty"
siwaa
parents: 3
diff changeset
180 tmpDf['fclim1'] = \
a7463ad6a389 "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/179e64aac208ae8af4d7416a7d5ff4b9da572850/tools/REDELACplanExpander commit 179e64aac208ae8af4d7416a7d5ff4b9da572850-dirty"
siwaa
parents: 3
diff changeset
181 tmpDf['maille_safran'].astype(str) + '.' + \
a7463ad6a389 "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/179e64aac208ae8af4d7416a7d5ff4b9da572850/tools/REDELACplanExpander commit 179e64aac208ae8af4d7416a7d5ff4b9da572850-dirty"
siwaa
parents: 3
diff changeset
182 pd.to_datetime(tmpDf['Début'], dayfirst = True).dt.year.astype(str)
a7463ad6a389 "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/179e64aac208ae8af4d7416a7d5ff4b9da572850/tools/REDELACplanExpander commit 179e64aac208ae8af4d7416a7d5ff4b9da572850-dirty"
siwaa
parents: 3
diff changeset
183
a7463ad6a389 "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/179e64aac208ae8af4d7416a7d5ff4b9da572850/tools/REDELACplanExpander commit 179e64aac208ae8af4d7416a7d5ff4b9da572850-dirty"
siwaa
parents: 3
diff changeset
184 # Updating the fclim2 column
a7463ad6a389 "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/179e64aac208ae8af4d7416a7d5ff4b9da572850/tools/REDELACplanExpander commit 179e64aac208ae8af4d7416a7d5ff4b9da572850-dirty"
siwaa
parents: 3
diff changeset
185 # alias =CONCATENATE($E2;".";YEAR(S2))
a7463ad6a389 "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/179e64aac208ae8af4d7416a7d5ff4b9da572850/tools/REDELACplanExpander commit 179e64aac208ae8af4d7416a7d5ff4b9da572850-dirty"
siwaa
parents: 3
diff changeset
186
a7463ad6a389 "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/179e64aac208ae8af4d7416a7d5ff4b9da572850/tools/REDELACplanExpander commit 179e64aac208ae8af4d7416a7d5ff4b9da572850-dirty"
siwaa
parents: 3
diff changeset
187 tmpDf['fclim2'] = \
a7463ad6a389 "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/179e64aac208ae8af4d7416a7d5ff4b9da572850/tools/REDELACplanExpander commit 179e64aac208ae8af4d7416a7d5ff4b9da572850-dirty"
siwaa
parents: 3
diff changeset
188 tmpDf['maille_safran'].astype(str) + '.' + \
a7463ad6a389 "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/179e64aac208ae8af4d7416a7d5ff4b9da572850/tools/REDELACplanExpander commit 179e64aac208ae8af4d7416a7d5ff4b9da572850-dirty"
siwaa
parents: 3
diff changeset
189 pd.to_datetime(tmpDf['Fin'], dayfirst = True).dt.year.astype(str)
0
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
190
4
a7463ad6a389 "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/179e64aac208ae8af4d7416a7d5ff4b9da572850/tools/REDELACplanExpander commit 179e64aac208ae8af4d7416a7d5ff4b9da572850-dirty"
siwaa
parents: 3
diff changeset
191 else :
a7463ad6a389 "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/179e64aac208ae8af4d7416a7d5ff4b9da572850/tools/REDELACplanExpander commit 179e64aac208ae8af4d7416a7d5ff4b9da572850-dirty"
siwaa
parents: 3
diff changeset
192 # Updating the fstation column
a7463ad6a389 "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/179e64aac208ae8af4d7416a7d5ff4b9da572850/tools/REDELACplanExpander commit 179e64aac208ae8af4d7416a7d5ff4b9da572850-dirty"
siwaa
parents: 3
diff changeset
193 # alias =CONCATENATE($E2;"_";M2;"_sta.xml")
a7463ad6a389 "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/179e64aac208ae8af4d7416a7d5ff4b9da572850/tools/REDELACplanExpander commit 179e64aac208ae8af4d7416a7d5ff4b9da572850-dirty"
siwaa
parents: 3
diff changeset
194
a7463ad6a389 "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/179e64aac208ae8af4d7416a7d5ff4b9da572850/tools/REDELACplanExpander commit 179e64aac208ae8af4d7416a7d5ff4b9da572850-dirty"
siwaa
parents: 3
diff changeset
195 tmpDf['fstation'] = \
a7463ad6a389 "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/179e64aac208ae8af4d7416a7d5ff4b9da572850/tools/REDELACplanExpander commit 179e64aac208ae8af4d7416a7d5ff4b9da572850-dirty"
siwaa
parents: 3
diff changeset
196 tmpDf['maille_drias'].astype(str) + '_' + \
a7463ad6a389 "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/179e64aac208ae8af4d7416a7d5ff4b9da572850/tools/REDELACplanExpander commit 179e64aac208ae8af4d7416a7d5ff4b9da572850-dirty"
siwaa
parents: 3
diff changeset
197 tmpDf['horizon '].astype(str) + '_sta.xml'
a7463ad6a389 "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/179e64aac208ae8af4d7416a7d5ff4b9da572850/tools/REDELACplanExpander commit 179e64aac208ae8af4d7416a7d5ff4b9da572850-dirty"
siwaa
parents: 3
diff changeset
198
a7463ad6a389 "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/179e64aac208ae8af4d7416a7d5ff4b9da572850/tools/REDELACplanExpander commit 179e64aac208ae8af4d7416a7d5ff4b9da572850-dirty"
siwaa
parents: 3
diff changeset
199 # Updating the fclim1 column
a7463ad6a389 "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/179e64aac208ae8af4d7416a7d5ff4b9da572850/tools/REDELACplanExpander commit 179e64aac208ae8af4d7416a7d5ff4b9da572850-dirty"
siwaa
parents: 3
diff changeset
200 # alias =CONCATENATE($E2;".";YEAR(R2))
a7463ad6a389 "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/179e64aac208ae8af4d7416a7d5ff4b9da572850/tools/REDELACplanExpander commit 179e64aac208ae8af4d7416a7d5ff4b9da572850-dirty"
siwaa
parents: 3
diff changeset
201
a7463ad6a389 "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/179e64aac208ae8af4d7416a7d5ff4b9da572850/tools/REDELACplanExpander commit 179e64aac208ae8af4d7416a7d5ff4b9da572850-dirty"
siwaa
parents: 3
diff changeset
202 tmpDf['fclim1'] = \
a7463ad6a389 "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/179e64aac208ae8af4d7416a7d5ff4b9da572850/tools/REDELACplanExpander commit 179e64aac208ae8af4d7416a7d5ff4b9da572850-dirty"
siwaa
parents: 3
diff changeset
203 tmpDf['maille_drias'].astype(str) + '.' + \
a7463ad6a389 "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/179e64aac208ae8af4d7416a7d5ff4b9da572850/tools/REDELACplanExpander commit 179e64aac208ae8af4d7416a7d5ff4b9da572850-dirty"
siwaa
parents: 3
diff changeset
204 pd.to_datetime(tmpDf['Début'], dayfirst = True).dt.year.astype(str)
a7463ad6a389 "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/179e64aac208ae8af4d7416a7d5ff4b9da572850/tools/REDELACplanExpander commit 179e64aac208ae8af4d7416a7d5ff4b9da572850-dirty"
siwaa
parents: 3
diff changeset
205
a7463ad6a389 "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/179e64aac208ae8af4d7416a7d5ff4b9da572850/tools/REDELACplanExpander commit 179e64aac208ae8af4d7416a7d5ff4b9da572850-dirty"
siwaa
parents: 3
diff changeset
206 # Updating the fclim2 column
a7463ad6a389 "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/179e64aac208ae8af4d7416a7d5ff4b9da572850/tools/REDELACplanExpander commit 179e64aac208ae8af4d7416a7d5ff4b9da572850-dirty"
siwaa
parents: 3
diff changeset
207 # alias =CONCATENATE($E2;".";YEAR(S2))
a7463ad6a389 "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/179e64aac208ae8af4d7416a7d5ff4b9da572850/tools/REDELACplanExpander commit 179e64aac208ae8af4d7416a7d5ff4b9da572850-dirty"
siwaa
parents: 3
diff changeset
208
a7463ad6a389 "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/179e64aac208ae8af4d7416a7d5ff4b9da572850/tools/REDELACplanExpander commit 179e64aac208ae8af4d7416a7d5ff4b9da572850-dirty"
siwaa
parents: 3
diff changeset
209 tmpDf['fclim2'] = \
a7463ad6a389 "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/179e64aac208ae8af4d7416a7d5ff4b9da572850/tools/REDELACplanExpander commit 179e64aac208ae8af4d7416a7d5ff4b9da572850-dirty"
siwaa
parents: 3
diff changeset
210 tmpDf['maille_drias'].astype(str) + '.' + \
a7463ad6a389 "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/179e64aac208ae8af4d7416a7d5ff4b9da572850/tools/REDELACplanExpander commit 179e64aac208ae8af4d7416a7d5ff4b9da572850-dirty"
siwaa
parents: 3
diff changeset
211 pd.to_datetime(tmpDf['Fin'], dayfirst = True).dt.year.astype(str)
0
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
212
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
213 expandedDf = pd.concat([expandedDf, tmpDf])
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
214
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
215 # now getting the list of simu
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
216
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
217 sucessDf = pd.DataFrame()
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 listOfSuccessWithNA = expandedDf['id_simu'].unique()
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
220
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
221 # en raison des NA on filtre
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
222
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
223 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
224
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
225 nbL = len(listOfSuccess)
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
226
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
227 # fixing first station before to save
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
228
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
229 fi = 0
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
230
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
231 expandedDf.reset_index(inplace = True)
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
232
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
233 for succ in listOfSuccess:
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
234
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
235 li = expandedDf[expandedDf['id_simu'] == succ].index.max()
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
236
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
237 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
238
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
239 fi = li + 1
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
240
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
241 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
242 expandedDf.to_csv(expandedPlanFileName, index=False, sep = ';')
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
243
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
244 fi = 0
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
245
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
246 for succ in listOfSuccess:
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
247
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
248 li = expandedDf[expandedDf['id_simu'] == succ].index.max()
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
249
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
250 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
251
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
252 fi = li + 1
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
253
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
254 # Adding the USM Columns Name
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
255 listUofSuccDf['USM'] = 'USM_' + (listUofSuccDf.index + 1).astype(str)
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
256
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
257 # Number of usms inside the succession
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
258 nbUofSucc = listUofSuccDf.shape[0]
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
259
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
260 # 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
261 listUofSuccDf = listUofSuccDf.set_index('USM')
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
262
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
263 listUofSuccDf = listUofSuccDf.transpose()
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
264
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
265 # complete the data
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
266
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
267 listUofSuccDf['Number_USM'] = nbUofSucc
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
268 listUofSuccDf['Treatment'] = succ
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
269
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
270 # reorder the columns
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
271
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
272 cols = listUofSuccDf.columns.tolist()
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
273 cols = cols[-1:] + cols[-2:-1] + cols [:-2]
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
274
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
275 listUofSuccDf = listUofSuccDf[cols]
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
276
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
277 # complete the list of sucessions
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
278 sucessDf = pd.concat([sucessDf,listUofSuccDf])
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
279
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
280 sucessDf.to_csv(successiveFileName, index=False, sep = ';')