python - How to look up values from another dataset with Tensorflow? -

-

i got 2 csv datasources. need doing data formatting before building model.

===============================================

datasource 1: plant.csv

the features of different plants. 

plantid, int / plantname, str / color, str /  size, float / cost, float / category, int / weight, float / expire, int / status, int

datasource 2: [201601.csv, 201602.csv, 201603.csv....]

monthly order sales of plants

plantid, int / salesperson, str / date, datetime / qty, int / price, float / gardener, str / package1, bool / package2, bool / package3, bool

===============================

now going join files single file this:

plantid, int / plantname, str / color, str /  size, float / cost, float / category, int / weight, float / expire, int / status, int / salesperson, str / date, datetime / qty, int / price, float / gardener, str / package1, bool / package2, bool / package3, bool

which plantid key.

there millions of sales records each month.

could advise how make tensorflow?

tensorflow not joining databases. if want in python can use pandas.

import pandas pd   df1 = pd.read_csv('plant.csv') df1.set_index(['plantid']) df2 = pd.read_csv('201601.csv') df2.set_index(['plantid'])  df3 = pd.concat([df1, df2], axis=1)

tensorflow creating computational graphs , running them efficiently. in general assume inputs graph numpy array.

pandas made work relational data inside python in relational database. although if have option of working inside actual relational database query language still more computationally efficient pandas.


Comments

Post a Comment

Popular posts from this blog

ZeroMQ on Windows, with Qt Creator -

-
i have installed zmq link given below on windows 7. http://zeromq.org/distro:microsoft-windows 1) have c++ project in qt-creator , i'm using zmq c++ binding (zhelpers.hpp etc). 2) have added .lib installed zmq folder qtcreator 3) while compiling, compiler looks _imp__zmq_verion, in .dll files present in .lib have __imp_zmq_version. 4) causing undefined reference zmq_version. anyone else faced problem , has solution ?
Read more

unity3d - Unity SceneManager.LoadScene quits application -

-
i have 2 different scenes 1 named 'main' , other 'game' both added scenes in load. when use scenemanager.loadscene("game"); works no problem when tried return main scene code if (input.getkeydown (keycode.escape)) { scenemanager.loadscene("main"); } strangely game quits. thanks. sorry interruption. somewhere on other script found code. if (input.getkeydown (keycode.escape)) { application.quit (); } that's bad, know...
Read more

python - Error while using APScheduler: 'NoneType' object has no attribute 'now' -

-
i have python app hosting on heroku. use apscheduler call function every day @ time. strange thing 1 time function runs after while have following error log: exception in thread apscheduler (most raised during interpreter shutdown): 2017-09-06t15:03:28.347848+00:00 app[web.1]: traceback (most recent call last): 2017-09-06t15:03:28.347858+00:00 app[web.1]: file "/app/.heroku/python/lib/python2.7/threading.py", line 810, in __bootstrap_inner 2017-09-06t15:03:28.347859+00:00 app[web.1]: file "/app/.heroku/python/lib/python2.7/threading.py", line 763, in run 2017-09-06t15:03:28.347861+00:00 app[web.1]: file "/app/.heroku/python/lib/python2.7/site-packages/apscheduler/schedulers/blocking.py", line 27, in _main_loop 2017-09-06t15:03:28.348167+00:00 app[web.1]: <type 'exceptions.attributeerror'>: 'nonetype' object has no attribute 'now' any guesses? the full code long here key parts: def startdayauto(): global ...
Read more