Using R, Python, & Plotly With Tableau

April 1, 2015
By

(This article was first published on Modern Data » R, and kindly contributed to R-bloggers)

Andy Kriebel recently pointed out that Tableau dashboards let you export their underlying data. Using data frames in R or Python we can read data from Tableau. Then we can plot with Plotly’s Python and R APIs. The use case: collaborate and share data across languages and teams.

Let’s try it out. The R code for this post is in an R Notebook; the Python code is in this IPython Notebook.

One of Andy’s Tableau visualizations shows the percentage of female managers by country. We add .csv to end of the Tableau URL and make a data frame that looks like this:

DF

Using pandas in Python or ggplot2 in R, we can make an interactive Plotly graph. The histogram below shows how many countries have a given percentage of female managers. See the R Notebook or IPython Notebook for the code.

You and your team can go the other way too: make 2D, 3D, and live-streaming plots using the Plotly web app and APIs for R, Python, and MATLAB then embed into Tableau in an iframe.

Email [email protected] or tweet to @plotlygraphs with any questions or suggestions. Contact us if you’d like to start using Plotly Enterprise on-premise.

To leave a comment for the author, please follow the link and comment on their blog: Modern Data » R.

R-bloggers.com offers daily e-mail updates about R news and tutorials on topics such as: Data science, Big Data, R jobs, visualization (ggplot2, Boxplots, maps, animation), programming (RStudio, Sweave, LaTeX, SQL, Eclipse, git, hadoop, Web Scraping) statistics (regression, PCA, time series, trading) and more...



If you got this far, why not subscribe for updates from the site? Choose your flavor: e-mail, twitter, RSS, or facebook...

Comments are closed.

Sponsors

Never miss an update!
Subscribe to R-bloggers to receive
e-mails with the latest R posts.
(You will not see this message again.)

Click here to close (This popup will not appear again)