I have a CSV file like attached. enter image description here
I'm trying to stack column B through G while using the following code:
import pandas as pd data1 = pd.read_csv("C1_20psi.csv", skiprows=0, nrows=11, header = None, index_col = 0) df1 = pd.DataFrame(data1) df1.columns = ['trial 1','trial 2','trial 3','trial 4','trial 5','trial 6'] df1 = df1.stack() print(df1) df1.to_csv('reformat.csv')
This exported the csv I want as shownenter image description here but I'm not able to add different column headers back into the dataframe, which I will need in order to move columns from other dataframe to this one.
Can anyone help? Or is there a better way to stack data to achieve this format?