Enable importing data into pandas

Question

question

divy asked · Feb 13 at 06:41 PM

Enable importing data into pandas

Please consider a feature to integrate the Mixpanel data directly into pandas library for analytis/visualization/modeling?

data management

0

5 |600 characters needed characters left characters exceeded

Attachments: Up to 8 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.

2 Answers

Answer 1 · 2019-05-23T03:20:33Z

prachi answered · May 23 at 03:20 AM

hi @divy I am a product manager at mixpanel and would love to dive into your requirement to understand what you're trying to achieve with pandas. would you be open to jumping on a 30-minute exploratory call? Alternately feel free to write to me at prachi.wadekar@mixpanel.com if prefer chatting more on email.

0 · Share

5 |600 characters needed characters left characters exceeded

Attachments: Up to 8 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.

Answer 2 · 2019-02-15T22:56:06Z

advance512 answered · Feb 15 at 10:56 PM

You can consume the Mixpanel analytics data using the Data Export API.

An example of receiving data using Python can be found here:

https://mixpanel.com/site_media/api/v2/mixpanel.py

This would be JSON formatted. Here is an example of how to convert a JSON dump into a Pandas frame:

https://stackoverflow.com/questions/41168558/python-how-to-convert-json-file-to-dataframe/41168691

You can then use Pandas as you normally would, for analysis/visualization/modeling.

Hope this helps.

0 · Share

5 |600 characters needed characters left characters exceeded

Attachments: Up to 8 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.

Enable importing data into pandas

question details