Data Import

  1. Import Data

  2. Update Data Import Setting

  3. Re-Import (Re-load) Data

File import

  • CSV - Comma Separated Files

  • TSV - Tab Separated Files

  • Delimited Files

  • Excel

  • Statistical Files - SPSS / SAS / STATA

  • R Data Files - RDS, RData

  • JSON

Databases

  • Amazon Redshift

  • PostgreSQL

  • HP Vertica

  • MySQL

  • MariaDB

  • Google BigQuery

  • MongoDB

Cloud Apps

  • Google Analytics

  • Google Spreadsheet

  • Twitter

  • Github Issues

Others

  • REST APIs / Remote JSON

  • Web Page Scraping

Custom Data with R Script

You can create your own custom data sources by writing R Script or using R packages like quantmod for financial data, gtrend for Google Trend, Rfacebook.

User Defined Plugin

You can hook up your custom data source to Exploratory's Data Import Dialog UI by writing a plugin definition file (with data source definition like input parameters, underlying R function name, etc) with JSON format and corresponding R Script.