teratail header banner
teratail header banner
質問するログイン新規登録

回答編集履歴

2

修正

2021/01/13 15:14

投稿

退会済みユーザー
answer CHANGED
@@ -5,6 +5,8 @@
5
5
  import pandas as pd
6
6
  d0 = pd.read_csv('test.csv')
7
7
  newdata = pd.pivot_table(d0, index=['ExNo','M1','M2','M3']).reset_index()
8
-
8
+ # 列の順番を元に戻す
9
+ col = d0.columns.values
10
+ newdata = newdata.loc[:, col]
9
11
  print(newdata)
10
12
  ```

1

修正

2021/01/13 15:14

投稿

退会済みユーザー
answer CHANGED
@@ -4,7 +4,7 @@
4
4
  ```python
5
5
  import pandas as pd
6
6
  d0 = pd.read_csv('test.csv')
7
- newdata = pd.pivot_table(d0, index=['ExNo','M1','M1_wt%','M2','M2_wt%','M3','M3_wt%']).reset_index()
7
+ newdata = pd.pivot_table(d0, index=['ExNo','M1','M2','M3']).reset_index()
8
8
 
9
9
  print(newdata)
10
10
  ```