Advertisement
Guest User

Untitled

a guest
Apr 22nd, 2022
51
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 0.44 KB | None | 0 0
  1.     import re
  2.  
  3.     MIXED_CSV_RE = re.compile(r"(?P<Metadata>.*:.*)\n(?P<CSV>(?:(?:\d+,)*(?:\d+)\n?)*)")
  4.  
  5.     header = next(fstr).strip().split(",")
  6.     csvs = []
  7.     comments = []
  8.     for match in MIXED_CSV_RE.finditer(fstr.read()):
  9.         csvs.extend(match.group("CSV").strip().split("\n"))
  10.         comments.append(match.group("Metadata"))
  11.  
  12.     df = pd.DataFrame(csv.reader(csvs), columns=header)
  13.  
  14.     print(comments, header, df)
  15.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement