python - 从空格分隔的csv中提取特定数据(Extracting specific data from a whitespace separated csv [closed])

Question

Closed) . 已关闭) 。) This question needs to be more focused . 这个问题需要更加集中 。) It is not currently accepting answers. 它当前不接受答案。)

---

Want to improve this question?)

(想改善这个问题吗？))

Update the question so it focuses on one problem only by editing this post .

(更新问题，使其仅通过编辑此帖子来关注一个问题。)

Closed 2 hours ago .

(2小时前关闭。)

I need a script to extract data from multiple whitespace separated csv's.

(我需要一个脚本来从多个空格分隔的csv中提取数据。)

Following is the data that is there in each csv:

(以下是每个csv中的数据：)

H   156898900   0         50K     0 6 -1 WIN002862      1   Hondrus JHUHUGHJHHHHHHHH :18:08ytrvhNN :12B:
## $$$$ :18:9ynnnhNN :12B:     98uu    WIN00876   1   Hondrus

Output Needed, two columns in a dataframe, ID & MID:

(需要输出，数据帧中的两列，ID和MID：)

[ID            MID
08ytrvhNN     002862
9ynnnhNN      00876][1]

Using the below code which is not working---

(使用以下无效的代码-)

import glob
files = glob.glob('*.csv')
strings = []
for file in files:
  with open(file, "r", encoding='UTF-8') as fobj:
      text = fobj.read()
  import re
  a = re.compile(':18:(.*) :12N:')
  b=re.compile('WIN(.*)Hondrus')
  z = a.findall(text)
  k=b.findall(text)
  strings.append(z[0] + "," + k[0])

  ask by Ryan translate from so

Answer 1

等待大神答复