问读取具有可变列数的CSV文件

EN

wrk = {}
with open('Input.csv') as fp:
    while True:
        cnt1 += 1
        line = fp.readline()
        if not line:
            break
        key = line.strip()
        txt = [ fp.readline().strip() for i in range(4) ]
        txt = '\n'.join(txt)
        wrk[key] = txt
result = { k: pd.read_csv(io.StringIO(v), index_col=[0]) for k, v in wrk.items() }

    Value  Value.1  Value.2
M1      4        6        3
M2      7        3        4
M3     10        2        6

import csv
import pandas as pd
import numpy as np

INPUT_FILE = r"multidf.csv"

my_df_source = {}
rowcount = 0 # no data parsed

# read file into dictionary entries (key: (headers, datarows))
for row in csv.reader(open(INPUT_FILE,"r")):
    if len(row) == 1: # single entry lists are df keys
        if rowcount: # store in-process df, if any
            my_df_source[df_key] = df_headers, df_rows
        df_key = row[0]
        rowcount = 0
    else:
        if rowcount: # rows after row 0 are data
            df_rows.append(row)
        else: # row 0 is headers
            row[0]='index' # create temporary index label
            df_headers = row
            df_rows = []
        rowcount += 1

if rowcount: # store last df
    my_df_source[df_key] = df_headers, df_rows
        
# create dataframes             
my_dfs = {}    
for key,(headers,data) in my_df_source.items():
    my_dfs[key] = pd.DataFrame(np.array(data),columns=headers).set_index('index')
    my_dfs[key].index.name=None # remove temporary label
    
for key, df in my_dfs.items():
    print(key)
    print(df)