notebook.community

Edit and run



In [198]:

    
import plotly.plotly as pl
import plotly.graph_objs as go
import plotly.offline as po
import matplotlib.pyplot as plt
import mpl_toolkits.basemap as bm
import pandas as pd
import numpy as np
import seaborn as sns

po.init_notebook_mode()
%pylab inline









    











    



Populating the interactive namespace from numpy and matplotlib



In [2]:

    
PATH_TO_DATASETS = '../yelp_dataset/'
df_businesses = pd.read_csv(PATH_TO_DATASETS + 'businesses.csv', sep=',', encoding='utf-8')
df_checkins = pd.read_csv(PATH_TO_DATASETS + 'checkins.csv', sep=',', encoding='utf-8')
df_reviews = pd.read_csv(PATH_TO_DATASETS + 'reviews.csv', sep=',', encoding='utf-8')
df_users = pd.read_csv(PATH_TO_DATASETS + 'users.csv', sep=',', encoding='utf-8')
df_tips = pd.read_csv(PATH_TO_DATASETS + 'tips.csv', sep=',', encoding='utf-8')



In [3]:

    
df_businesses.head(1)









    Out[3]:






  
    
      
      business_id
      city
      full_address
      latitude
      longitude
      name
      open
      review_count
      stars
      state
      ...
      hour_saturday_open
      hour_sunday_close
      hour_sunday_open
      hour_thursday_close
      hour_thursday_open
      hour_tuesday_close
      hour_tuesday_open
      hour_wednesday_close
      hour_wednesday_open
      neighborhoods_count
    
  
  
    
      0
      vcNAWiLM4dR7D2nwwJ7nCA
      Phoenix
      4840 E Indian School Rd\nSte 101\nPhoenix, AZ ...
      33.499313
      -111.983758
      Eric Goldberg, MD
      True
      9
      3.5
      AZ
      ...
      NaN
      NaN
      NaN
      17:00
      08:00
      17:00
      08:00
      17:00
      08:00
      0
    
  

1 rows × 983 columns