python csv dataframe_读取csv文件并在Python中返回data.frame

I have a CSV file, "value.txt" with the following content:

the first few rows of the file are :

Date,"price","factor_1","factor_2"

2012-06-11,1600.20,1.255,1.548

2012-06-12,1610.02,1.258,1.554

2012-06-13,1618.07,1.249,1.552

2012-06-14,1624.40,1.253,1.556

2012-06-15,1626.15,1.258,1.552

2012-06-16,1626.15,1.263,1.558

2012-06-17,1626.15,1.264,1.572

In R we can read this file in using

price

and that will return a data.frame which I can use for statistical operations:

> price

> price

Date price factor_1 factor_2

1 2012-06-11 1600.20 1.255 1.548

2 2012-06-12 1610.02 1.258 1.554

3 2012-06-13 1618.07 1.249 1.552

4 2012-06-14 1624.40 1.253 1.556

5 2012-06-15 1626.15 1.258 1.552

6 2012-06-16 1626.15 1.263 1.558

7 2012-06-17 1626.15 1.264 1.572

Is there a Pythonic way to get the same functionality?

解决方案

pandas to the rescue:

import pandas as pd

print pd.read_csv('value.txt')

Date price factor_1 factor_2

0 2012-06-11 1600.20 1.255 1.548

1 2012-06-12 1610.02 1.258 1.554

2 2012-06-13 1618.07 1.249 1.552

3 2012-06-14 1624.40 1.253 1.556

4 2012-06-15 1626.15 1.258 1.552

5 2012-06-16 1626.15 1.263 1.558

6 2012-06-17 1626.15 1.264 1.572

This returns pandas DataFrame that is similar to R's.