从CSV中提取2行并转换为XML。

huangapple
go评论92阅读模式
英文:

pick up 2 rows from csv and convert to xml

问题

以下是代码的翻译部分：

  1. import csv
  2. import xml.etree.ElementTree as ET
  4. # 定义行的名称
  5. row_names = [
  6.     'Time',
  7.     'Client',
  8.     'User',
  9.     'number',
  10.     'processid',
  11.     'program',
  12.     'randomnumber',
  13.     'processidandwp',
  14.     'userclient',
  15.     'transactionid',
  16.     'additional1',
  17.     'additional2',
  18.     'additional3',
  19.     'additional4'
  20. ]
  22. # 创建XML根元素
  23. root = ET.Element("Processes")
  24. counter = 0
  26. # 打开CSV文件
  27. with open("data.csv", 'r') as file:
  28.     csv_reader = csv.reader(file, delimiter="|")
  29.     sub_root = ET.SubElement(root, 'name')
  30.     for row in csv_reader:
  31.         for name in row:
  32.             if counter < len(row_names) and name:
  33.                 ele = ET.SubElement(sub_root, row_names
    0
    +
    网站访问量
    )
  34.                 ele.text = name
  35.                 counter += 1
  37. # 打印生成的XML
  38. ET.dump(root)

这段代码是用于读取CSV文件并生成XML的，可以帮助你将数据转换为期望的XML格式。你需要确保CSV文件中的数据与期望的XML结构相匹配，以便生成正确的输出。

英文:

My text file has 100's of entries like below.. I want my code to catch each event which has 14 or 15 elements seperated by delimiter ( | ) and put them in xml. Each event should be captured in new <name> tag.

