Python: pandas merge multiple dataframes

Below, is the most clean, comprehensible way of merging multiple dataframe if complex queries aren’t involved. Just simply merge with DATE as the index and merge using OUTER method (to get all the data). Now, basically load all the files you have as data frame into a list. And, then merge the files using merge or reduce function. Note: you can add as … Read more

Python reshape list to ndim array

You can think of reshaping that the new shape is filled row by row (last dimension varies fastest) from the flattened original list/array. An easy solution is to shape the list into a (100, 28) array and then transpose it: Update regarding the updated example:

How to overcome “datetime.datetime not JSON serializable”?

Updated for 2018 The original answer accommodated the way MongoDB “date” fields were represented as: {“$date”: 1506816000000} If you want a generic Python solution for serializing datetime to json, check out @jjmontes’ answer for a quick solution which requires no dependencies. As you are using mongoengine (per comments) and pymongo is a dependency, pymongo has built-in utilities to help … Read more

Install tkinter for Python

It is not very easy to install Tkinter locally to use with system-provided Python. You may build it from sources, but this is usually not the best idea with a binary package-based distro you’re apparently running. It’s safer to apt-get install python-tk on your machine(s). (Works on Debian-derived distributions like for Ubuntu; refer to your package manager … Read more