NYC Taxidata Analysis

This workflow reads in a sample dataset. It then analyses average speed of taxis at each hour with sample data and prints the results.

Workflow

Below is the workflow. It does the following:

  • Reads data from a dataset.
  • Extracts hour from pickup time.
  • Calculates the speed per hour.
  • Calculates the average speed per hour.
  • Prints the results.
  • Displays average speed per hour on chart.
NYC Taxidata Annalysis

Reading from Dataset

It reads sample Dataset files.

Processor Configuration

NYC Taxidata Annalysis

Processor Output

NYC Taxidata Annalysis

Extract hour from pickup time

It extracts hour from pickup time using datetimefieldextract Node.

Processor Configuration

NYC Taxidata Annalysis

Processor Output

NYC Taxidata Annalysis

Calculate the speed per hour

It calculates the speed per hour using SQL Node.

Processor Configuration

NYC Taxidata Annalysis

Processor Output

NYC Taxidata Annalysis

Calculate the average speed per hour

It calculates the average speed per hour using GroupBy Node.

Processor Configuration

NYC Taxidata Annalysis

Processor Output

NYC Taxidata Annalysis

Prints the results

It will print the result with the output of GroupBy Node.

Processor Configuration

NYC Taxidata Annalysis

Processor Output

NYC Taxidata Annalysis

Analyze using Chart Graph

It displays average speed per hour on chart using Graphvalue Node.

Processor Configuration

NYC Taxidata Annalysis

Processor Output

NYC Taxidata Annalysis