Skip to main content

Configuring Lite with external data links

How can I make online data files open up in iNZight Lite automatically?

As an example, we will use the little data set hosted online at https://www.stat.auckland.ac.nz/~wild/data/Census-at-School_1st20.csv.

If you CLICK HERE this data set to open in iNZight Lite in Visualize mode with the first variable plotted. You can then continue exploring this dataset in visualize mode in the usual way. (To see the raw data, go File > Display Dataset.)

The url linked to "CLICK HERE" that made this example work is: http://lite.inzight.nz/?url=https://www.stat.auckland.ac.nz/~wild/data/Census-at-School_1st20.csv&land=visualize

The form of the link you need is one of:

  • http://lite.inzight.nz/?url={file}
  • http://lite.inzight.nz/?url={file}&land=visualize
  • http://lite.inzight.nz/?url={file}&land=timeSeries

where you need to replace {file} by the url address of the data file, e.g., https://www.stat.auckland.ac.nz/~wild/data/Census-at-School_1st20.csv. The data file has to be hosted publicly. There is no provision for any sort of login access.

Generally speaking the file name must end in a file-name extension, e.g. .csv, or .xlsx, that iNZight Lite recognizes. Lite uses this to figure out what the file type is so that it can be imported properly (an exception is files from Google sheets which are discussed below).

What &land= does:

  • If &land=visualize is included Lite will "land" in Visualize mode with the first variable plotted
  • If &land=timeSeries is included Lite will "land" in the time series module with the first series plotted
  • If &land= is not included, Lite will "land" at the usual startup screen
note

This is a feature of Lite that can easily be expanded if someone approaches us with a compelling use-case.

How to have Google Forms/Sheets data open up in iNZight Lite

This webpage by Daniel Barnett and Emma Wilson shows collecting data with Google Forms (used to gather data from students in class), which is accumulated into a Google Sheet, and which is then opened up in iNZight Lite so the teacher can then immediately analyse it in iNZight Lite in the same classroom session by clicking a link. It also links to an automated iNZight Lite link generator.

This video by Anna Ferguson leads the viewer through the same sorts of process with lots of great teaching ideas along the way.

How can I instantly add visualization capabilities to my online data repository?

Below is a screenshot from the top of the webpage https://www.stat.auckland.ac.nz/~wild/data/Rdatasets/

On the webpage, if you click on the little eye icon by any dataset, that dataset opens up in iNZight Lite. This page was constructed by linking each little eye icon image to a url of the form described above.

Webpage with links to Lite with pre-loaded data.
View the source

Go to the webpage and using your browser's "view source" to see the html code.

note

The links in the webpage use &land=visualize but could be replaced by, say, &land=timeSeries.