Python 数据分析 列表字典解析 + 批量字段拆分

import pandas as pddata_list = []for i in range(60):    item = {        "id":i+1,        "title":f"爆款商品{i+1}",        "spec":{"尺寸":"大号","材质":"塑料","等级":"A类"},        "tag":["热销","包邮"] if i%2==0 else ["新品","折扣"]    }    data_list.append(item)df = pd.DataFrame(data_list)df.to_excel("dict_list_data.xlsx",index=False)print("列表字典嵌套数据生成完成")

import pandas as pdimport astdf = pd.read_excel("dict_list_data.xlsx")# 字符串转字典并拆分字段df["spec"] = df["spec"].apply(ast.literal_eval)df["尺寸"] = df["spec"].apply(lambda x:x["尺寸"])df["材质"] = df["spec"].apply(lambda x:x["材质"])# 标签列表拼接df["tag"] = df["tag"].apply(ast.literal_eval)df["标签"] = df["tag"].apply(lambda x:"," .join(x))# 简单统计print(df[["title","尺寸","材质","标签"]].head())print("\n各标签商品数量：")print(df["标签"].value_counts())