将标准输入转换为数据帧

Question

我有标准输入：

'Town3, NYC, Town1, Town4, Town5, Town6, Town2
 67, 69, 60, 63, 65, 69, 95'

我想知道如何将其转换为熊猫数据帧，以便获得：

   Town3  NYC  Town1  Town4  Town5  Town6  Town2
0     67   69     60     63     65     69     95

Answer 1

您可以使用io.StringIO+pd.read_csv：

import pandas as pd
from io import StringIO

s = """Town3, NYC, Town1, Town4, Town5, Town6, Town2
 67, 69, 60, 63, 65, 69, 95"""

df = pd.read_csv(
    StringIO(s),
    sep=r",\s*",
    engine="python",
)

print(df)

印刷品：

   Town3  NYC  Town1  Town4  Town5  Town6  Town2
0     67   69     60     63     65     69     95

Answer 2

将字符串拆分为列表。把它切成两等份。第一部分是列，第二部分是值：

s = 'Town3, NYC, Town1, Town4, Town5, Town6, Town2, 67, 69, 60, 63, 65, 69, 95'
l = s.split(', ')

df = pd.DataFrame([l[len(l)//2:]], columns=l[:len(l)//2])

>>> df

  Town3 NYC Town1 Town4 Town5 Town6 Town2
0    67  69    60    63    65    69    95