quattro_4 scribble

scribble 落書き (調べた事をただ落書きする)

Intro to Data Science : Lesson 2

Lesson 2: Data Wrangling
import pandas
baseball_data = pandas.read_csv('xx.csv')
print baseball_data['yyy']
  • Dash Docset
  • Write to csv
    • baseball_data.to_csv(path_to_new_csv)
      • DataFrame.to_csv
  • DataFrame.replace
    • 列の加工
    • aadhaar_data.rename(columns = lambda x: x.replace(' ', '_').lower(), inplace=True)
  • Execute your SQL command against the pandas frame
    • aadhaar_solution = pandasql.sqldf(q.lower(), locals())

Query

    q = """
    SELECT registrar, enrolment_agency FROM aadhaar_data LIMIT 50;
    """

予想以上に長かった (1.5h + 0.5h)

last.fmAPI楽しそう

サイトとしては説明の仕方がCodeSchoolに近い感じ