scraping_hostels_4

df=pd.DataFrame()

df['hostel']=data[0::11]
df['security']=data[1::11]
df['location']=data[2::11]
df['staff']=data[3::11]
df['fun']=data[4::11]
df['cleanliness']=data[5::11]
df['facilities']=data[6::11]
df['value']=data[7::11]
df['experience']=data[8::11]
df['price']=data[9::11]
df['number_reviews']=data[10::11]

#Remove non-string from 2 columns
df['number_reviews'] = df['number_reviews'].str.extract('(\d+)', expand=False)
df['price'] = df['price'].str.extract('(\d+)', expand=False)