ExporttoCSV.py

lat = X_test[:,0]
lat = lat.reshape((len(lat),1))

lon = X_test[:,1]
lon = lon.reshape((len(lon),1))

time = X_test[:,2]
time = time.reshape((len(time),1))

print y_test.shape

cols = ['Latitude (deg)', 'Longitude (deg)', 'time_secs', 'Speed (mph)', 'Actual' ]

data = np.concatenate((lat,lon,time, y_pred,y_test), axis=1)
pred_df = pd.DataFrame(data, columns=cols)
pred_df
pred_df.to_csv('C:\Users\lenovo\Desktop\Karishma\Project 2017\OBD\predict1.csv')