Pandas sample

Transpose.py

import pandas as pd

# Read the Excel spreadsheet into a pandas DataFrame
df = pd.read_excel('your_spreadsheet.xlsx')

# Specify the columns to keep intact
keep_columns = ['A', 'B', 'C']

# Specify the columns to be transposed
transpose_columns = ['1', '2', '3', '4', '5']

# Transpose the columns into rows
transposed_df = pd.melt(df, id_vars=keep_columns, value_vars=transpose_columns, var_name='Column', value_name='Value')

# Print the transposed DataFrame
print(transposed_df)