python中loadtxt_python loadtxt读取分隔符fi

使用^{}可以很容易地完成，然后如果需要^{}数组，则可以访问values：import pandas as pd

from io import StringIO

data = """

"07220S006","14/01/12 01:59:50",10,"0"

"07220S006","14/01/12 02:00:00",10,"0"

"07220S006","14/01/12 02:00:10",10,"0"

"""

df = pd.read_csv(StringIO(data), header=None)

print(df)

0 1 2 3

0 07220S006 14/01/12 01:59:50 10 0

1 07220S006 14/01/12 02:00:00 10 0

2 07220S006 14/01/12 02:00:10 10 0

print(df.values)

array([['07220S006', '14/01/12 01:59:50', 10, 0],

['07220S006', '14/01/12 02:00:00', 10, 0],

['07220S006', '14/01/12 02:00:10', 10, 0]], dtype=object)

编辑

IUUC you want to split date column to date and time(or to year，month，etc.)/您可以先用^{}将该列转换为datetime对象，然后使用^{}访问带有{}的字段并将其写入新列：

^{pr2}$

或者，如果您想用^{}转换字符串，例如：print(date_col.dt.strftime("%Y/%m %H:%M"))

0 2012/01 01:59

1 2012/01 02:00

2 2012/01 02:00

Name: 1, dtype: object

您可以很容易地创建：df['year'] = date_col.dt.year

print(df)

0 1 2 3 year

0 07220S006 14/01/12 01:59:50 10 0 2012

1 07220S006 14/01/12 02:00:00 10 0 2012

2 07220S006 14/01/12 02:00:10 10 0 2012