Non_Flat_File_Import_Web-Excel.py

# -*- coding: utf-8 -*-
"""
Created on Sun Jan 15 22:36:30 2017

@author: Shabaka
"""

# Import package
import pandas as pd

# Assign url of file: url
url = 'http://s3.amazonaws.com/assets.datacamp.com/course/\
importing_data_into_r/latitude.xls'

# Read in all sheets of Excel file: xl
xl = pd.read_excel(url, sheetname = None)

# Print the sheetnames to the shell
print(xl.keys())

# Print the head of the first sheet (using its name, NOT its index)
print(xl['1700'].head())