python pandas 读取excel

注意csv文件必须是utf-8，如果不是，先转换文件格式。（有前面utf-8） 
import numpy as np
import pandas as pd
data_csv = pd.read_table('c:\\2.csv',sep=',')
print("data_csv:")
print(data_csv) 


传统读取csv文件方法 
import csv
csvFile = open("c:\\1.csv","r")
reader = csv.reader(csvFile)  # 返回的是迭代类型
data = []
for item in reader:
    print(item)
    data.append(item)
print(data,"3")
print(data[0],"2")  
print(data[0][0],"1")
csvFile.close()