My dataframe is:
0 | 1 | 2 | 3 |
---|---|---|---|
a | 1091 | 347 | 2164 |
b | 208 | 284 | 27647 |
c | 0 | 8126 | 22 |
After transposing
0 | a | b | c |
---|---|---|---|
1 | 1.091 | 208 | 0 |
2 | 347 | 284 | 8126 |
3 | 2161 | 27647 | 22 |
JavaScript
x
7
1
df=df.set_index(0)
2
print(df)
3
df = df.T
4
print(df)
5
df = df.sort_values(by=df.index, ascending=True)
6
print(df)
7
But I am getting an error like:
JavaScript
1
2
1
KeyError: Int64Index([1, 2, 3, 4], dtype='int64')
2
I am trying to plot index values to a column but it should be in ascending order because index 3 refers new value but index 1 is an old value in the time range.
JavaScript
1
3
1
fig = px.line(df, x=df.index, y=df['a'])
2
fig.show()
3
Advertisement
Answer
Instead of df.sort_values(by=df.index)
, use df.sort_index
:
JavaScript
1
2
1
df = df.sort_index(ascending=True)
2
Output:
JavaScript
1
6
1
>>> df
2
1 2 3
3
a 1091 347 2164
4
b 208 284 27647
5
c 0 8126 22
6