Please consider a feature to integrate the Mixpanel data directly into pandas library for analytis/visualization/modeling?
We've been hard at work — check out our latest product updates.
Please consider a feature to integrate the Mixpanel data directly into pandas library for analytis/visualization/modeling?
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.
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.