Introduction to other file types

Introduction to Importing Data in Python

Hugo Bowne-Anderson

Data Scientist at DataCamp

Other file types

import pickle
with open('pickled_fruit.pkl', 'rb') as file:
    data = pickle.load(file)    
print(data)

{'peaches': 13, 'apples': 4, 'oranges': 11}

import pandas as pd
file = 'urbanpop.xlsx'
data = pd.ExcelFile(file)
print(data.sheet_names)

['1960-1966', '1967-1974', '1975-2011']

df1 = data.parse('1960-1966') # sheet name, as a string
df2 = data.parse(0) # sheet index, as a float

Introduction to Importing Data in Python