This question expands off of a previous question of mine: Copy a Multi-Index column of a Pandas Dataframe including the second header
EDIT - Clarifying that one of my issues deals with the discrepancy when N=1
(produces an Index
dataframe) and when N>1
(produces a MultiIndex
dataframe...)
Background - I have a dataset with N
headers that I've read from a CSV. N
can be anything greater than or equal to 1...
e.g. N=1
:
df = pd.read_csv(file, header=[0:N])
print(df)
A B C
--------------- (Single-)Index dataframe
0 1 2 3
1 4 5 6
2 7 8 9
...
e.g. N=3
:
df = pd.read_csv(file, header=[0:N])
print(df)
A B C
a b c
ɑ β