将Python文本表转置为Pandas DF格式，然后转换为CSV格式

import pandas as pd

text_table = [['Name', 'Age', 'Gender'],
              ['John', 25, 'Male'],
              ['Lisa', 30, 'Female'],
              ['Tom', 35, 'Male']]

df = pd.DataFrame(text_table[1:], columns=text_table[0])

df_transposed = df.transpose()

df_transposed.to_csv('transposed_table.csv', index=False)