2023-07-20excel pandas 库中explode

import pandas as pd

# Load the Excel file into a pandas DataFrame

df = pd.read_excel('C:/Users/zhaoshan/Desktop/short.xlsx', sheet_name='Sheet2')

df['Pangenome_ALLmerge']=df['Pangenome_ALLmerge'].str.split(',')

df_exploded = df.explode('Pangenome_ALLmerge')

# Sort the DataFrame by Orthogroup

#df_long = df_long.sort_values('Orthogroup')

# Save the long-format DataFrame to a excel file

df_exploded.to_excel('C:/Users/zhaoshan/Desktop/long2.xlsx', sheet_name= 'Sheet1', index=True)

如果有多列，可以先merge，再explode

import pandas as pd

# Load the Excel file into a pandas DataFrame

df = pd.read_excel('C:/Users/zhaoshan/Desktop/short.xlsx', sheet_name='Tabelle1')

print(df)

# 合并两列

df["c"] = df["MGAL10B.pep"].str.cat(df["Pangenome_ALLmerge"], sep=",")

df = df.drop(['MGAL10B.pep', 'Pangenome_ALLmerge'], axis=1)

df['c']=df['c'].str.split(',')

df_exploded = df.explode('c')

print(df_exploded)

df_exploded.to_csv('C:/Users/zhaoshan/Desktop/long4.csv', index=True)

df_exploded.to_csv('C:/Users/zhaoshan/Desktop/long3.csv', index=False)