teratail
回答率
85.47%
質問するログイン新規登録
トップに関する質問pandasでデータを読み込むと列がずれてしまう

編集履歴

質問編集履歴

5

解決したため

2019/01/07 12:57

投稿

run1
run1

スコア19

test CHANGED
File without changes
test CHANGED
@@ -63,31 +63,3 @@
63
63
  print(data)
64
64
 
65
65
  ```
66
-
67
-
68
-
69
- ###出力結果
70
-
71
- ```
72
-
73
- [[ -9. -9. -6. -7. -6. nan nan nan nan nan nan nan nan]
74
-
75
- [ -4. 3. 1. 1. 8. nan nan nan nan nan nan nan nan]
76
-
77
- [ -5. -9. -15. -14. -19. nan nan nan nan nan nan nan nan]
78
-
79
- [-17. -14. -10. -13. -12. nan nan nan nan nan nan nan nan]
80
-
81
- [ -6. -8. -4. -6. -6. nan nan nan nan nan nan nan nan]
82
-
83
- [ -9. -14. -14. -15. -17. nan nan nan nan nan nan nan nan]
84
-
85
- [ 0. -1. 2. 8. 14. nan nan nan nan nan nan nan nan]
86
-
87
- [ -8. -8. 0. 5. 7. nan nan nan nan nan nan nan nan]
88
-
89
- [-11. -11. -12. -6. -1. nan nan nan nan nan nan nan nan]
90
-
91
- [ 8. 9. 3. -2. -8. nan nan nan nan nan nan nan nan]]
92
-
93
- ```

4

出力結果の追加

2019/01/07 12:57

投稿

run1
run1

スコア19

test CHANGED
File without changes
test CHANGED
@@ -52,7 +52,7 @@
52
52
 
53
53
  #読みこみ
54
54
 
55
- data_pd=pd.read_csv( 'test-sanpuzu.csv',names=col_names,header=None,\
55
+ data_pd=pd.read_csv( 'test.csv',names=col_names,header=None,\
56
56
 
57
57
  engine='python')
58
58
 
@@ -63,3 +63,31 @@
63
63
  print(data)
64
64
 
65
65
  ```
66
+
67
+
68
+
69
+ ###出力結果
70
+
71
+ ```
72
+
73
+ [[ -9. -9. -6. -7. -6. nan nan nan nan nan nan nan nan]
74
+
75
+ [ -4. 3. 1. 1. 8. nan nan nan nan nan nan nan nan]
76
+
77
+ [ -5. -9. -15. -14. -19. nan nan nan nan nan nan nan nan]
78
+
79
+ [-17. -14. -10. -13. -12. nan nan nan nan nan nan nan nan]
80
+
81
+ [ -6. -8. -4. -6. -6. nan nan nan nan nan nan nan nan]
82
+
83
+ [ -9. -14. -14. -15. -17. nan nan nan nan nan nan nan nan]
84
+
85
+ [ 0. -1. 2. 8. 14. nan nan nan nan nan nan nan nan]
86
+
87
+ [ -8. -8. 0. 5. 7. nan nan nan nan nan nan nan nan]
88
+
89
+ [-11. -11. -12. -6. -1. nan nan nan nan nan nan nan nan]
90
+
91
+ [ 8. 9. 3. -2. -8. nan nan nan nan nan nan nan nan]]
92
+
93
+ ```

3

違う問題が生じたため

2019/01/07 10:36

投稿

run1
run1

スコア19

test CHANGED
@@ -1 +1 @@
1
- pandasでデータを１行目から読み込む方法
1
+ pandasでデータを読み込むと列がずれてしまう
test CHANGED
@@ -12,45 +12,27 @@
12
12
 
