teratail
回答率
85.29%
質問するログイン新規登録
トップVisual Studio Codeに関する質問Python　CSVファイルの読み込みについて

編集履歴

回答編集履歴

3

2022/11/22 14:46

投稿

melian
melian

スコア21527

answer CHANGED
@@ -2,11 +2,10 @@
2
2
  ```python
3
3
  import csv
4
4
 
5
- cols = 'ABCDE'
6
5
  with open('sample.txt') as f:
7
- for r in csv.reader(f):
6
+ for r in csv.reader(f):
8
- msg = ','.join(map(''.join, zip(cols, r)))
7
+ msg = ','.join(map(''.join, zip('ABCDE', r)))
9
- print(msg)
8
+ print(msg)
10
9
 
11
10
  # A10,B20,C30,D40,E50
12
11
  # A40,B40,C34,D40,E50

2

2022/11/22 14:41

投稿

melian
melian

スコア21527

answer CHANGED
@@ -2,7 +2,7 @@
2
2
  ```python
3
3
  import csv
4
4
 
5
- cols = [*'ABCDE']
5
+ cols = 'ABCDE'
6
6
  with open('sample.txt') as f:
7
7
  for r in csv.reader(f):
8
8
  msg = ','.join(map(''.join, zip(cols, r)))

1

2022/11/22 11:25

投稿

melian
melian

スコア21527

answer CHANGED
@@ -1,17 +1,16 @@
1
- > pandas をとりあえずインストールしました。
1
+ > データの個数が異なるとき
2
-
3
2
  ```python
4
- import pandas as pd
3
+ import csv
5
4
 
5
+ cols = [*'ABCDE']
6
- df = pd.read_csv('sample.txt', header=None, na_filter=False, dtype=str)
6
+ with open('sample.txt') as f:
7
- dfx = df.set_axis([*'ABCDE'], axis=1).apply(lambda x: x.name + x)
7
+ for r in csv.reader(f):
8
- dfx.to_csv('result.csv', header=None, index=False)
8
+ msg = ','.join(map(''.join, zip(cols, r)))
9
- ```
9
+ print(msg)
10
10
 
11
- **result.csv**
12
- ```csv
13
- A10,B20,C30,D40,E50
11
+ # A10,B20,C30,D40,E50
14
- A40,B40,C34,D40,E50
12
+ # A40,B40,C34,D40,E50
15
- A30,B49,C,D49,E58
13
+ # A30,B49,C,D49,E58
16
- A10,B,C,D39,E40
14
+ # A10,B,C,D39,E40
15
+ # A10,B20,C30
17
16
  ```