Importing Data

Ha Khanh Nguyen (hknguyen)


1. Importing Modules/Libraries

1.1 What is pandas?

"pandas is a fast, powerful, flexible and easy to use open source data analysis and manipulation tool, built on top of the Python programming language." -pandas.pydata.org

1.2 What is a csv file?


2. Importing Data Using pandas

Function Description
read_csv Load delimited data from a file, URL, or file-like object; use comma as default delimiter
read_table Load delimited data from a file, URL, or file-like object; use tab ('\t') as default delimiter
read_excel Read tabular data from an Excel XLS or XLSX file
read_json Read data from a JSON (JavaScript Object Notation) string representation
read_sql Read the results of a SQL query (using SQLAlchemy) as a pandas DataFrame

2.1 Importing using a URL

2.2 Importing a local file

Exercise


3. DataFrame


4. Computing Summary Statistics