質問編集履歴
4
冒頭の元データと出力データを実際にコードで読み込んだものに修正
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -8,24 +8,25 @@
|
|
|
8
8
|
身体測定
|
|
9
9
|
3月1日
|
|
10
10
|
Aクラス
|
|
11
|
-
ID
|
|
11
|
+
ID sex kg cm
|
|
12
12
|
1 男 34 134
|
|
13
|
-
2 女 44 145
|
|
14
|
-
|
|
13
|
+
2 男 46 121
|
|
15
|
-
|
|
14
|
+
3 男 54 110
|
|
16
|
-
|
|
15
|
+
4 男 23 126
|
|
17
|
-
|
|
16
|
+
5 女 75 164
|
|
18
|
-
|
|
17
|
+
6 女 34 131
|
|
19
|
-
|
|
18
|
+
7 女 44 121
|
|
20
|
-
|
|
19
|
+
8 女 55 151
|
|
21
20
|
|
|
21
|
+
|
|
22
22
|
＜出力データ＞ファイル名：Aクラス_身長
|
|
23
|
-
range
|
|
23
|
+
range cm
|
|
24
|
-
100-110
|
|
24
|
+
0 100-110 0
|
|
25
|
-
110-120
|
|
25
|
+
1 110-120 1
|
|
26
|
-
120-130
|
|
26
|
+
2 120-130 3
|
|
27
|
-
130-140
|
|
27
|
+
3 130-140 2
|
|
28
28
|
|
|
29
|
+
|
|
29
30
|
〇自分で調べたこと
|
|
30
31
|
・pandasのインポート
|
|
31
32
|
・フォルダ内のCSVのパス取得（出力時のファイル名変更に使用）→glob関数
|
3
一つのファイルの出力はできた
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -65,4 +65,28 @@
|
|
|
65
65
|
count_130 = (len(rannge_130))
|
|
66
66
|
count_140 = (len(rannge_140))
|
|
67
67
|
|
|
68
|
-
lists = [count_110, count_120, count_130, count_140]
|
|
68
|
+
lists = [count_110, count_120, count_130, count_140]
|
|
69
|
+
|
|
70
|
+
◎追記３（何とか一つのファイルの出力はできました）
|
|
71
|
+
|
|
72
|
+
import pandas as pd
|
|
73
|
+
import glob
|
|
74
|
+
|
|
75
|
+
file = glob.glob('input/*.csv')
|
|
76
|
+
|
|
77
|
+
df = pd.read_csv("input/A.csv", header=3)
|
|
78
|
+
rannge_110 = (df.query('100 <= cm < 110'))
|
|
79
|
+
rannge_120 = (df.query('110 <= cm < 120'))
|
|
80
|
+
rannge_130 = (df.query('120 <= cm < 130'))
|
|
81
|
+
rannge_140 = (df.query('130 <= cm < 140'))
|
|
82
|
+
|
|
83
|
+
count_110 = (len(rannge_110))
|
|
84
|
+
count_120 = (len(rannge_120))
|
|
85
|
+
count_130 = (len(rannge_130))
|
|
86
|
+
count_140 = (len(rannge_140))
|
|
87
|
+
|
|
88
|
+
cm = [count_110, count_120, count_130, count_140]
|
|
89
|
+
range = ["110","120","130","140"]
|
|
90
|
+
dict = {'range': range,'cm': cm}
|
|
91
|
+
df2 = pd.DataFrame(dict)
|
|
92
|
+
df2.to_csv('A_output.csv')
|
2
追記で自分ができる限りのコードを記入②
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -45,4 +45,24 @@
|
|
|
45
45
|
rannge_110 = (df.query('100 <= cm < 110'))
|
|
46
46
|
rannge_120 = (df.query('110 <= cm < 120'))
|
|
47
47
|
rannge_130 = (df.query('120 <= cm < 130'))
|
|
48
|
-
rannge_140 = (df.query('130 <= cm < 140'))
|
|
48
|
+
rannge_140 = (df.query('130 <= cm < 140'))
|
|
49
|
+
|
|
50
|
+
◎追記2
|
|
51
|
+
|
|
52
|
+
import pandas as pd
|
|
53
|
+
import glob
|
|
54
|
+
|
|
55
|
+
file = glob.glob('input/*.csv')
|
|
56
|
+
|
|
57
|
+
df = pd.read_csv("input/A.csv", header=3)
|
|
58
|
+
rannge_110 = (df.query('100 <= cm < 110'))
|
|
59
|
+
rannge_120 = (df.query('110 <= cm < 120'))
|
|
60
|
+
rannge_130 = (df.query('120 <= cm < 130'))
|
|
61
|
+
rannge_140 = (df.query('130 <= cm < 140'))
|
|
62
|
+
|
|
63
|
+
count_110 = (len(rannge_110))
|
|
64
|
+
count_120 = (len(rannge_120))
|
|
65
|
+
count_130 = (len(rannge_130))
|
|
66
|
+
count_140 = (len(rannge_140))
|
|
67
|
+
|
|
68
|
+
lists = [count_110, count_120, count_130, count_140]
|
1
追記で自分ができる限りのコードを記入
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -35,4 +35,14 @@
|
|
|
35
35
|
どのようにコードしたらよいかわからずご質問させていただきました。
|
|
36
36
|
|
|
37
37
|
何卒ご教授いただければ幸いです。
|
|
38
|
-
よろしくお願いいたします
|
|
38
|
+
よろしくお願いいたします
|
|
39
|
+
|
|
40
|
+
◎追記
|
|
41
|
+
|
|
42
|
+
import pandas as pd
|
|
43
|
+
|
|
44
|
+
df = pd.read_csv("./A.csv",header=3)
|
|
45
|
+
rannge_110 = (df.query('100 <= cm < 110'))
|
|
46
|
+
rannge_120 = (df.query('110 <= cm < 120'))
|
|
47
|
+
rannge_130 = (df.query('120 <= cm < 130'))
|
|
48
|
+
rannge_140 = (df.query('130 <= cm < 140'))
|