We're sorry, but anonymous users are not allowed to create a new post.
Please Login or Register a new account.
Artboard 2 Q&A Artboard 2 copy 2Ideas Artboard 2 copyHelp Center
  • Log In
  • Home
  • Tell us how you approach Analytic Strategies

We've been hard at work — check out our latest product updates.

question
avatar image
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
Comment

People who like this

0 Show 0
5 |600 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

2 Answers
avatar image
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.

Comment

People who like this

0 Show 0 · Share
5 |600 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

avatar image
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.

Comment

People who like this

0 Show 0 · Share
5 |600 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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


question details

1 Person is following this question.

avatar image
Answers Answers and Comments
Features
  • Engagement
  • Retention
  • Funnels
  • People
  • Automatic Insights
  • Mobile A/B Testing
  • Messages
  • Infrastructure
  • Platform
  • JQL
Solutions
  • Enterprise
  • SaaS
  • Financial Services
  • Consumer Tech
  • Media & Entertainment
  • Telecommunications
  • Retail & E-commerce
  • Product
  • Marketing
  • Analytics
  • Professional Services
Resources
  • Help Center
  • Mixpanel Blog
  • Case Studies
  • Reports
  • Product Updates
  • Events & Webinars
  • Pricing
  • Partners
  • Trends
  • API & Developers
  • Live Webinars
Company
  • About us
  • Careers
  • Legal
  • Contact us
Follow

  • Anonymous
  • Log In
  • Create
  • Ask a question
  • Post an idea
  • Spaces
  • Planning and Implementation Spec
  • Data Management
  • Sending data to Mixpanel
  • Building Analysis Reports
  • Messages
  • Pulling data out of Mixpanel
  • Ideas
  • Tell us how you approach Analytic Strategies
  • Tell us how you use Mixpanel
  • Project Admin
  • Questions about our Community Platform
  • Explore
  • Topics
  • Questions
  • Ideas
  • Users
  • Badges