How to save pandas DataFrame to Elasticsearch?

[G_will]

How to save pandas DataFrame to Elasticsearch?

Here is my solution:

        l = df.T.to_dict().values()

        for d in l:

            # index d into Elasticsearch

But, It always make errors, something like float('nan'), it will raise Exception, and NaTType, it can be convert to a json field.

Is there a better way to save pandas DataFrame to Elasticsearch?

[Chris Withers]

I'd suggest having a look at the "Extending JSONEncoder" section in
https://docs.python.org/2/library/json.html#.

There's also a few answers on StackOverflow that will help you...

Chris