# %%
import numpy as np
import pandas as pd
# %%
# 1.一列转为多列,str.split,已确定拆分结果的列数
df = pd.read_excel('./data/demo_05.xlsx', sheet_name='Sheet1')
tb = df['收货地址'].str.split(' ', expand=True)
df['省份'] = tb[0]
df['城市'] = tb[1]
# pd.Series.str.split()
df
# %%
# 2.一列转为多列,不确定拆分结果的列数,split和join方法
df = pd.read_excel('./data/demo_05.xlsx', sheet_name='Sheet2')
df_split = df['商品信息'].str.split(',', expand=True)
df_re = df.join(df_split)
df_re
# %%
# 3.对元素/列表形式的字段拆分
df = pd.DataFrame({
'订单ID': [1, 2, 3, 4],
'数量和价格': [[1, 2],
[3, 4],
[5, 6],
[7, 8]]}