from bunch of files I want to extract some info (code is below), but I came across error: “name ‘GH_Pos21X_true’ is not defined”, full error:
JavaScript
x
16
16
1
NameError Traceback (most recent call last)
2
~AppDataLocalTemp/ipykernel_6892/2034911737.py in <module>
3
38 fullname = os.path.join(path, filename)
4
39 #print(fullname)
5
---> 40 PN, GH, GH_Design_standard, GH_Design_mirrored, GH_Distance100, GH_Distance101, GH_Studs, GH_Typgruppe_21_23, GH_Typgruppe_22_24, GH_Typgruppe_21_24, GH_Pos21X, GH_Pos21Y, GH_Pos22X, GH_Pos22Y, GH_Pos23X, GH_Pos23Y, GH_Pos24X, GH_Pos24Y, PP, DS, PI, MT_St53Mirror, MT_St53Angle, MT_St73Mounting, MT_TLA = get_data_from_xml(fullname)
6
41 #print(pn, gh, pp)
7
42 pn_list.append(PN)
8
~AppDataLocalTemp/ipykernel_6892/2435933773.py in get_data_from_xml(path)
9
61 GH_Pos24Y = CompAttrVal.get('Value')
10
62
11
---> 63 if GH_Pos21X_true and GH_Pos23X_true:
12
64 GH_Typgruppe_21_23 = 'x'
13
65 GH_Typgruppe_22_24 = ''
14
15
NameError: name 'GH_Pos21X_true' is not defined
16
Where should I defined it?
Code:
JavaScript
1
305
305
1
def get_data_from_xml(path):
2
#print(path)
3
4
tree = ET.parse(path)
5
root = tree.getroot()
6
7
for Type in root.iter('Type'):
8
PN = Type.get('name')
9
#print(f"Part number: {PN}")
10
DS = Type.get('Desc')
11
#print(f"Description: {DS}")
12
13
for Component in root.iter('Component'):
14
CName = Component.get('name')
15
if CName == 'Pos010_GearHousing':
16
for ComponentNo in Component.iter('ComponentNo'):
17
GH = ComponentNo.get('name')
18
#print(f"Gear Housing: {GH}")
19
for CompAttrVal in Component.iter('CompAttrVal'):
20
GH_AttrVal = CompAttrVal.get('name')
21
if GH_AttrVal == 'GearHousingDesign':
22
GH_Design = CompAttrVal.get('Value')
23
if GH_Design == 'mirrored':
24
GH_Design_standard = ''
25
GH_Design_mirrored = 'x'
26
elif GH_Design == 'standard':
27
GH_Design_standard = 'x'
28
GH_Design_mirrored = ''
29
#GH - ZAM?
30
if GH_AttrVal == 'TieRodDistance':
31
GH_Distance = CompAttrVal.get('Value')
32
if GH_Distance == '100':
33
GH_Distance100 = 'x'
34
GH_Distance101 = ''
35
elif GH_Distance == '101.8':
36
GH_Distance100 = ''
37
GH_Distance101 = 'x'
38
#GH - Riveting Progrs?
39
if GH_AttrVal == 'NumberOfStuds':
40
GH_Studs = CompAttrVal.get('Value')
41
if GH_AttrVal == 'StudPos21X':
42
global GH_Pos21X_true
43
GH_Pos21X = CompAttrVal.get('Value')
44
GH_Pos21X_true = True
45
if GH_AttrVal == 'StudPos21Y':
46
GH_Pos21Y = CompAttrVal.get('Value')
47
if GH_AttrVal == 'StudPos22X':
48
GH_Pos22X = CompAttrVal.get('Value')
49
GH_Pos22X_true = True
50
if GH_AttrVal == 'StudPos22Y':
51
GH_Pos22Y = CompAttrVal.get('Value')
52
if GH_AttrVal == 'StudPos23X':
53
GH_Pos23X = CompAttrVal.get('Value')
54
GH_Pos23X_true = True
55
if GH_AttrVal == 'StudPos23Y':
56
GH_Pos23Y = CompAttrVal.get('Value')
57
if GH_AttrVal == 'StudPos24X':
58
GH_Pos24X = CompAttrVal.get('Value')
59
GH_Pos24X_true = True
60
if GH_AttrVal == 'StudPos24Y':
61
GH_Pos24Y = CompAttrVal.get('Value')
62
63
if GH_Pos21X_true and GH_Pos23X_true:
64
GH_Typgruppe_21_23 = 'x'
65
GH_Typgruppe_22_24 = ''
66
GH_Typgruppe_21_24 = ''
67
elif GH_Pos22X_true and GH_Pos24X_true:
68
GH_Typgruppe_21_23 = ''
69
GH_Typgruppe_22_24 = 'x'
70
GH_Typgruppe_21_24 = ''
71
elif GH_Pos21X_true and GH_Pos22X_true and GH_Pos23X_true and GH_Pos24X_true:
72
GH_Typgruppe_21_23 = ''
73
GH_Typgruppe_22_24 = ''
74
GH_Typgruppe_21_24 = 'x'
75
else:
76
GH_Typgruppe_21_23 = 'keine studs'
77
GH_Typgruppe_22_24 = ''
78
GH_Typgruppe_21_24 = ''
79
80
if CName == 'Pos058_PowerPack':
81
for ComponentNo in Component.iter('ComponentNo'):
82
PP = ComponentNo.get('name')
83
#print(f"Power Pack: {PP}")
84
85
if CName == 'Pos082_PedalInterface':
86
for ComponentNo in Component.iter('ComponentNo'):
87
PI = ComponentNo.get('name')
88
#print(f"Pedal Interface: {PI}")
89
90
if CName == 'MachineTools':
91
for ComponentNo in Component.iter('ComponentNo'):
92
MT = ComponentNo.get('name')
93
if MT == 'St53_DryTesting':
94
for CompAttrVal in Component.iter('CompAttrVal'):
95
MT_St53 = CompAttrVal.get('name')
96
if MT_St53 == 'TesterECUPlugMirror':
97
MT_St53Mirror = CompAttrVal.get('Value')
98
#print(f"Mirror: {MT_St53Mirror}")
99
elif MT_St53 == 'TesterECUPlugAngle':
100
MT_St53Angle = CompAttrVal.get('Value')
101
#print(f"Angle: {MT_St53Angle}")
102
#St. 65 CamCheck???
103
elif MT == 'St73_FirewallGasket':
104
for CompAttrVal in Component.iter('CompAttrVal'):
105
MT_St73 = CompAttrVal.get('name')
106
if MT_St73 == 'Mounting':
107
global MT_St73Mounting
108
MT_St73Mounting = CompAttrVal.get('Value')
109
#print(f"St73: {MT_St73Mounting}")
110
111
if CName == 'Pos088_FirewallGasket':
112
for ComponentNo in Component.iter('ComponentNo'):
113
Pos088 = ComponentNo.get('name')
114
if Pos088 == 'MountingPosition':
115
for CompAttrVal in Component.iter('CompAttrVal'):
116
TLA = CompAttrVal.get('name')
117
if TLA == 'ToolLifterAngle':
118
global MT_TLA
119
MT_TLA = CompAttrVal.get('Value')
120
121
122
#print(PN, GH, PP, DS, PI)
123
return PN, GH, GH_Design_standard, GH_Design_mirrored, GH_Distance100, GH_Distance101, GH_Studs, GH_Typgruppe_21_23, GH_Typgruppe_22_24, GH_Typgruppe_21_24, GH_Pos21X, GH_Pos21Y, GH_Pos22X, GH_Pos22Y, GH_Pos23X, GH_Pos23Y, GH_Pos24X, GH_Pos24Y, PP, DS, PI, MT_St53Mirror, MT_St53Angle, MT_St73Mounting, MT_TLA
124
125
pn_list = []
126
gh_list = []
127
GH_Design_standard_list = []
128
GH_Design_mirrored_list = []
129
GH_ZAM_list = []
130
GH_Distance100_list = []
131
GH_Distance101_list = []
132
GH_RivProg_BTR1_list = []
133
GH_RivProg_BTR2_list = []
134
GH_Studs_list = []
135
GH_Typgruppe_21_23_list = []
136
GH_Typgruppe_22_24_list = []
137
GH_Typgruppe_21_24_list = []
138
GH_Pos21X_list = []
139
GH_Pos21Y_list = []
140
GH_Pos22X_list = []
141
GH_Pos22Y_list = []
142
GH_Pos23X_list = []
143
GH_Pos23Y_list = []
144
GH_Pos24X_list = []
145
GH_Pos24Y_list = []
146
pp_list = []
147
ds_list = []
148
pi_list = []
149
MT_St53Mirror_list = []
150
MT_St53Angle_list = []
151
MT_St65Gasket_list = []
152
MT_St65Spacer_list = []
153
MT_St73Mounting_list = []
154
MT_TLA_list = []
155
156
#generowanie DF
157
path = 'C:/Users/STJ2TW/Desktop/Pliki XML/'
158
for filename in os.listdir(path):
159
if '.' not in filename:
160
if 'MASTER' not in filename:
161
if 'GHOST' not in filename:
162
fullname = os.path.join(path, filename)
163
#print(fullname)
164
PN, GH, GH_Design_standard, GH_Design_mirrored, GH_Distance100, GH_Distance101, GH_Studs, GH_Typgruppe_21_23, GH_Typgruppe_22_24, GH_Typgruppe_21_24, GH_Pos21X, GH_Pos21Y, GH_Pos22X, GH_Pos22Y, GH_Pos23X, GH_Pos23Y, GH_Pos24X, GH_Pos24Y, PP, DS, PI, MT_St53Mirror, MT_St53Angle, MT_St73Mounting, MT_TLA = get_data_from_xml(fullname)
165
#print(pn, gh, pp)
166
pn_list.append(PN)
167
gh_list.append(GH)
168
GH_Design_standard_list.append(GH_Design_standard)
169
GH_Design_mirrored_list.append(GH_Design_mirrored)
170
#GH ZAM??
171
GH_Distance100_list.append(GH_Distance100)
172
GH_Distance101_list.append(GH_Distance101)
173
#GH Riveting Progs?
174
GH_Studs_list.append(GH_Studs)
175
GH_Typgruppe_21_23_list.append(GH_Typgruppe_21_23)
176
GH_Typgruppe_22_24_list.append(GH_Typgruppe_22_24)
177
GH_Typgruppe_21_24_list.append(GH_Typgruppe_21_24)
178
GH_Pos21X_list.append(GH_Pos21X)
179
GH_Pos21Y_list.append(GH_Pos21Y)
180
GH_Pos22X_list.append(GH_Pos22X)
181
GH_Pos22Y_list.append(GH_Pos22Y)
182
GH_Pos23X_list.append(GH_Pos23X)
183
GH_Pos23Y_list.append(GH_Pos23Y)
184
GH_Pos24X_list.append(GH_Pos24X)
185
GH_Pos24Y_list.append(GH_Pos24Y)
186
pp_list.append(PP)
187
ds_list.append(DS)
188
pi_list.append(PI)
189
MT_St53Mirror_list.append(MT_St53Mirror)
190
MT_St53Angle_list.append(MT_St53Angle)
191
#St. 65 CamCheck???
192
MT_St73Mounting_list.append(MT_St73Mounting)
193
MT_TLA_list.append(MT_TLA)
194
195
a = {'Description': ds_list,
196
'Part number': pn_list,
197
'Gear Housing': gh_list,
198
'Power Pack': pp_list,
199
'Pedal Interface': pi_list,
200
'ECU PlugMirror': MT_St53Mirror_list,
201
'ECU PlugAngle': MT_St53Angle_list,
202
'CamProg_Gasket': MT_St65Gasket_list,
203
'CamProg_Spacer': MT_St65Spacer_list,
204
'Mounting ?': MT_St73Mounting_list,
205
'MountingPosition/ToolLifterAngle': MT_TLA_list,
206
'Standard': GH_Design_standard_list,
207
'Mirrored': GH_Design_mirrored_list,
208
'ZAM': GH_ZAM_list,
209
'100 Bore Distance': GH_Distance100_list,
210
'101,8 Bore Distance': GH_Distance101_list,
211
'Program BTR 1': GH_RivProg_BTR1_list,
212
'Program BTR 2': GH_RivProg_BTR2_list,
213
'Number of Stud Bores': GH_Studs_list,
214
'2_Studs_RobPos_21_23': GH_Typgruppe_21_23_list,
215
'2_Studs_RobPos_22_24': GH_Typgruppe_22_24_list,
216
'4_Studs_RobPos_21-24': GH_Typgruppe_21_24_list,
217
'X-Position': GH_Pos21X_list,
218
'Y-Position': GH_Pos21Y_list,
219
'X-Position': GH_Pos22X_list,
220
'Y-Position': GH_Pos22Y_list,
221
'X-Position': GH_Pos23X_list,
222
'Y-Position': GH_Pos23Y_list,
223
'X-Position': GH_Pos24X_list,
224
'Y-Position': GH_Pos24Y_list,
225
226
}
227
228
df = pd.DataFrame.from_dict(a, orient='index')
229
df = df.transpose()
230
231
#zapis DF do pliku
232
df = df.set_index('Description', drop = True)
233
df.to_excel("C:/Users/STJ2TW/Desktop/Pliki CSV/data_frames_from_xml.xlsx", startrow=3, freeze_panes=(5,5))
234
235
#wczytywanie pliku do edycji
236
wb = load_workbook(filename = "C:/Users/STJ2TW/Desktop/Pliki CSV/data_frames_from_xml.xlsx")
237
ws = wb.active
238
sheet = wb["Sheet1"]
239
240
#filtrowanie
241
ws.insert_rows(5)
242
sheet.auto_filter.ref = "A5:DE300"
243
244
#Machine Tools
245
ws.merge_cells('F3:G3')
246
ws.merge_cells('H3:I3')
247
ws.merge_cells('J3:K3')
248
sheet["F3"].value = "St. 53 DryTest"
249
sheet["H3"].value = "St. 65 CamCheck"
250
sheet["J3"].value = "St. 73"
251
252
sheet["F4"].value = "ECU PlugMirror"
253
sheet["G4"].value = "ECU PlugAngle"
254
sheet["H4"].value = "CamProg_Gasket"
255
sheet["I4"].value = "CamProg_Spacer"
256
sheet["J4"].value = "Mounting ?"
257
sheet.column_dimensions['K'].width = 6
258
sheet["K4"].value = "MountingPosition/ToolLifterAngle"
259
260
#Pos.10 GearHousing
261
ws.merge_cells('L3:M3')
262
#N3
263
ws.merge_cells('O3:P3')
264
ws.merge_cells('Q3:R3')
265
#S3
266
ws.merge_cells('T3:V3')
267
ws.merge_cells('W3:X3')
268
ws.merge_cells('Y3:Z3')
269
ws.merge_cells('AA3:AB3')
270
ws.merge_cells('AC3:AD3')
271
sheet["L3"].value = "Design"
272
sheet["N3"].value = "ZAM"
273
sheet["O3"].value = "Tierod"
274
sheet["Q3"].value = "Riveting Progrs."
275
#S3-empty
276
sheet["T3"].value = "Typgruppe"
277
sheet["W3"].value = "RobPos.21"
278
sheet["Y3"].value = "RobPos.22"
279
sheet["AA3"].value = "RobPos.23"
280
sheet["AC3"].value = "RobPos.24"
281
282
sheet["L4"].value = "Standard"
283
sheet["M4"].value = "Mirrored"
284
sheet["N4"].value = "ZAM"
285
sheet["O4"].value = "100 Bore Distance"
286
sheet["P4"].value = "101.8 Bore Distance"
287
sheet["Q4"].value = "Program BTR 1"
288
sheet["R4"].value = "Program BTR 2"
289
sheet["S4"].value = "Number of Stud Bores"
290
sheet["T4"].value = "2_Studs_RobPos_21_23"
291
sheet["U4"].value = "2_Studs_RobPos_22_24"
292
sheet["V4"].value = "4_Studs_RobPos_21-24"
293
sheet["W4"].value = "X-Position"
294
sheet["X4"].value = "Y-Position"
295
sheet["Y4"].value = "X-Position"
296
sheet["Z4"].value = "Y-Position"
297
sheet["AA4"].value = "X-Position"
298
sheet["AB4"].value = "Y-Position"
299
sheet["AC4"].value = "X-Position"
300
sheet["AD4"].value = "Y-Position"
301
302
#zapis sformatowanego pliku do .xlsx
303
wb.save("C:/Users/STJ2TW/Desktop/Pliki CSV/data_frames_from_xml_formatted.xlsx")
304
#df.head(10)
305
I can’t see a problem, maybe someone could help me find my mistake? I will be grateful.
If I don’t set this variable as global I have this error:
JavaScript
1
17
17
1
UnboundLocalError Traceback (most recent call last)
2
~AppDataLocalTemp/ipykernel_6892/2034911737.py in <module>
3
38 fullname = os.path.join(path, filename)
4
39 #print(fullname)
5
---> 40 PN, GH, GH_Design_standard, GH_Design_mirrored, GH_Distance100, GH_Distance101, GH_Studs, GH_Typgruppe_21_23, GH_Typgruppe_22_24, GH_Typgruppe_21_24, GH_Pos21X, GH_Pos21Y, GH_Pos22X, GH_Pos22Y, GH_Pos23X, GH_Pos23Y, GH_Pos24X, GH_Pos24Y, PP, DS, PI, MT_St53Mirror, MT_St53Angle, MT_St73Mounting, MT_TLA = get_data_from_xml(fullname)
6
41 #print(pn, gh, pp)
7
42 pn_list.append(PN)
8
9
~AppDataLocalTemp/ipykernel_6892/1022670823.py in get_data_from_xml(path)
10
60 GH_Pos24Y = CompAttrVal.get('Value')
11
61
12
---> 62 if GH_Pos21X_true and GH_Pos23X_true:
13
63 GH_Typgruppe_21_23 = 'x'
14
64 GH_Typgruppe_22_24 = ''
15
16
UnboundLocalError: local variable 'GH_Pos21X_true' referenced before assignment
17
Part of the file – example:
JavaScript
1
27
27
1
<?xml version="1.0" encoding="UTF-8"?>
2
<root ReleaseDate="2021082310500904" StartDate="2021082310500904" EndDate="00" Version="1.0.0">
3
<Type name="0204N01319-00" Desc="FA VW Golf MIR S1+" OID="73975" SrcOID="73942" TID="3">
4
<Component name="MachineTools" OID="99639" SrcOID="24014" TID="8">
5
<ComponentNo name="St53_DryTesting" OID="73977" SrcOID="73977" TID="19">
6
<CompAttrVal name="TesterECUPlugMirror" OID="73978" SrcOID="73978" TID="10" DataType="String" Value="1"></CompAttrVal>
7
<CompAttrVal name="TesterECUPlugAngle" OID="73979" SrcOID="73979" TID="10" DataType="String" Value="0"></CompAttrVal>
8
</ComponentNo>
9
<ComponentNo name="St73_FirewallGasket" OID="73980" SrcOID="73980" TID="19">
10
<CompAttrVal name="Mounting" OID="73981" SrcOID="73981" TID="10" DataType="String" Value="YES"></CompAttrVal>
11
</ComponentNo>
12
</Component>
13
<Component name="Pos010_GearHousing" OID="95697" SrcOID="379" TID="8">
14
<ComponentNo name="0204860736" OID="30254" SrcOID="30254" TID="19">
15
<CompAttrVal name="GearHousingDesign" OID="30256" SrcOID="30256" TID="10" DataType="String" Value="mirrored"></CompAttrVal>
16
<CompAttrVal name="TieRodDistance" OID="30257" SrcOID="30257" TID="10" DataType="String" Value="100"></CompAttrVal>
17
<CompAttrVal name="NumberOfStuds" OID="30258" SrcOID="30258" TID="10" DataType="String" Value="2"></CompAttrVal>
18
<CompAttrVal name="StudPos21X" OID="30259" SrcOID="30259" TID="10" DataType="String" Value="-13.17"></CompAttrVal>
19
<CompAttrVal name="StudPos21Y" OID="30260" SrcOID="30260" TID="10" DataType="String" Value="49.17"></CompAttrVal>
20
<CompAttrVal name="StudPos23X" OID="30261" SrcOID="30261" TID="10" DataType="String" Value="13.17"></CompAttrVal>
21
<CompAttrVal name="StudPos23Y" OID="30262" SrcOID="30262" TID="10" DataType="String" Value="-49.17"></CompAttrVal>
22
</ComponentNo>
23
</Component>
24
<Component name="Pos012_LabelDMC" OID="97438" SrcOID="380" TID="8">
25
<ComponentNo name="0204844713" OID="13172" SrcOID="444" TID="19"></ComponentNo>
26
</Component>
27
Advertisement
Answer
You are using the ==
comparison operator instead of the assignment operator =
Do this instead
JavaScript
1
4
1
#elif GH_Design == 'standard':
2
#GH_Design_standard = 'x'
3
#GH_Design_mirrored = ''
4