Exploratory
Search…
Exploratory
Introduction
Product Features
Data Import
File Data
Database Data
Cloud Apps Data
Write R Script as Data
Write R Script as Data (日本語)
Web Page Scraping
Data Source Extension
Create Custom Data Source
Data Wrangling
Visualization
Analytics
Statistics
Machine Learning
Text Analysis
Extend with R
Setup
Diagnostics
Keyboard shortcuts
Powered By GitBook
Data Import
  1. 1.
    Import Data
  2. 2.
    Update Data Import Setting
  3. 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.
Previous
Search
Next
File Data
Last modified 1yr ago
Copy link
Contents
File import
Databases
Cloud Apps
Others
Custom Data with R Script
User Defined Plugin