Last week I had a go at my first Preppin Data challenge. I decided to do it in Python but I wasn't sure the best way to submit my solution. Carl Allchin from the Data School said that I could start a blog to show my workings. So here it is. For week 25's challenge , we were given data on Ed Sheeran and Ben Howard concerts. There were three sets of data to work with: 'Gigs Data' and 'Home Locations', both contained in an Excel file, and a csv file of longitudes and latitudes for the concert locations. └── week 25 ├── LongLats.csv └── Wow _ PD data set.xlsx (Gigs Data, Home Locations) I started by importing the pandas library and assigning the three data sets to separate data frames. df_LongLats = pd.read_csv('LongLats.csv') df_gigs = pd.read_excel('Wow _ PD data set.xlsx', sheet_name='Gigs Data') df_homes = pd.read_excel('Wow _ PD data set.xlsx', sheet_name='Home Locations') print('gigs df crea...
Jack Turner
.