Python数据帧只有一列

2024-09-26 22:52:59 发布

您现在位置:Python中文网/ 问答频道 /正文

下面是添加到Python数据帧的文本内容:

                                                    0  1
0                                      Invoice Number   
1   Strahse Road 24                               ...   
2   Bahnhofstrasse 40                             ...  
3   Page 1 /                                      ...  2

我只对整个文本内容有一个列感兴趣。你知道吗

下面是我用来将文本内容添加到数据框的方法:

import pandas as pd
import io

def textToDataFrame(textContent):
    return pd.read_fwf(io.StringIO(textContent), header=None, na_filter=False)

我就是这样得到上述结果的:

dataframe = textToDataFrame(text)
print(dataframe)

我有点不确定我该怎么做,所以我最后只有一(0)列?列的数量可以动态变化,这取决于textContent


Tags: 数据io文本importnumber内容dataframepage
1条回答
网友
1楼 · 发布于 2024-09-26 22:52:59
import pandas as pd

textContent = """Computer enthusiasts and power users, ask on Super User.
Professional system and network administrators, ask on Server Fault.
Users of TeX, LaTeX, ConTeXt, and related typesetting systems, ask on TeX - LaTeX Stack Exchange.
Database administrators and professionals, ask on Database Administrators Stack Exchange.
SharePoint enthusiasts, ask on SharePoint Stack Exchange."""

df = pd.DataFrame(textContent.split("\n"))
print(df)

给出结果:

                                                   0
0  Computer enthusiasts and power users, ask on S...
1  Professional system and network administrators...
2  Users of TeX, LaTeX, ConTeXt, and related type...
3  Database administrators and professionals, ask...
4  SharePoint enthusiasts, ask on SharePoint Stac...

相关问题 更多 >

    热门问题