python怎么能将字符串 转变为一样格式的dataframe

python怎么能将字符串 转变为一样格式的dataframe
如:

cc='''  e   f   g
0  0  10  20
1  1  11  21
2  2  12  22
3  3  13  23
4  4  14  24
5  5  15  25
6  6  16  26'''

直接上代码吧,不多说了

import io
import pandas as pd
if __name__ == "__main__":
    cc = '''  e   f   g
    0  0  10  20
    1  1  11  21
    2  2  12  22
    3  3  13  23
    4  4  14  24
    5  5  15  25
    6  6  16  26'''
    # 将字符串转换为DataFrame
    df = pd.read_csv(io.StringIO(cc), sep='\s+')
    print(df)

结果如下图

img

有帮助麻烦点个解决

https://blog.csdn.net/my__blog/article/details/121608841

import pandas as pd 
import io

cc='''  e   f   g
0  0  10  20
1  1  11  21
2  2  12  22
3  3  13  23
4  4  14  24
5  5  15  25
6  6  16  26'''

df1 = pd.read_csv(io.StringIO(cc))
print(df1)


先把字符串按行读取转为dict,第一行为键值,后面为列值,在将dict导入dataframe。手机打字,没法写代码。

问题已解决,如有帮助还请采纳。

import pandas as pd

cc = '''  e   f   g
0  0  10  20
1  1  11  21
2  2  12  22
3  3  13  23
4  4  14  24
5  5  15  25
6  6  16  26'''


def fun(s):
    columns = s.split('\n')[0].lstrip().rstrip().split('   ')
    data = s.split('\n')[1:]
    dict1 = {}
    i = 0
    for c in columns:
        l = []
        for d in data:
            dd = d.split('  ')[1:]
            l.append(dd[i])
        dict1[c] = l
        i += 1
    df = pd.DataFrame(dict1)
    return df


result = fun(cc)
print(result)