def main(): inFileTube = 'DATA/tram_validated.csv' outFileTube = "DATA/tram_dirty" + ".ttl" csvTubeS = readCsv(inFileTube) next(csvTubeS, None) tubeS_store = plugin.get('IOMemory', Store)() tubeS_g = Graph(tubeS_store) prefixes = definePrefixes() print('Binding Prefixes') bindingPrefixes(tubeS_g, prefixes) #bindingPrefixes(tubeT_graph,prefixes) print('Creating graph-TubeS...') flag = 1 for row in csvTubeS: lstData = getTubeSData(row) createTubeSGraph(lstData, tubeS_g) createTubeSGraph(lstData, tubeS_g).serialize(outFileTube, format='turtle') print('DONE!')
def main(): #url="https://api.tfl.gov.uk/BikePoint?app_id=5ee709d5&app_key=1739d498d997e956a2b80c62a8948ff0" #url for bike api #apiJsonCsv(url) #json to csv conversion inputCsv = "DATA/tfl_bikes_validated.csv" outFile = "DATA/tfl_bikes_dirty.ttl" csvBike = readCsv(inputCsv) #create object from the resulting csv file next(csvBike) #skips the header bike_store = plugin.get('IOMemory', Store)() bike_g = Graph(bike_store) prefixes = definePrefixes() print('Binding Prefixes') bindingPrefixes(bike_g, prefixes) print('Creating graph-bike...') for row in csvBike: #loop through individual rows in the csv file **KEY** lstData = getBikeData( row) #activates the getBikeData() function **KEY** createBikeGraph(lstData, bike_g).serialize(outFile, format='turtle') print('Bikes rdfy - done')
def main(): busPathf = './' inFileB = busPathf + 'DATA/bus_validatedSMALL.csv' outFileB = busPathf + 'DATA/bus_dirtySMALL.ttl' csvB = readCsv(inFileB) busline_store = plugin.get('IOMemory', Store)() bus_g = Graph(busline_store) prefixes = definePrefixes() print('Binding Prefixes') bindingPrefixes(bus_g, prefixes) print('Creating graph-Bus...') for row in csvB: lstData = getBusData(row) createBusGraph(lstData, bus_g).serialize(outFileB, format='turtle') print('DONE - Bus rdfy')
def main(): pathf = "./" inFile = pathf + "DATA/airbnbNiceTest.csv" outFile = pathf + "DATA/airbnbNice_dirty.ttl" csv = readCsv(inFile) next(csv, None) # FILE WITH HEADERS store = plugin.get('IOMemory', Store)() g = Graph(store) prefixes = definePrefixes() print('Binding Prefixes') bindingPrefixes(g, prefixes) print('Creating graph-Hotel...') # AMENDED #This one generates the 'turtle' graph. Please deactivate the script for the 'nt' graph below for row in csv: lstData = getHotelData(row) createHotelGraph(lstData, g).serialize(outFile, format='turtle') print('DONE! Time elapsed ' + str((time.time() - start_time)))