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)
结果如下图
有帮助麻烦点个解决
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)