吴裕雄--天生自然 python语言数据分析：开普勒系外行星搜索结果

import pandas as pd

pd.DataFrame({‘Yes‘: [50,21],‘No‘: [131,2]})

pd.DataFrame({‘Bob‘: [‘I liked it.‘,‘It was awful.‘],‘Sue‘: [‘Pretty good.‘,‘Bland.‘]})

pd.DataFrame({‘Bob‘: [‘I liked it.‘,‘It was awful.‘],‘Sue‘: [‘Pretty good.‘,‘Bland.‘]},index=[‘Product A‘,‘Product B‘])

pd.Series([1,2,3,4,5])

pd.Series([30,35,40],index=[‘2015 Sales‘,‘2016 Sales‘,‘2017 Sales‘],name=‘Product A‘)

wine_reviews = pd.read_csv("F:kaggleDataSetkepler-exoplanet-search-resultswinemag-data-130k-v2.csv")

wine_reviews.shape

wine_reviews.head()

wine_reviews = pd.read_csv("F:kaggleDataSetkepler-exoplanet-search-resultswinemag-data-130k-v2.csv",index_col=0)
wine_reviews.head()

import sqlite3
conn = sqlite3.connect("F:kaggleDataSetkepler-exoplanet-search-resultsFPA_FOD_20170508.sqlite")

fires = pd.read_sql_query("SELECT * FROM fires",conn)

fires.head()

wine_reviews.head().to_csv("F:kaggleDataSetkepler-exoplanet-search-resultswine_reviews.csv")

conn = sqlite3.connect("F:kaggleDataSetkepler-exoplanet-search-resultsfires.sqlite")
fires.head(10).to_sql("fires",conn)