示例#1
0
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!')
示例#2
0
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')
示例#3
0
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)))