質問編集履歴
2
df_3の数値を修正しました
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -17,7 +17,7 @@
|
|
|
17
17
|
df_2 = pd.DataFrame(data_2)
|
|
18
18
|
|
|
19
19
|
#実行後のイメージ
|
|
20
|
-
data_3={"category":["a","a","a","b","b","c","c","c","c"],"num":[10,8,5,6,
|
|
20
|
+
data_3={"category":["a","a","a","b","b","c","c","c","c"],"num":[10,8,5,6,5,13,9,5,2]}
|
|
21
21
|
df_3= pd.DataFrame(data_3)
|
|
22
22
|
```
|
|
23
23
|
修正
|
1
実行後のイメージを追記いたしました
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -1,16 +1,25 @@
|
|
|
1
1
|
### 前提・実現したいこと
|
|
2
|
-
|
|
2
|
+
df_2の"num"の数値をdf_1にある"categoryの個数毎に上位の数値順に取得した列をdf_1に追加し、df_3を作りたいと考えていますが、方法がわかりません。
|
|
3
3
|
|
|
4
4
|
教えていただけないでしょうか
|
|
5
5
|
|
|
6
|
+
|
|
6
7
|
### 該当のソースコード
|
|
7
8
|
|
|
8
9
|
```python
|
|
9
10
|
import pandas as pd
|
|
10
11
|
import numpy as np
|
|
12
|
+
#実行前のデータ
|
|
11
13
|
data_1 = {"category":["a","a","a","b","b","c","c","c","c"]}
|
|
12
14
|
df_1 = pd.DataFrame(data_1)
|
|
13
15
|
|
|
14
16
|
data_2= {"category":["a","a","a","a","b","b","b","b","c","c","c","c"],"num":[10,8,5,3,6,5,4,3,13,9,5,2]}
|
|
15
17
|
df_2 = pd.DataFrame(data_2)
|
|
18
|
+
|
|
19
|
+
#実行後のイメージ
|
|
20
|
+
data_3={"category":["a","a","a","b","b","c","c","c","c"],"num":[10,8,5,6,3,13,9,5,2]}
|
|
21
|
+
df_3= pd.DataFrame(data_3)
|
|
16
|
-
```
|
|
22
|
+
```
|
|
23
|
+
修正
|
|
24
|
+
|
|
25
|
+
df_1をdf_2の数値に基づいて、df_3にしたいと考えています。
|