13
13
  ```
14
14
 
15
- -1,-2,-2,-6,1,-2,-2,-5,-7,-3,-1,5,-2,-4,-2,-3,7,0,1,
15
+ -13,-11,-8,-9,-9,-6,-7,-6,,,,,,,,
16
16
 
17
- -10,-8,-7,-10,-17,-1,-6,-3,-4,-6,-1,-2,-4,6,-8,-2,-4,-6,-2,
17
+ 5,0,1,-4,3,1,1,8,,,,,,,,
18
18
 
19
- -3,0,-4,-5,-3,-2,-3,-1,-1,-1,8,-6,-3,-5,-8,8,2,1,7,
19
+ -4,-7,-9,-5,-9,-15,-14,-19,,,,,,,,
20
20
 
21
- -7,-1,-2,3,1,-2,-5,2,0,-1,0,5,9,-1,1,-3,5,4,6,
21
+ -11,-10,-13,-17,-14,-10,-13,-12,,,,,,,,
22
22
 
23
- -4,-2,-2,-2,-6,-3,0,-10,-3,-8,-1,5,2,0,6,2,10,10,1,2
23
+ -8,-9,-8,-6,-8,-4,-6,-6,,,,,,,,
24
24
 
25
- -8,-4,0,-2,-13,-6,-6,-3,-11,1,-4,5,-3,2,2,-4,-3,5,-2,1
25
+ -4,-6,-7,-9,-14,-14,-15,-17,,,,,,,,
26
26
 
27
- -1,0,5,-8,-1,-5,-14,-5,-3,-13,-2,9,-7,-4,1,7,3,5,3,-6
27
+ 3,1,-3,0,-1,2,8,14,,,,,,,,
28
28
 
29
- -9,-7,-2,4,3,-2,-2,-2,3,-8,3,-2,-1,9,0,11,6,7,4,4
29
+ -7,-7,-9,-8,-8,0,5,7,,,,,,,,
30
30
 
31
- -4,-4,-7,-3,-3,-5,-4,-7,-3,0,0,0,-4,1,-1,6,6,1,6,8
31
+ -11,-13,-14,-11,-11,-12,-6,-1,,,,,,,,
32
32
 
33
- -7,1,-5,-9,-5,0,1,-5,6,-1,-3,-7,-5,1,2,8,4,2,1,
33
+ 2,6,4,8,9,3,-2,-8,,,,,,,,
34
34
 
35
- -2,-7,-6,0,-6,-1,-4,-4,0,-5,-2,-7,-3,4,-4,6,7,4,4,
35
+
36
-
37
- 2,-3,-2,0,-8,-5,-5,-2,-4,-5,5,-4,-4,-4,-7,1,6,0,8,
38
-
39
- -2,0,-8,-7,2,5,-3,-3,-2,-3,-5,4,-4,-7,6,4,-2,2,,
40
-
41
- 8,1,3,13,0,-7,-7,1,4,1,-4,-7,-7,-5,-7,3,5,8,,
42
-
43
- -3,0,0,-1,4,5,0,4,-1,-3,-3,6,7,2,5,15,0,6,1,
44
-
45
- 2,2,2,5,-3,-1,-1,1,-3,-7,8,-4,-3,4,-1,-4,0,0,,
46
-
47
- -2,6,7,2,6,-2,-2,3,2,-1,-5,-3,-1,-1,0,1,4,-2,,
48
-
49
- 5,-2,1,2,5,4,-2,1,2,8,2,2,2,3,3,2,7,15,,
50
-
51
- -10,4,0,1,3,-4,0,4,1,-3,8,-1,1,0,0,4,-1,-5,,
52
-
53
- 0,-5,-4,-2,1,3,5,0,0,8,5,-6,8,7,-2,-2,2,0,,
54
36
 
55
37
  ```
56
38
 
@@ -62,7 +44,15 @@
62
44
 
63
45
  ```ここに言語名を入力
64
46
 
47
+ #カラム名
48
+
49
+ col_names = ['c{0:02d}'.format(i) for i in range(13)]
50
+
51
+
52
+
53
+ #読みこみ
54
+
65
- data_pd=pd.read_csv( 'test.csv',header=None,names=col_names, \
55
+ data_pd=pd.read_csv( 'test-sanpuzu.csv',names=col_names,header=None,\
66
56
 
67
57
  engine='python')
68
58
 

2

誤字

2019/01/07 10:32

投稿

run1
run1

スコア19

test CHANGED
File without changes
test CHANGED
@@ -12,45 +12,45 @@
12
12
 
13
13
  ```
14
14
 
15
- -1 -2 -2 -6 1 -2 -2 -5 -7 -3 -1 5 -2 -4 -2 -3 7 0 1
15
+ -1,-2,-2,-6,1,-2,-2,-5,-7,-3,-1,5,-2,-4,-2,-3,7,0,1,
16
16
 
17
- -10 -8 -7 -10 -17 -1 -6 -3 -4 -6 -1 -2 -4 6 -8 -2 -4 -6 -2
17
+ -10,-8,-7,-10,-17,-1,-6,-3,-4,-6,-1,-2,-4,6,-8,-2,-4,-6,-2,
18
18
 
19
- -3 0 -4 -5 -3 -2 -3 -1 -1 -1 8 -6 -3 -5 -8 8 2 1 7
19
+ -3,0,-4,-5,-3,-2,-3,-1,-1,-1,8,-6,-3,-5,-8,8,2,1,7,
20
20
 
21
- -7 -1 -2 3 1 -2 -5 2 0 -1 0 5 9 -1 1 -3 5 4 6
21
+ -7,-1,-2,3,1,-2,-5,2,0,-1,0,5,9,-1,1,-3,5,4,6,
22
22
 
