Mercurial > repos > siwaa > redelac_stics_e

annotate redelacPlanExpander.py @ 8:b9e8443bb789 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/6b669674d153581e624f8ad6fed3379e51b70199/tools/REDELACplanExpander commit 6b669674d153581e624f8ad6fed3379e51b70199-dirty"
author siwaa
date Fri, 26 Jun 2026 14:45:33 +0000
parents c8f0edcc1330
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']
8
b9e8443bb789 "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/6b669674d153581e624f8ad6fed3379e51b70199/tools/REDELACplanExpander commit 6b669674d153581e624f8ad6fed3379e51b70199-dirty"
siwaa
parents: 7
diff changeset
120 tmpDf['nomsol'] = row['noms_sols_GC']
0
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
121 else :
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
122 tmpDf['Norg_sols'] = row['Norg_sols_PP']
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
123 tmpDf['nom_sol_sans_point'] = row['nom_sols_PP_dans_USM']
8
b9e8443bb789 "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/6b669674d153581e624f8ad6fed3379e51b70199/tools/REDELACplanExpander commit 6b669674d153581e624f8ad6fed3379e51b70199-dirty"
siwaa
parents: 7
diff changeset
124 tmpDf['nomsol'] = row['noms_sols_PP']
0
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['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
127 tmpDf['maille_safran'] = safran
0
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
128
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
129 # Updating the id_simu column
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
130 # 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
131 # 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
132
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
133 tmpDf['id_simu'] = \
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
134 tmpDf.upc + '-' + \
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
135 tmpDf['nom_sol_sans_point'].astype(str) + '-' + \
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
136 tmpDf['systeme'].astype(str) + '-' + \
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
137 tmpDf['code_rotation'].astype(str) + '-' + \
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
138 tmpDf['tete_rotation'].astype(str) + '-' + \
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
139 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
140
a7463ad6a389 "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/179e64aac208ae8af4d7416a7d5ff4b9da572850/tools/REDELACplanExpander commit 179e64aac208ae8af4d7416a7d5ff4b9da572850-dirty"
siwaa
parents: 3
diff changeset
141
a7463ad6a389 "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/179e64aac208ae8af4d7416a7d5ff4b9da572850/tools/REDELACplanExpander commit 179e64aac208ae8af4d7416a7d5ff4b9da572850-dirty"
siwaa
parents: 3
diff changeset
142 print(tmpDf['id_simu'])
0
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
143
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
144 # 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
145 plantsDf.rename(columns = {'Nom_plante':'culture'}, inplace = True)
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
146 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
147
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
148 # Updating the usm_name column
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
149 # 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
150 # 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
151
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
152 tmpDf['usm_name'] = \
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
153 tmpDf.upc + '-' + \
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
154 tmpDf['nom_sol_sans_point'].astype(str) + '-' + \
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
155 tmpDf['systeme'].astype(str) + '-' + \
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
156 tmpDf['code_rotation'].astype(str) + '-' + \
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
157 tmpDf['tete_rotation'].astype(str) + '-' + \
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
158 tmpDf['horizon '].astype(str) + '-' + \
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
159 tmpDf['annee_fin'].astype(str) + '-' + \
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
160 tmpDf['Code_plante']
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
161
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
162 print(tmpDf['usm_name'])
0
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 # Updating the nomsol column
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
165 # alias =CONCATENATE(G2;"_";H2)
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
166
6
40595ca55c78 "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/fa822bd9c974bf5ffb4e632905dd65c2f097e325/tools/REDELACplanExpander commit fa822bd9c974bf5ffb4e632905dd65c2f097e325-dirty"
siwaa
parents: 5
diff changeset
167 #tmpDf['nomsol'] = \
40595ca55c78 "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/fa822bd9c974bf5ffb4e632905dd65c2f097e325/tools/REDELACplanExpander commit fa822bd9c974bf5ffb4e632905dd65c2f097e325-dirty"
siwaa
parents: 5
diff changeset
168 # tmpDf['num_sol'].astype(str) + '_' + \
40595ca55c78 "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/fa822bd9c974bf5ffb4e632905dd65c2f097e325/tools/REDELACplanExpander commit fa822bd9c974bf5ffb4e632905dd65c2f097e325-dirty"
siwaa
parents: 5
diff changeset
169 # tmpDf['Norg_sols'].astype(str)
0
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
170
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
171 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
172 # 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
173 # alias =CONCATENATE($E2;"_";M2;"_sta.xml")
0
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
174
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
175 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
176 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
177 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
178
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 # 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
180 # 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
181
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 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
183 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
184 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
185
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 # 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
187 # 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
188
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 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
190 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
191 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
192
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
193 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
194 # 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
195 # 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
196
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['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
198 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
199 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
200
5
996b8019f5d5 "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/79e760a19b89e9a2045855e21a9ed1eba52061da/tools/REDELACplanExpander commit 79e760a19b89e9a2045855e21a9ed1eba52061da-dirty"
siwaa
parents: 4
diff changeset
201 # Updating the fclim1 column
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
202 # 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
203
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 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
205 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
206 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
207
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 # 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
209 # 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
210
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 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
212 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
213 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
214
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
215 expandedDf = pd.concat([expandedDf, tmpDf])
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 # now getting the list of simu
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 = pd.DataFrame()
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 listOfSuccessWithNA = expandedDf['id_simu'].unique()
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 # en raison des NA on filtre
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 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
226
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
227 nbL = len(listOfSuccess)
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
228
5
996b8019f5d5 "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/79e760a19b89e9a2045855e21a9ed1eba52061da/tools/REDELACplanExpander commit 79e760a19b89e9a2045855e21a9ed1eba52061da-dirty"
siwaa
parents: 4
diff changeset
229 # fixing stations before to save
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 fi = 0
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 expandedDf.reset_index(inplace = True)
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 for succ in listOfSuccess:
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 li = expandedDf[expandedDf['id_simu'] == succ].index.max()
5
996b8019f5d5 "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/79e760a19b89e9a2045855e21a9ed1eba52061da/tools/REDELACplanExpander commit 79e760a19b89e9a2045855e21a9ed1eba52061da-dirty"
siwaa
parents: 4
diff changeset
238
996b8019f5d5 "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/79e760a19b89e9a2045855e21a9ed1eba52061da/tools/REDELACplanExpander commit 79e760a19b89e9a2045855e21a9ed1eba52061da-dirty"
siwaa
parents: 4
diff changeset
239 # 10 as ref should be reminded
996b8019f5d5 "planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/79e760a19b89e9a2045855e21a9ed1eba52061da/tools/REDELACplanExpander commit 79e760a19b89e9a2045855e21a9ed1eba52061da-dirty"
siwaa
parents: 4
diff changeset
240 expandedDf.loc[fi:li - 1, 'fstation'] = expandedDf['fstation'][fi + 10]
0
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
241
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
242 fi = li + 1
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 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
245 expandedDf.to_csv(expandedPlanFileName, index=False, sep = ';')
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
246
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
247 fi = 0
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
248
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
249 for succ in listOfSuccess:
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
250
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
251 li = expandedDf[expandedDf['id_simu'] == succ].index.max()
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
252
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
253 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
254
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
255 fi = li + 1
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 # Adding the USM Columns Name
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
258 listUofSuccDf['USM'] = 'USM_' + (listUofSuccDf.index + 1).astype(str)
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 # Number of usms inside the succession
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
261 nbUofSucc = listUofSuccDf.shape[0]
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 # 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
264 listUofSuccDf = listUofSuccDf.set_index('USM')
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
265
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
266 listUofSuccDf = listUofSuccDf.transpose()
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
267
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
268 # complete the data
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 listUofSuccDf['Number_USM'] = nbUofSucc
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
271 listUofSuccDf['Treatment'] = succ
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
272
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
273 # reorder the columns
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 cols = listUofSuccDf.columns.tolist()
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
276 cols = cols[-1:] + cols[-2:-1] + cols [:-2]
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
277
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
278 listUofSuccDf = listUofSuccDf[cols]
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 # complete the list of sucessions
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
281 sucessDf = pd.concat([sucessDf,listUofSuccDf])
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
282
bc7ae8dd3d3c "planemo upload for repository https://forgemia.inra.fr/redelac commit 841d6c6ada2dad3dd575d25aab620491fda5c611"
siwaa
parents:
diff changeset
283 sucessDf.to_csv(successiveFileName, index=False, sep = ';')