Datacamp Report

# Datacamp Report

import pandas as pd
import numpy as np
import matplotlib.pyplot as plt
import seaborn as sns

import scipy.io as scp

df = pd.read_csv("datasets/homelessness.csv")
print(df.head())

df1 = pd.read_csv("datasets/walmart.csv")
df1.head()

data = pd.ExcelFile("")
data.sheet_names
df_xl = data.parse('') 

import pickle as pk
with open('', 'rb') as pkfile:
    df_pk = pk.load(pkfile)

from sas7bdat import SAS7BDAT
with SAS7BDAT('') as sasfile:
    df_sas = sasfile.to_data_frame()

df_stat = pd.read_stata('')

import h5py
df_h5 = h5py.File('', 'r')

mat_file = scp.loadmat('')

from sqlalchemy import create_engine
engine = create_engine('')
conn = engine.connect()

que = conn.execute('')
pd.DataFrame(que.fetchall())
pd.DataFrame(que.fetchmany(size= ))
df.columns = que.keys()

df_eng = pd.read_sql_query('', engine)

conn.close()

list1, list2 = [], []
df_list = {'List' : list1, 'List2': list2}