Python数据分析之dataframe索引会这个就行啦

import pandas as pd
import pymysql
conn = pymysql.connect(host='localhost', user='root', passwd='123456', db='test', port=3306, charset='utf8')
jianshu = pd.read_sql('select * from jianshu1',conn)
jianshu

jianshu.ix[0:3]

jianshu.ix[[3,5]]

jianshu.ix[:,0:3]

jianshu.ix[:,['view','gain']]

jianshu.ix[[2,4],['user','title']]