【Python数据清洗 】——数据框行转列，列转行

import pandas as pd

ceshi = pd.read_csv(u'F:/下载/context_data.csv')


# print(ceshi)

# melt行转列
bd = pd.melt(ceshi, id_vars=['context_id','subject_gmt'],value_vars=['browse_count','click_count','like_count','commet_count','reply_count','score_value'], var_name='count_type',value_name='count_value')

# print(bd)


# pivot_table 列转行

mdd = pd.DataFrame(pd.pivot_table(bd, index = ['context_id','subject_gmt'],columns = 'count_type', values = 'count_value'))

# 索引转换为列
mdd.reset_index(inplace=True)

print(mdd)