Data Training from Zomalex

Home | Power BI | Excel | Python | SQL | Visualising Data | Generative AI | Analysing Data Course - Home

Tidy Data Exercise

In these exercise, discuss:

• are these datasets structured in a tidy data format?
• If not, what needs to be done to reshape these as tidy data?

Optionally, and if time allows, reshape the data into a tidy format - use whatever software suits you best.

Transport for London (TFL) Journey Types Dataset

The Public Transport Journeys by Type of Transport dataset contains the number of journeys on the TFL public transport network by TFL reporting period and type of transport. Data is broken down by bus, underground, DLR, tram, Overground, cable car and TfL Rail. The data is available from this page and directly, as an Excel file here. You can also download the Excel file from here.

Strictly Dataset

The Week 1 table on this wikipedia page shows the results of the first week of the 2024 series of Strictly, a BBC light entertainment dancing competition.