23
- -4 -2 -2 -2 -6 -3 0 -10 -3 -8 -1 5 2 0 6 2 10 10 1 2
23
+ -4,-2,-2,-2,-6,-3,0,-10,-3,-8,-1,5,2,0,6,2,10,10,1,2
24
24
 
25
- -8 -4 0 -2 -13 -6 -6 -3 -11 1 -4 5 -3 2 2 -4 -3 5 -2 1
25
+ -8,-4,0,-2,-13,-6,-6,-3,-11,1,-4,5,-3,2,2,-4,-3,5,-2,1
26
26
 
27
- -1 0 5 -8 -1 -5 -14 -5 -3 -13 -2 9 -7 -4 1 7 3 5 3 -6
27
+ -1,0,5,-8,-1,-5,-14,-5,-3,-13,-2,9,-7,-4,1,7,3,5,3,-6
28
28
 
29
- -9 -7 -2 4 3 -2 -2 -2 3 -8 3 -2 -1 9 0 11 6 7 4 4
29
+ -9,-7,-2,4,3,-2,-2,-2,3,-8,3,-2,-1,9,0,11,6,7,4,4
30
30
 
31
- -4 -4 -7 -3 -3 -5 -4 -7 -3 0 0 0 -4 1 -1 6 6 1 6 8
31
+ -4,-4,-7,-3,-3,-5,-4,-7,-3,0,0,0,-4,1,-1,6,6,1,6,8
32
32
 
33
- -7 1 -5 -9 -5 0 1 -5 6 -1 -3 -7 -5 1 2 8 4 2 1
33
+ -7,1,-5,-9,-5,0,1,-5,6,-1,-3,-7,-5,1,2,8,4,2,1,
34
34
 
35
- -2 -7 -6 0 -6 -1 -4 -4 0 -5 -2 -7 -3 4 -4 6 7 4 4
35
+ -2,-7,-6,0,-6,-1,-4,-4,0,-5,-2,-7,-3,4,-4,6,7,4,4,
36
36
 
37
- 2 -3 -2 0 -8 -5 -5 -2 -4 -5 5 -4 -4 -4 -7 1 6 0 8
37
+ 2,-3,-2,0,-8,-5,-5,-2,-4,-5,5,-4,-4,-4,-7,1,6,0,8,
38
38
 
39
- -2 0 -8 -7 2 5 -3 -3 -2 -3 -5 4 -4 -7 6 4 -2 2
39
+ -2,0,-8,-7,2,5,-3,-3,-2,-3,-5,4,-4,-7,6,4,-2,2,,
40
40
 
41
- 8 1 3 13 0 -7 -7 1 4 1 -4 -7 -7 -5 -7 3 5 8
41
+ 8,1,3,13,0,-7,-7,1,4,1,-4,-7,-7,-5,-7,3,5,8,,
42
42
 
43
- -3 0 0 -1 4 5 0 4 -1 -3 -3 6 7 2 5 15 0 6 1
43
+ -3,0,0,-1,4,5,0,4,-1,-3,-3,6,7,2,5,15,0,6,1,
44
44
 
45
- 2 2 2 5 -3 -1 -1 1 -3 -7 8 -4 -3 4 -1 -4 0 0
45
+ 2,2,2,5,-3,-1,-1,1,-3,-7,8,-4,-3,4,-1,-4,0,0,,
46
46
 
47
- -2 6 7 2 6 -2 -2 3 2 -1 -5 -3 -1 -1 0 1 4 -2
47
+ -2,6,7,2,6,-2,-2,3,2,-1,-5,-3,-1,-1,0,1,4,-2,,
48
48
 
49
- 5 -2 1 2 5 4 -2 1 2 8 2 2 2 3 3 2 7 15
49
+ 5,-2,1,2,5,4,-2,1,2,8,2,2,2,3,3,2,7,15,,
50
50
 
51
- -10 4 0 1 3 -4 0 4 1 -3 8 -1 1 0 0 4 -1 -5
51
+ -10,4,0,1,3,-4,0,4,1,-3,8,-1,1,0,0,4,-1,-5,,
52
52
 
53
- 0 -5 -4 -2 1 3 5 0 0 8 5 -6 8 7 -2 -2 2 0
53
+ 0,-5,-4,-2,1,3,5,0,0,8,5,-6,8,7,-2,-2,2,0,,
54
54
 
55
55
  ```
56
56
 

1

誤字

2019/01/07 08:19

投稿

run1
run1

スコア19

test CHANGED
File without changes
test CHANGED
@@ -62,7 +62,7 @@
62
62
 
63
63
  ```ここに言語名を入力
64
64
 
65
- data_pd=pd.read_csv( 'test-sanpuzu.csv',header=None,names=col_names, \
65
+ data_pd=pd.read_csv( 'test.csv',header=None,names=col_names, \
66
66
 
67
67
  engine='python')
68
68