回答編集履歴
1
追記
answer
CHANGED
|
@@ -30,4 +30,16 @@
|
|
|
30
30
|
df.columns = [f"担当者{i}" for i in range(1, len(df.columns) + 1)]
|
|
31
31
|
|
|
32
32
|
df.to_csv("result.csv")
|
|
33
|
+
```
|
|
34
|
+
|
|
35
|
+
## 追記
|
|
36
|
+
|
|
37
|
+
Pnadasによる縦持ち⇒横持ちデータ構造変換
|
|
38
|
+
[https://teratail.com/questions/186398](https://teratail.com/questions/186398)
|
|
39
|
+
|
|
40
|
+
|
|
41
|
+
```python
|
|
42
|
+
df = df_csv.groupby(["会社名"]).apply(lambda d: d['名前'].reset_index(drop=True)).unstack()
|
|
43
|
+
df = df.rename(columns={i:'担当者{:02d}'.format(i+1) for i in range(10)})
|
|
44
|
+
df
|
|
33
45
|
```
|