In [1]:

    

import csv
import pandas as pd
import numpy as np
import src.misc.paths as path

import sys
import os

print(os.getcwd())
print(sys.version_info)


    

    




C:\Users\Chrisi\Desktop\Studium\BigDataScience\sose17-small-data\python\traffic-prediction
sys.version_info(major=3, minor=5, micro=2, releaselevel='final', serial=0)

In [2]:

    

path.trajectories_training_file


    

    
Out[2]:





'../../../../dataset/training/trajectories(table 5)_training.csv'

In [3]:

    

training_files = "../../dataset/training/"
links_file = "links (table 3).csv"
routes_file = "routes (table 4).csv"
trajectories_file = "trajectories(table 5)_training.csv"
volume_file = "volume(table 6)_training.csv"
weather_file = "weather (table 7)_training.csv"

routes_df = pd.read_csv(training_files+routes_file)
links_df = pd.read_csv(training_files+links_file)
volume_df = pd.read_csv(training_files+volume_file)
trajectories_df = pd.read_csv(training_files+trajectories_file)
weather_df = pd.read_csv(training_files+weather_file)

training_files = "../../dataset/training2/"
#training_files = "../../new_dataset/training/"
#trajectories_df = pd.read_csv(training_files+trajectories_file)
weather_df = pd.read_csv(training_files+"weather (table 7)_training_update.csv")


    

In [4]:

    

import src.vector_gen.generateCurrentSituationVector as gcsv
import src.vector_gen.generateWeatherVectors as gwv
import src.vector_gen.generateTimeInformationVector as tiv


    

In [5]:

    

df = gwv.generate_TimeInformationCurrentSituationWeatherVectors(trajectories_df,weather_df)
df


    

    




---------------------------------------------------------------------------
TypeError                                 Traceback (most recent call last)
<ipython-input-5-eca9013269d7> in <module>()
----> 1 df = gwv.generate_TimeInformationCurrentSituationWeatherVectors(trajectories_df,weather_df)
      2 df

C:\Users\Chrisi\Desktop\Studium\BigDataScience\sose17-small-data\python\traffic-prediction\src\vector_gen\generateWeatherVectors.py in generate_TimeInformationCurrentSituationWeatherVectors(trajectories_df, weather_df)
     51     """
     52     df_data = trajectories_df
---> 53     df_weather2 = prepare_weather_df(weather_df)
     54 
     55     df2 = df_weather2[1::2]

C:\Users\Chrisi\Desktop\Studium\BigDataScience\sose17-small-data\python\traffic-prediction\src\vector_gen\generateWeatherVectors.py in prepare_weather_df(weather_df)
     26     # weather_df[weather_df['wind_speed'] <= 0.3]
     27 
---> 28     weather_df['datetime'] = pd.to_datetime(weather_df['date']) + pd.to_timedelta(weather_df['hour'], unit='h')
     29 
     30     # make weather for each tw

C:\Anaconda3\lib\site-packages\pandas\core\ops.py in wrapper(left, right, name, na_op)
    607 
    608         time_converted = _TimeOp.maybe_convert_for_time_op(left, right, name,
--> 609                                                            na_op)
    610 
    611         if time_converted is None:

C:\Anaconda3\lib\site-packages\pandas\core\ops.py in maybe_convert_for_time_op(cls, left, right, name, na_op)
    567             return None
    568 
--> 569         return cls(left, right, name, na_op)
    570 
    571 

C:\Anaconda3\lib\site-packages\pandas\core\ops.py in __init__(self, left, right, name, na_op)
    280             left, right = left.align(right, copy=False)
    281 
--> 282         lvalues = self._convert_to_array(left, name=name)
    283         rvalues = self._convert_to_array(right, name=name, other=lvalues)
    284 

C:\Anaconda3\lib\site-packages\pandas\core\ops.py in _convert_to_array(self, values, name, other)
    396             supplied_dtype = values.dtype
    397         inferred_type = supplied_dtype or lib.infer_dtype(values)
--> 398         if (inferred_type in ('datetime64', 'datetime', 'date', 'time') or
    399                 com.is_datetimetz(inferred_type)):
    400             # if we have a other of timedelta, but use pd.NaT here we

TypeError: data type "datetime" not understood