Python pandas，pandas读取外部数据，读取csv格式数据(read_csv)

 

demo.py（pandas读取csv中的数据）：

# coding=utf-8
import pandas as pd


# pandas读取csv中的数据
df = pd.read_csv("./dogNames.csv")  # 默认把第一行当成标题(列索引)
print(type(df))  # <class 'pandas.core.frame.DataFrame'>
print(df)
'''
          Row_Labels  Count_AnimalName
0              MARCH                 2
1              APRIL                51
2             AUGUST                14
3           DECEMBER                 4
4             SUNDAY                13
5             MONDAY                 4
6             FRIDAY                19
7                JAN                 1
8                JUN                 1
9            JANUARY                 1
'''

# pandas读取mysql中的数据
# df2 = pd.read_sql(sql_sentence,connection)

./dogNames.csv（csv格式数据）：

Row_Labels,Count_AnimalName
MARCH,2
APRIL,51
AUGUST,14
DECEMBER,4
SUNDAY,13
MONDAY,4
FRIDAY,19
JAN,1
JUN,1
JANUARY,1