Mark walks through a short Python script to transform a dataset of football matches played in this season’s English Premier League into a results table.
This involves lots of typical operations: import a dataset, split and stack it, add new columns, group, sort rows and columns then export the data.
The datasets and course materials used in the examples are https://bit.ly/33zWQtp in the "Rosetta" folder..
Other videos in this playlist demo the same task in different languages: Excel, R, SQL,DAX and Power Query (M).
We run a full range of data analysis and generative AI courses in London and online. See our courses at zomalex.co.uk
Music: bensound.com