如何将DataFrame单列数据转为单行数字序列并写入XML？

方法一：简单字符串拼接实现 #

1. 提取数据并转为空格分隔字符串 #

直接提取DataFrame的单列数据，转换为字符串后用空格连接：

import pandas as pd

# 初始化DataFrame
data = [4, 5, 6, 7, 8, 9, 10, 11]
df = pd.DataFrame(data)

# 生成空格分隔的单行序列字符串
number_sequence = ' '.join(df.iloc[:, 0].astype(str))

2. 生成XML并写入文件 #

把生成的字符串嵌入XML模板，写入文件：

# 构造XML内容
xml_content = f'''  <Or>
   <numbers>
     <example>{number_sequence}</example>
   </numbers>
  </Or>'''

# 写入XML文件
with open('result.xml', 'w', encoding='utf-8') as file:
    file.write(xml_content)

方法二：用XML库生成规范XML #

如果需要处理特殊字符或更规范的结构，使用xml.etree.ElementTree库：

import xml.etree.ElementTree as ET

# 创建XML节点结构
root = ET.Element("Or")
numbers = ET.SubElement(root, "numbers")
example = ET.SubElement(numbers, "example")
example.text = number_sequence

# 格式化XML缩进
ET.indent(root, space='  ')
# 转为字符串并写入文件
xml_str = ET.tostring(root, encoding='unicode')

with open('result.xml', 'w', encoding='utf-8') as file:
    file.write(xml_str)

内容的提问来源于stack exchange，提问作者beginner