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)
