从单个管道分隔的列中获取数据到不同的列

# 原始数据（单个管道分隔的列）
data = "John|Doe|30|Software Engineer"

# 分割符选择（管道符号）
separator = "|"

# 数据切割
fields = data.split(separator)

# 创建新列
column1 = fields[0]
column2 = fields[1]
column3 = fields[2]
column4 = fields[3]

# 打印结果
print("Column 1:", column1)
print("Column 2:", column2)
print("Column 3:", column3)
print("Column 4:", column4)

Column 1: John
Column 2: Doe
Column 3: 30
Column 4: Software Engineer