6354|,EGZ|2023012711283700|900|DDIC|S000|R_JR_BTCJOBS_GENERATOR||1|25737,00088,B5|SAP_WORKFLOW_WIM_ACTION/11283700&JOB_CLOSE&&&&|43AE5E5C16990580E0063BBEAE21BEA8|42010A2A25FA1EDDA7CN
BDA81EE66224C|0000000000000000000000000000000000000\000000000000000000
6355|,EGZ|2023012711283700|900|DDIC|S000|R_JR_BTCJOBS_GENERATOR||1|25737,00088,B5|SAP_WORKFLOW_WIM_ACTION/11283700&JOB_CLOSE&&&&|43AE5E5C16990580E0063BBEAE21BEA8|42010A2A25FA1EDDA7CN
BDA81EE66224C|0000000000000000000000000000000000000\000000000000000000s

  1. Expected output is this:
  2. &lt;/Processes&gt;
  3.  &lt;?xml version=&#39;1.0&#39; encoding=&#39;utf-8&#39;?&gt;
  4.   &lt;name&gt;
  5.    &lt;Time&gt;6354&lt;/Time&gt;
  6.    &lt;Client&gt;,EGZ&lt;/Client&gt;
  7.    &lt;User&gt;2023012711283700&lt;/User&gt;
  8.    &lt;number&gt;900&lt;/number&gt;
  9.    &lt;processid&gt;DDIC&lt;/processid&gt;
  10.    &lt;program&gt;S000&lt;/program&gt;
  11.    &lt;randomnumber&gt;R_JR_BTCJOBS_GENERATOR&lt;/randomnumber&gt;
  12.    &lt;processidandwp&gt;&lt;/processidandwp&gt;
  13.    &lt;userclient&gt;1&lt;/userclient&gt;
  14.    &lt;transactionid&gt;25737,00088,B5&lt;/transactionid&gt;
  15.    &lt;additional1&gt;text&lt;/additional1&gt;
  16.    &lt;additional2&gt;43AE5E5C16990580E0063BBEAE21BEA8&lt;/additional2&gt;
  17.    &lt;additional3&gt;42010A2A25FA1EDDA7CN&lt;/additional3&gt;
  18.    &lt;additional4&gt;BDA81EE66224C&lt;/additional4&gt;
  19.    &lt;additional5&gt;000000000000000000/00000000000&lt;/additional5&gt;
  20.   &lt;/name&gt;
  21.   &lt;name&gt;
  22.    &lt;Time&gt;6355&lt;/Time&gt;
  23.    &lt;Client&gt;,EGZ&lt;/Client&gt;
  24.    &lt;User&gt;2023012711283700&lt;/User&gt;
  25.    &lt;number&gt;900&lt;/number&gt;
  26.    &lt;processid&gt;DDIC&lt;/processid&gt;
  27.    &lt;program&gt;S000&lt;/program&gt;
  28.    &lt;randomnumber&gt;R_JR_BTCJOBS_GENERATOR&lt;/randomnumber&gt;
  29.    &lt;processidandwp&gt;&lt;/processidandwp&gt;
  30.    &lt;userclient&gt;1&lt;/userclient&gt;
  31.    &lt;transactionid&gt;25737,00088,B5&lt;/transactionid&gt;
  32.    &lt;additional2&gt;43AE5E5C16990580E0063BBEAE21BEA8&lt;/additional2&gt;
  33.    &lt;additional3&gt;42010A2A25FA1EDDA7CN&lt;/additional3&gt;
  34.    &lt;additional4&gt;BDA81EE66224C&lt;/additional4&gt;
  35.    &lt;additional5&gt;000000000000000000/00000000000&lt;/additional5&gt;
  36.   &lt;/name&gt;
  37.  &lt;/Processes&gt;
  39. The current output that I get is this
  40.  &lt;?xml version=&#39;1.0&#39; encoding=&#39;utf-8&#39;?&gt;
  41.  &lt;Processes&gt;
  42.   &lt;name&gt;
  43.   &lt;Time&gt;6354&lt;/Time&gt;
  44.   &lt;Client&gt;,EGZ&lt;/Client&gt;
  45.   &lt;User&gt;2023012711283700&lt;/User&gt;
  46.   &lt;number&gt;900&lt;/number&gt;
  47.   &lt;processid&gt;DDIC&lt;/processid&gt;
  48.   &lt;program&gt;S000&lt;/program&gt;
  49.   &lt;randomnumber&gt;R_JR_BTCJOBS_GENERATOR&lt;/randomnumber&gt;
  50.   &lt;processidandwp&gt;&lt;/processidandwp&gt;
  51.   &lt;userclient&gt;1&lt;/userclient&gt;
  52.   &lt;transactionid&gt;25737,00088,B5&lt;/transactionid&gt;
  53.   &lt;additional1&gt;SAP_WORKFLOW_WIM_ACTION/&lt;/additional1&gt;
  54.   &lt;additional2&gt;43AE5E5C16990580E0063BBEAE21BEA8&lt;/additional2&gt;
  55.   &lt;additional3&gt;42010A2A25FA1EDDA7CN&lt;/additional3&gt;
  56.  &lt;/name&gt;
  57.  &lt;name&gt;
  58.   &lt;Time&gt;BDA81EE66224C&lt;/Time&gt;
  59.   &lt;Client&gt;0000000000000000000000000000000000000
    Expected output is this:
  60. &lt;/Processes&gt;
  61. &lt;?xml version=&#39;1.0&#39; encoding=&#39;utf-8&#39;?&gt;
  62. &lt;name&gt;
  63. &lt;Time&gt;6354&lt;/Time&gt;
  64. &lt;Client&gt;,EGZ&lt;/Client&gt;
  65. &lt;User&gt;2023012711283700&lt;/User&gt;
  66. &lt;number&gt;900&lt;/number&gt;
  67. &lt;processid&gt;DDIC&lt;/processid&gt;
  68. &lt;program&gt;S000&lt;/program&gt;
  69. &lt;randomnumber&gt;R_JR_BTCJOBS_GENERATOR&lt;/randomnumber&gt;
  70. &lt;processidandwp&gt;&lt;/processidandwp&gt;
  71. &lt;userclient&gt;1&lt;/userclient&gt;
  72. &lt;transactionid&gt;25737,00088,B5&lt;/transactionid&gt;
  73. &lt;additional1&gt;text&lt;/additional1&gt;
  74. &lt;additional2&gt;43AE5E5C16990580E0063BBEAE21BEA8&lt;/additional2&gt;
  75. &lt;additional3&gt;42010A2A25FA1EDDA7CN&lt;/additional3&gt;
  76. &lt;additional4&gt;BDA81EE66224C&lt;/additional4&gt;
  77. &lt;additional5&gt;000000000000000000/00000000000&lt;/additional5&gt;
  78. &lt;/name&gt;
  79. &lt;name&gt;
  80. &lt;Time&gt;6355&lt;/Time&gt;
  81. &lt;Client&gt;,EGZ&lt;/Client&gt;
  82. &lt;User&gt;2023012711283700&lt;/User&gt;
  83. &lt;number&gt;900&lt;/number&gt;
  84. &lt;processid&gt;DDIC&lt;/processid&gt;
  85. &lt;program&gt;S000&lt;/program&gt;
  86. &lt;randomnumber&gt;R_JR_BTCJOBS_GENERATOR&lt;/randomnumber&gt;
  87. &lt;processidandwp&gt;&lt;/processidandwp&gt;
  88. &lt;userclient&gt;1&lt;/userclient&gt;
  89. &lt;transactionid&gt;25737,00088,B5&lt;/transactionid&gt;
  90. &lt;additional2&gt;43AE5E5C16990580E0063BBEAE21BEA8&lt;/additional2&gt;
  91. &lt;additional3&gt;42010A2A25FA1EDDA7CN&lt;/additional3&gt;
  92. &lt;additional4&gt;BDA81EE66224C&lt;/additional4&gt;
  93. &lt;additional5&gt;000000000000000000/00000000000&lt;/additional5&gt;
  94. &lt;/name&gt;
  95. &lt;/Processes&gt;
  96. The current output that I get is this
  97. &lt;?xml version=&#39;1.0&#39; encoding=&#39;utf-8&#39;?&gt;
  98. &lt;Processes&gt;
  99. &lt;name&gt;
  100. &lt;Time&gt;6354&lt;/Time&gt;
  101. &lt;Client&gt;,EGZ&lt;/Client&gt;
  102. &lt;User&gt;2023012711283700&lt;/User&gt;
  103. &lt;number&gt;900&lt;/number&gt;
  104. &lt;processid&gt;DDIC&lt;/processid&gt;
  105. &lt;program&gt;S000&lt;/program&gt;
  106. &lt;randomnumber&gt;R_JR_BTCJOBS_GENERATOR&lt;/randomnumber&gt;
  107. &lt;processidandwp&gt;&lt;/processidandwp&gt;
  108. &lt;userclient&gt;1&lt;/userclient&gt;
  109. &lt;transactionid&gt;25737,00088,B5&lt;/transactionid&gt;
  110. &lt;additional1&gt;SAP_WORKFLOW_WIM_ACTION/&lt;/additional1&gt;
  111. &lt;additional2&gt;43AE5E5C16990580E0063BBEAE21BEA8&lt;/additional2&gt;
  112. &lt;additional3&gt;42010A2A25FA1EDDA7CN&lt;/additional3&gt;
  113. &lt;/name&gt;
  114. &lt;name&gt;
  115. &lt;Time&gt;BDA81EE66224C&lt;/Time&gt;
  116. &lt;Client&gt;0000000000000000000000000000000000000\000000000000000000&lt;/Client&gt;
  117. &lt;/name&gt;
  118. &lt;name&gt;
  119. &lt;Time&gt;6355&lt;/Time&gt;
  120. &lt;Client&gt;,EGZ&lt;/Client&gt;
  121. &lt;User&gt;2023012711283700&lt;/User&gt;
  122. &lt;number&gt;900&lt;/number&gt;
  123. &lt;processid&gt;DDIC&lt;/processid&gt;
  124. &lt;program&gt;S000&lt;/program&gt;
  125. &lt;randomnumber&gt;R_JR_BTCJOBS_GENERATOR&lt;/randomnumber&gt;
  126. &lt;processidandwp&gt;&lt;/processidandwp&gt;
  127. &lt;userclient&gt;1&lt;/userclient&gt;
  128. &lt;transactionid&gt;25737,00088,B5&lt;/transactionid&gt;
  129. &lt;additional1&gt;SAP_WORKFLOW_WIM_ACTION/11&lt;/additional1&gt;
  130. &lt;additional2&gt;43AE5E5C16990580E0063BBEAE21BEA8&lt;/additional2&gt;
  131. &lt;additional3&gt;42010A2A25FA1EDDA7CN&lt;/additional3&gt;
  132. &lt;/name&gt;
  133. &lt;name&gt;
  134. &lt;Time&gt;BDA81EE66224C&lt;/Time&gt;
  135. &lt;Client&gt;0000000000000000000000000000000000000\000000000000000000s&lt;/Client&gt;
  136. &lt;/name&gt;
  137. &lt;/Processes&gt;
  138. My code which i got is this:
  139. import csv
  140. import xml.etree.ElementTree as ET
  141. row_names = [
  142. &#39;Time&#39;,
  143. &#39;Client&#39;,
  144. &#39;User&#39;,
  145. &#39;number&#39;,
  146. &#39;processid&#39;,
  147. &#39;program&#39;,
  148. &#39;randomnumber&#39;,
  149. &#39;processidandwp&#39;,
  150. &#39;userclient&#39;,
  151. &#39;transactionid&#39;,
  152. &#39;additional1&#39;,
  153. &#39;additional2&#39;,
  154. &#39;additional3&#39;,
  155. &#39;additional4&#39;
  156. ]
  157. root = ET.Element(&quot;Processes&quot;)
  158. counter = 0
  159. with open(&quot;data.csv&quot;, &#39;r&#39;) as file:
  160. csv_reader = csv.reader(file, delimiter=&quot;|&quot;)
  161. sub_root = ET.SubElement(root, &#39;name&#39;)
  162. for row in csv_reader:
  163. for name in row:
  164. if counter &lt; len(row_names) and name:
  165. ele = ET.SubElement(sub_root, row_names
    0
    +
    网站访问量
    )
  166. ele.text = name
  167. counter += 1
  168. ET.dump(root)
  169. 0000000000000000&lt;/Client&gt;
  170.  &lt;/name&gt;
  171.  &lt;name&gt;
  172.   &lt;Time&gt;6355&lt;/Time&gt;
  173.   &lt;Client&gt;,EGZ&lt;/Client&gt;
  174.   &lt;User&gt;2023012711283700&lt;/User&gt;
  175.   &lt;number&gt;900&lt;/number&gt;
  176.   &lt;processid&gt;DDIC&lt;/processid&gt;
  177.   &lt;program&gt;S000&lt;/program&gt;
  178.   &lt;randomnumber&gt;R_JR_BTCJOBS_GENERATOR&lt;/randomnumber&gt;
  179.   &lt;processidandwp&gt;&lt;/processidandwp&gt;
  180.   &lt;userclient&gt;1&lt;/userclient&gt;
  181.   &lt;transactionid&gt;25737,00088,B5&lt;/transactionid&gt;
  182.   &lt;additional1&gt;SAP_WORKFLOW_WIM_ACTION/11&lt;/additional1&gt;
  183.   &lt;additional2&gt;43AE5E5C16990580E0063BBEAE21BEA8&lt;/additional2&gt;
  184.   &lt;additional3&gt;42010A2A25FA1EDDA7CN&lt;/additional3&gt;
  185.  &lt;/name&gt;
  186.  &lt;name&gt;
  187.   &lt;Time&gt;BDA81EE66224C&lt;/Time&gt;
  188.   &lt;Client&gt;0000000000000000000000000000000000000
    Expected output is this:
  189. &lt;/Processes&gt;
  190. &lt;?xml version=&#39;1.0&#39; encoding=&#39;utf-8&#39;?&gt;
  191. &lt;name&gt;
  192. &lt;Time&gt;6354&lt;/Time&gt;
  193. &lt;Client&gt;,EGZ&lt;/Client&gt;
  194. &lt;User&gt;2023012711283700&lt;/User&gt;
  195. &lt;number&gt;900&lt;/number&gt;
  196. &lt;processid&gt;DDIC&lt;/processid&gt;
  197. &lt;program&gt;S000&lt;/program&gt;
  198. &lt;randomnumber&gt;R_JR_BTCJOBS_GENERATOR&lt;/randomnumber&gt;
  199. &lt;processidandwp&gt;&lt;/processidandwp&gt;
  200. &lt;userclient&gt;1&lt;/userclient&gt;
  201. &lt;transactionid&gt;25737,00088,B5&lt;/transactionid&gt;
  202. &lt;additional1&gt;text&lt;/additional1&gt;
  203. &lt;additional2&gt;43AE5E5C16990580E0063BBEAE21BEA8&lt;/additional2&gt;
  204. &lt;additional3&gt;42010A2A25FA1EDDA7CN&lt;/additional3&gt;
  205. &lt;additional4&gt;BDA81EE66224C&lt;/additional4&gt;
  206. &lt;additional5&gt;000000000000000000/00000000000&lt;/additional5&gt;
  207. &lt;/name&gt;
  208. &lt;name&gt;
  209. &lt;Time&gt;6355&lt;/Time&gt;
  210. &lt;Client&gt;,EGZ&lt;/Client&gt;
  211. &lt;User&gt;2023012711283700&lt;/User&gt;
  212. &lt;number&gt;900&lt;/number&gt;
  213. &lt;processid&gt;DDIC&lt;/processid&gt;
  214. &lt;program&gt;S000&lt;/program&gt;
  215. &lt;randomnumber&gt;R_JR_BTCJOBS_GENERATOR&lt;/randomnumber&gt;
  216. &lt;processidandwp&gt;&lt;/processidandwp&gt;
  217. &lt;userclient&gt;1&lt;/userclient&gt;
  218. &lt;transactionid&gt;25737,00088,B5&lt;/transactionid&gt;
  219. &lt;additional2&gt;43AE5E5C16990580E0063BBEAE21BEA8&lt;/additional2&gt;
  220. &lt;additional3&gt;42010A2A25FA1EDDA7CN&lt;/additional3&gt;
  221. &lt;additional4&gt;BDA81EE66224C&lt;/additional4&gt;
  222. &lt;additional5&gt;000000000000000000/00000000000&lt;/additional5&gt;
  223. &lt;/name&gt;
  224. &lt;/Processes&gt;
  225. The current output that I get is this
  226. &lt;?xml version=&#39;1.0&#39; encoding=&#39;utf-8&#39;?&gt;
  227. &lt;Processes&gt;
  228. &lt;name&gt;
  229. &lt;Time&gt;6354&lt;/Time&gt;
  230. &lt;Client&gt;,EGZ&lt;/Client&gt;
  231. &lt;User&gt;2023012711283700&lt;/User&gt;
  232. &lt;number&gt;900&lt;/number&gt;
  233. &lt;processid&gt;DDIC&lt;/processid&gt;
  234. &lt;program&gt;S000&lt;/program&gt;
  235. &lt;randomnumber&gt;R_JR_BTCJOBS_GENERATOR&lt;/randomnumber&gt;
  236. &lt;processidandwp&gt;&lt;/processidandwp&gt;
  237. &lt;userclient&gt;1&lt;/userclient&gt;
  238. &lt;transactionid&gt;25737,00088,B5&lt;/transactionid&gt;
  239. &lt;additional1&gt;SAP_WORKFLOW_WIM_ACTION/&lt;/additional1&gt;
  240. &lt;additional2&gt;43AE5E5C16990580E0063BBEAE21BEA8&lt;/additional2&gt;
  241. &lt;additional3&gt;42010A2A25FA1EDDA7CN&lt;/additional3&gt;
  242. &lt;/name&gt;
  243. &lt;name&gt;
  244. &lt;Time&gt;BDA81EE66224C&lt;/Time&gt;
  245. &lt;Client&gt;0000000000000000000000000000000000000\000000000000000000&lt;/Client&gt;
  246. &lt;/name&gt;
  247. &lt;name&gt;
  248. &lt;Time&gt;6355&lt;/Time&gt;
  249. &lt;Client&gt;,EGZ&lt;/Client&gt;
  250. &lt;User&gt;2023012711283700&lt;/User&gt;
  251. &lt;number&gt;900&lt;/number&gt;
  252. &lt;processid&gt;DDIC&lt;/processid&gt;
  253. &lt;program&gt;S000&lt;/program&gt;
  254. &lt;randomnumber&gt;R_JR_BTCJOBS_GENERATOR&lt;/randomnumber&gt;
  255. &lt;processidandwp&gt;&lt;/processidandwp&gt;
  256. &lt;userclient&gt;1&lt;/userclient&gt;
  257. &lt;transactionid&gt;25737,00088,B5&lt;/transactionid&gt;
  258. &lt;additional1&gt;SAP_WORKFLOW_WIM_ACTION/11&lt;/additional1&gt;
  259. &lt;additional2&gt;43AE5E5C16990580E0063BBEAE21BEA8&lt;/additional2&gt;
  260. &lt;additional3&gt;42010A2A25FA1EDDA7CN&lt;/additional3&gt;
  261. &lt;/name&gt;
  262. &lt;name&gt;
  263. &lt;Time&gt;BDA81EE66224C&lt;/Time&gt;
  264. &lt;Client&gt;0000000000000000000000000000000000000\000000000000000000s&lt;/Client&gt;
  265. &lt;/name&gt;
  266. &lt;/Processes&gt;
  267. My code which i got is this:
  268. import csv
  269. import xml.etree.ElementTree as ET
  270. row_names = [
  271. &#39;Time&#39;,
  272. &#39;Client&#39;,
  273. &#39;User&#39;,
  274. &#39;number&#39;,
  275. &#39;processid&#39;,
  276. &#39;program&#39;,
  277. &#39;randomnumber&#39;,
  278. &#39;processidandwp&#39;,
  279. &#39;userclient&#39;,
  280. &#39;transactionid&#39;,
  281. &#39;additional1&#39;,
  282. &#39;additional2&#39;,
  283. &#39;additional3&#39;,
  284. &#39;additional4&#39;
  285. ]
  286. root = ET.Element(&quot;Processes&quot;)
  287. counter = 0
  288. with open(&quot;data.csv&quot;, &#39;r&#39;) as file:
  289. csv_reader = csv.reader(file, delimiter=&quot;|&quot;)
  290. sub_root = ET.SubElement(root, &#39;name&#39;)
  291. for row in csv_reader:
  292. for name in row:
  293. if counter &lt; len(row_names) and name:
  294. ele = ET.SubElement(sub_root, row_names
    0
    +
    网站访问量
    )
  295. ele.text = name
  296. counter += 1
  297. ET.dump(root)
  298. 0000000000000000s&lt;/Client&gt;
  299.  &lt;/name&gt;
  300. &lt;/Processes&gt;
  302. My code which i got is this:
  303. import csv
  304. import xml.etree.ElementTree as ET
  306. row_names = [
  307.  &#39;Time&#39;,
  308.  &#39;Client&#39;,
  309.  &#39;User&#39;,
  310.  &#39;number&#39;,
  311.  &#39;processid&#39;,
  312.  &#39;program&#39;,
  313.  &#39;randomnumber&#39;,
  314.  &#39;processidandwp&#39;,
  315.  &#39;userclient&#39;,
  316.  &#39;transactionid&#39;,
  317.  &#39;additional1&#39;,
  318.  &#39;additional2&#39;,
  319.  &#39;additional3&#39;,
  320.  &#39;additional4&#39;
  321. ]
  322. root = ET.Element(&quot;Processes&quot;)
  323. counter = 0
  324. with open(&quot;data.csv&quot;, &#39;r&#39;) as file:
  325.  csv_reader = csv.reader(file, delimiter=&quot;|&quot;)
  326.  sub_root = ET.SubElement(root, &#39;name&#39;)
  327.  for row in csv_reader:
  328.     for name in row:
  329.         if counter &lt; len(row_names) and name:
  330.             ele = ET.SubElement(sub_root, row_names
    0
    +
    网站访问量
    )
  331.             ele.text = name
  332.             counter += 1
  334. ET.dump(root)

If you see my current output vs expected output, I want to have the expected output. For now...when the code reads the rows from the file, as soon as it reaches the 2nd row ( for the 1st event) or 4th row ( for the 2nd event) , it creates a new <name> tag. Does it make sense?

答案1

得分: 1

假设在 data.csv 文件中有偶数行。以下重构后的 Python 代码可能适用于您。将每两行组合成一个以管道分隔的记录，然后将其拆分为数组。对于数组中的每个项目，使用row_names 数组中相应的节点名称构建 XML 节点。

  1. import xml.etree.ElementTree as ET
  2. import itertools
  4. node_names = ['Time', 'Client', 'User', 'number', 'processid',
  5. 'program', 'randomnumber', 'processidandwp', 'userclient', 'transactionid',
  6. 'additional1', 'additional2', 'additional3', 'additional4', 'additional5']
  8. root = ET.Element('Processes')
  9. with open('data.csv') as f:
  10.     for l1, l2 in itertools.zip_longest(*[f]*2):
  11.         sub_root = ET.SubElement(root, 'name')
  12.         for idx, item in "".join([l1.strip(), l2.strip()]).split("|"):
  13.             ele = ET.SubElement(sub_root, node_names[idx])
  14.             ele.text = item
  16. ET.indent(root, space="  ", level=0)
  17. ET.dump(root)

输出：

  1. <Processes>
  2.   <name>
  3.     <Time>6354</Time>
  4.     <Client>,EGZ</Client>
  5.     <User>2023012711283700</User>
  6.     <number>900</number>
  7.     <processid>DDIC</processid>
  8.     <program>S000</program>
  9.     <randomnumber>R_JR_BTCJOBS_GENERATOR</randomnumber>
  10.     <processidandwp />
  11.     <userclient>1</userclient>
  12.     <transactionid>25737,00088,B5</transactionid>
  13.     <additional1>SAP_WORKFLOW_WIM_ACTION/11283700&amp;amp;JOB_CLOSE&amp;amp;&amp;amp;&amp;amp;&amp;amp;&lt;/additional1>
  14.     <additional2>43AE5E5C16990580E0063BBEAE21BEA8</additional2>
  15.     <additional3>42010A2A25FA1EDDA7CNBDA81EE66224C</additional3>
  16.     <additional4>0000000000000000000000000000000000000
    <Processes>
  17.   <name>
  18.     <Time>6354</Time>
  19.     <Client>,EGZ</Client>
  20.     <User>2023012711283700</User>
  21.     <number>900</number>
  22.     <processid>DDIC</processid>
  23.     <program>S000</program>
  24.     <randomnumber>R_JR_BTCJOBS_GENERATOR</randomnumber>
  25.     <processidandwp />
  26.     <userclient>1</userclient>
  27.     <transactionid>25737,00088,B5</transactionid>
  28.     <additional1>SAP_WORKFLOW_WIM_ACTION/11283700&amp;amp;JOB_CLOSE&amp;amp;&amp;amp;&amp;amp;&amp;amp;&lt;/additional1>
  29.     <additional2>43AE5E5C16990580E0063BBEAE21BEA8</additional2>
  30.     <additional3>42010A2A25FA1EDDA7CNBDA81EE66224C</additional3>
  31.     <additional4>0000000000000000000000000000000000000\000000000000000000</additional4>
  32.   </name>
  33.   <name>
  34.     <Time>6355</Time>
  35.     <Client>,EGZ</Client>
  36.     <User>2023012711283700</User>
  37.     <number>900</number>
  38.     <processid>DDIC</processid>
  39.     <program>S000</program>
  40.     <randomnumber>R_JR_BTCJOBS_GENERATOR</randomnumber>
  41.     <processidandwp />
  42.     <userclient>1</userclient>
  43.     <transactionid>25737,00088,B5</transactionid>
  44.     <additional1>SAP_WORKFLOW_WIM_ACTION/11283700&amp;amp;JOB_CLOSE&amp;amp;&amp;amp;&amp;amp;&amp;amp;&lt;/additional1>
  45.     <additional2>43AE5E5C16990580E0063BBEAE21BEA8</additional2>
  46.     <additional3>42010A2A25FA1EDDA7CNBDA81EE66224C</additional3>
  47.     <additional4>0000000000000000000000000000000000000\000000000000000000s</additional4>
  48.   </name>
  49. </Processes>
  50. 0000000000000000</additional4>
  51.   </name>
  52.   <name>
  53.     <Time>6355</Time>
  54.     <Client>,EGZ</Client>
  55.     <User>2023012711283700</User>
  56.     <number>900</number>
  57.     <processid>DDIC</processid>
  58.     <program>S000</program>
  59.     <randomnumber>R_JR_BTCJOBS_GENERATOR</randomnumber>
  60.     <processidandwp />
  61.     <userclient>1</userclient>
  62.     <transactionid>25737,00088,B5</transactionid>
  63.     <additional1>SAP_WORKFLOW_WIM_ACTION/11283700&amp;amp;JOB_CLOSE&amp;amp;&amp;amp;&amp;amp;&amp;amp;&lt;/additional1>
  64.     <additional2>43AE5E5C16990580E0063BBEAE21BEA8</additional2>
  65.     <additional3>42010A2A25FA1EDDA7CNBDA81EE66224C</additional3>
  66.     <additional4>0000000000000000000000000000000000000
    <Processes>
  67.   <name>
  68.     <Time>6354</Time>
  69.     <Client>,EGZ</Client>
  70.     <User>2023012711283700</User>
  71.     <number>900</number>
  72.     <processid>DDIC</processid>
  73.     <program>S000</program>
  74.     <randomnumber>R_JR_BTCJOBS_GENERATOR</randomnumber>
  75.     <processidandwp />
  76.     <userclient>1</userclient>
  77.     <transactionid>25737,00088,B5</transactionid>
  78.     <additional1>SAP_WORKFLOW_WIM_ACTION/11283700&amp;amp;JOB_CLOSE&amp;amp;&amp;amp;&amp;amp;&amp;amp;&lt;/additional1>
  79.     <additional2>43AE5E5C16990580E0063BBEAE21BEA8</additional2>
  80.     <additional3>42010A2A25FA1EDDA7CNBDA81EE66224C</additional3>
  81.     <additional4>0000000000000000000000000000000000000\000000000000000000</additional4>
  82.   </name>
  83.   <name>
  84.     <Time>6355</Time>
  85.     <Client>,EGZ</Client>
  86.     <User>2023012711283700</User>
  87.     <number>900</number>
  88.     <processid>DDIC</processid>
  89.     <program>S000</program>
  90.     <randomnumber>R_JR_BTCJOBS_GENERATOR</randomnumber>
  91.     <processidandwp />
  92.     <userclient>1</userclient>
  93.     <transactionid>25737,00088,B5</transactionid>
  94.     <additional1>SAP_WORKFLOW_WIM_ACTION/11283700&amp;amp;JOB_CLOSE&amp;amp;&amp;amp;&amp;amp;&amp;amp;&lt;/additional1>
  95.     <additional2>43AE5E5C16990580E0063BBEAE21BEA8</additional2>
  96.     <additional3>42010A2A25FA1EDDA7CNBDA81EE66224C</additional3>
  97.     <additional4>0000000000000000000000000000000000000\000000000000000000s</additional4>
  98.   </name>
  99. </Processes>
  100. 0000000000000000s</additional4>
  101.   </name>
  102. </Processes>

验证源文件 data.csv 包含 4 行：

  1. wc -l data.csv
  2.        4 data.csv
英文:

Assuming an even number of lines in data.csv. The following refactored python code may work for you. Combine every 2 lines into a single pipe-delimited record that is split into an array. For each item in the array build an XML node using the corresponding node name from the row_names array.

  1. import xml.etree.ElementTree as ET
  2. import itertools
  4. node_names = [&#39;Time&#39;,&#39;Client&#39;,&#39;User&#39;,&#39;number&#39;,&#39;processid&#39;,
  5. &#39;program&#39;,&#39;randomnumber&#39;,&#39;processidandwp&#39;,&#39;userclient&#39;,&#39;transactionid&#39;,
  6. &#39;additional1&#39;,&#39;additional2&#39;,&#39;additional3&#39;,&#39;additional4&#39;,&#39;additional5&#39;]
  8. root = ET.Element(&#39;Processes&#39;)
  9. with open(&#39;data.csv&#39;) as f:
  10.     for l1,l2 in itertools.zip_longest(*[f]*2):
  11.         sub_root = ET.SubElement(root, &#39;name&#39;)
  12.         for idx, item in enumerate(&quot;&quot;.join([l1.strip(), l2.strip()]).split(&quot;|&quot;)):
  13.             ele = ET.SubElement(sub_root, node_names[idx])
  14.             ele.text = item
  16. ET.indent(root, space=&quot;  &quot;, level=0)
  17. ET.dump(root)

Output:

  1. &lt;Processes&gt;
  2.   &lt;name&gt;
  3.     &lt;Time&gt;6354&lt;/Time&gt;
  4.     &lt;Client&gt;,EGZ&lt;/Client&gt;
  5.     &lt;User&gt;2023012711283700&lt;/User&gt;
  6.     &lt;number&gt;900&lt;/number&gt;
  7.     &lt;processid&gt;DDIC&lt;/processid&gt;
  8.     &lt;program&gt;S000&lt;/program&gt;
  9.     &lt;randomnumber&gt;R_JR_BTCJOBS_GENERATOR&lt;/randomnumber&gt;
  10.     &lt;processidandwp /&gt;
  11.     &lt;userclient&gt;1&lt;/userclient&gt;
  12.     &lt;transactionid&gt;25737,00088,B5&lt;/transactionid&gt;
  13.     &lt;additional1&gt;SAP_WORKFLOW_WIM_ACTION/11283700&amp;amp;JOB_CLOSE&amp;amp;&amp;amp;&amp;amp;&amp;amp;&lt;/additional1&gt;
  14.     &lt;additional2&gt;43AE5E5C16990580E0063BBEAE21BEA8&lt;/additional2&gt;
  15.     &lt;additional3&gt;42010A2A25FA1EDDA7CNBDA81EE66224C&lt;/additional3&gt;
  16.     &lt;additional4&gt;0000000000000000000000000000000000000
    &lt;Processes&gt;
  17. &lt;name&gt;
  18. &lt;Time&gt;6354&lt;/Time&gt;
  19. &lt;Client&gt;,EGZ&lt;/Client&gt;
  20. &lt;User&gt;2023012711283700&lt;/User&gt;
  21. &lt;number&gt;900&lt;/number&gt;
  22. &lt;processid&gt;DDIC&lt;/processid&gt;
  23. &lt;program&gt;S000&lt;/program&gt;
  24. &lt;randomnumber&gt;R_JR_BTCJOBS_GENERATOR&lt;/randomnumber&gt;
  25. &lt;processidandwp /&gt;
  26. &lt;userclient&gt;1&lt;/userclient&gt;
  27. &lt;transactionid&gt;25737,00088,B5&lt;/transactionid&gt;
  28. &lt;additional1&gt;SAP_WORKFLOW_WIM_ACTION/11283700&amp;amp;JOB_CLOSE&amp;amp;&amp;amp;&amp;amp;&amp;amp;&lt;/additional1&gt;
  29. &lt;additional2&gt;43AE5E5C16990580E0063BBEAE21BEA8&lt;/additional2&gt;
  30. &lt;additional3&gt;42010A2A25FA1EDDA7CNBDA81EE66224C&lt;/additional3&gt;
  31. &lt;additional4&gt;0000000000000000000000000000000000000\000000000000000000&lt;/additional4&gt;
  32. &lt;/name&gt;
  33. &lt;name&gt;
  34. &lt;Time&gt;6355&lt;/Time&gt;
  35. &lt;Client&gt;,EGZ&lt;/Client&gt;
  36. &lt;User&gt;2023012711283700&lt;/User&gt;
  37. &lt;number&gt;900&lt;/number&gt;
  38. &lt;processid&gt;DDIC&lt;/processid&gt;
  39. &lt;program&gt;S000&lt;/program&gt;
  40. &lt;randomnumber&gt;R_JR_BTCJOBS_GENERATOR&lt;/randomnumber&gt;
  41. &lt;processidandwp /&gt;
  42. &lt;userclient&gt;1&lt;/userclient&gt;
  43. &lt;transactionid&gt;25737,00088,B5&lt;/transactionid&gt;
  44. &lt;additional1&gt;SAP_WORKFLOW_WIM_ACTION/11283700&amp;amp;JOB_CLOSE&amp;amp;&amp;amp;&amp;amp;&amp;amp;&lt;/additional1&gt;
  45. &lt;additional2&gt;43AE5E5C16990580E0063BBEAE21BEA8&lt;/additional2&gt;
  46. &lt;additional3&gt;42010A2A25FA1EDDA7CNBDA81EE66224C&lt;/additional3&gt;
  47. &lt;additional4&gt;0000000000000000000000000000000000000\000000000000000000s&lt;/additional4&gt;
  48. &lt;/name&gt;
  49. &lt;/Processes&gt;
  50. 0000000000000000&lt;/additional4&gt;
  51.   &lt;/name&gt;
  52.   &lt;name&gt;
  53.     &lt;Time&gt;6355&lt;/Time&gt;
  54.     &lt;Client&gt;,EGZ&lt;/Client&gt;
  55.     &lt;User&gt;2023012711283700&lt;/User&gt;
  56.     &lt;number&gt;900&lt;/number&gt;
  57.     &lt;processid&gt;DDIC&lt;/processid&gt;
  58.     &lt;program&gt;S000&lt;/program&gt;
  59.     &lt;randomnumber&gt;R_JR_BTCJOBS_GENERATOR&lt;/randomnumber&gt;
  60.     &lt;processidandwp /&gt;
  61.     &lt;userclient&gt;1&lt;/userclient&gt;
  62.     &lt;transactionid&gt;25737,00088,B5&lt;/transactionid&gt;
  63.     &lt;additional1&gt;SAP_WORKFLOW_WIM_ACTION/11283700&amp;amp;JOB_CLOSE&amp;amp;&amp;amp;&amp;amp;&amp;amp;&lt;/additional1&gt;
  64.     &lt;additional2&gt;43AE5E5C16990580E0063BBEAE21BEA8&lt;/additional2&gt;
  65.     &lt;additional3&gt;42010A2A25FA1EDDA7CNBDA81EE66224C&lt;/additional3&gt;
  66.     &lt;additional4&gt;0000000000000000000000000000000000000
    &lt;Processes&gt;
  67. &lt;name&gt;
  68. &lt;Time&gt;6354&lt;/Time&gt;
  69. &lt;Client&gt;,EGZ&lt;/Client&gt;
  70. &lt;User&gt;2023012711283700&lt;/User&gt;
  71. &lt;number&gt;900&lt;/number&gt;
  72. &lt;processid&gt;DDIC&lt;/processid&gt;
  73. &lt;program&gt;S000&lt;/program&gt;
  74. &lt;randomnumber&gt;R_JR_BTCJOBS_GENERATOR&lt;/randomnumber&gt;
  75. &lt;processidandwp /&gt;
  76. &lt;userclient&gt;1&lt;/userclient&gt;
  77. &lt;transactionid&gt;25737,00088,B5&lt;/transactionid&gt;
  78. &lt;additional1&gt;SAP_WORKFLOW_WIM_ACTION/11283700&amp;amp;JOB_CLOSE&amp;amp;&amp;amp;&amp;amp;&amp;amp;&lt;/additional1&gt;
  79. &lt;additional2&gt;43AE5E5C16990580E0063BBEAE21BEA8&lt;/additional2&gt;
  80. &lt;additional3&gt;42010A2A25FA1EDDA7CNBDA81EE66224C&lt;/additional3&gt;
  81. &lt;additional4&gt;0000000000000000000000000000000000000\000000000000000000&lt;/additional4&gt;
  82. &lt;/name&gt;
  83. &lt;name&gt;
  84. &lt;Time&gt;6355&lt;/Time&gt;
  85. &lt;Client&gt;,EGZ&lt;/Client&gt;
  86. &lt;User&gt;2023012711283700&lt;/User&gt;
  87. &lt;number&gt;900&lt;/number&gt;
  88. &lt;processid&gt;DDIC&lt;/processid&gt;
  89. &lt;program&gt;S000&lt;/program&gt;
  90. &lt;randomnumber&gt;R_JR_BTCJOBS_GENERATOR&lt;/randomnumber&gt;
  91. &lt;processidandwp /&gt;
  92. &lt;userclient&gt;1&lt;/userclient&gt;
  93. &lt;transactionid&gt;25737,00088,B5&lt;/transactionid&gt;
  94. &lt;additional1&gt;SAP_WORKFLOW_WIM_ACTION/11283700&amp;amp;JOB_CLOSE&amp;amp;&amp;amp;&amp;amp;&amp;amp;&lt;/additional1&gt;
  95. &lt;additional2&gt;43AE5E5C16990580E0063BBEAE21BEA8&lt;/additional2&gt;
  96. &lt;additional3&gt;42010A2A25FA1EDDA7CNBDA81EE66224C&lt;/additional3&gt;
  97. &lt;additional4&gt;0000000000000000000000000000000000000\000000000000000000s&lt;/additional4&gt;
  98. &lt;/name&gt;
  99. &lt;/Processes&gt;
  100. 0000000000000000s&lt;/additional4&gt;
  101.   &lt;/name&gt;
  102. &lt;/Processes&gt;

Verification that source data.csv has 4 lines:

  1. wc -l data.csv 
  2.        4 data.csv

huangapple
  • 本文由 发表于 2023年2月8日 22:21:45
  • 转载请务必保留本文链接：https://go.coder-hub.com/75387137.html
  • csv
  • python
  • python-3.x
  • xml
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定