crowdedness_combine_trip_crowds

crowdedness_combine_trip_crowds.py

timedata = timedata.merge(druktedata[['ritnumber', 'departure', 
                                      'classification', 'seats', 'operator']], 
                          left_on=['ritnumber', 'stop_code'], 
                          right_on=['ritnumber', 'departure'])

timedata.time = timedata.time.apply(lambda x: min2str(x))
timedata['passengers'] = ((timedata.classification - 1) * 
                          timedata.seats * 0.33).astype(int)
timedata['timestamp'] = (pd.to_datetime(timedata['time']) - 
                         pd.Timestamp("1970-01-01")) // pd.Timedelta('1s')
timedata['elevation'] = 0