From: STVG: an evolutionary graph framework for analyzing fast-evolving networks
“Moves” nodes | “Stops” nodes |
---|---|
Load csv with headers from | Load csv with headers from |
‘file:///data/Moves.csv’ as csv | ‘file:///data/Stops.csv’ as csv |
MERGE(r:Moves{MoveID: csv.moveid}) | MERGE (r:Stops {StopID: csv.stopid}) ON CREATE SET |
ON CREATE SET | r.TripID = csv.Tripid, r.Street = csv.streetname, |
r.TripID = csv.Tripid, r.Street = csv.streetname, | r.BusStop = csv.BusStop,r.latitude = toFloat(csv.lat), |
r.BusStop = csv.Busstop, | r.longitude = toFloat(csv.long), |
r.latitude = toFloat(csv.lat), r.longitude = toFloat(csv.long), | r.Date = csv.Date, r.Time = csv.Time, |
r.Date = csv.Date,r.Time = csv.Time, r.Sequence = toInteger(csv.sequence),r.State = csv.state, | r.Sequence = toInteger(csv.sequence),r.State = csv.state, r.year = toInteger(substring(csv.Date,6,4)), |
r.year = toInteger(substring(csv.Date,6,4)), | r.month = toInteger(substring(csv.Date,3,2)), |
r.month = toInteger(substring(csv.Date,3,2)),r.day = toInteger(substring(csv.Date,0,2)), | r.day = toInteger(substring(csv. Date,0,2)), |
r.hour = toInteger(substring(csv.Time,0,2)); | r.hour = toInteger(substring(csv.Time,0,2)); |