kaggle入门之pandas

创建 读写

# 创建dataframe格式数据
fruits = pd.DataFrame([[30,21]],columns=['Apples','Bananas'])
fruit_sales = pd.DataFrame([[35,21],[41,34]],columns=['Apples','Bananas'],index=['2017 Sales','2018 Sales'])
# 创建Series格式数据
ingredients = pd.Series(['4 cups','1 cup','2 large','1 can'],index=['Flour','Milk','Eggs','Spam'],name='Dinner')
# 将csv格式数据转换为dataframe格式,index_col=0第一列作为行标签
reviews = pd.read_csv('../input/wine-reviews/winemag-data_first150k.csv',index_col=0)
# 将dataframe格式转换为csv格式数据
animals.to_csv('cows_and_goats.csv')
# 将sql数据转换为dataframe格式
import sqlite3
conn=sqlite3.connect("../input/pitchfork-data/database.sqlite")
music_reviews = pd.read_sql_query("SELECT * FROM artists", conn)

筛选元素

# 取出dataframe第一行
fi