如何从String中创建一个Pandas DataFrame [英] How to create a Pandas DataFrame from String
本文介绍了如何从String中创建一个Pandas DataFrame的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
为了测试一些功能,我想从一个字符串创建一个 DataFrame
。假设我的测试数据看起来像:
TESTDATA =col1; col2; col3
1; 4.4; 99
2; 4.5; 200
3; 4.7; 65
4; 3.2; 140
将数据读入Pandas DataFrame
?
简单的方法是使用 StringIO
,并将其传送到 pandas.read_csv
函数。例如:
import sys
如果sys.version_info [0] 3:
来自StringIO import StringIO
else:
来自io import StringIO
import pandas as pd
TESTDATA = StringIO col1; col2; col3
1; 4.4; 99
2; 4.5; 200
3; 4.7; 65
4; 3.2; 140
df = pd.read_csv(TESTDATA,sep =;)
In order to test some functionality I would like to create a DataFrame
from a string. Let's say my testdata looks like:
TESTDATA="""col1;col2;col3
1;4.4;99
2;4.5;200
3;4.7;65
4;3.2;140
"""
What is the simplest way to read that data into a Pandas DataFrame
?
解决方案
Simple way to do this was to use StringIO
and pass that to the pandas.read_csv
function. E.g:
import sys
if sys.version_info[0] < 3:
from StringIO import StringIO
else:
from io import StringIO
import pandas as pd
TESTDATA=StringIO("""col1;col2;col3
1;4.4;99
2;4.5;200
3;4.7;65
4;3.2;140
""")
df = pd.read_csv(TESTDATA, sep=";")
这篇关于如何从String中创建一个Pandas DataFrame的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文