Week 2 - Data Import and Visualization

This week we will...

cover the following topics:

• VSCode and GitHub Code Spaces

• AI-assisted programming

• Representation of different data structures

• Reading data from external sources

• Chart and scale types

Learning Resources

2MB

251030_Import and Graphical Representation of Data.pdf

PDF

Open

• Get Started with GitHub Copilot in VS Code

• Overview on GitHub Copilot in VS Code

• Optional local installation of Python and VS Code

• Examples for the graphical representation of data

Until next week you should...

• work through this introduction to working with Pandas (only Lesson 1).

• watch this video on importing data as a Pandas DataFrame (18 minutes).

• work through this introduction to creating visualizations with Matplotlib (only Lesson 1).

• watch this video (4 minutes) to understand the relevance of confidence intervals.

• create a GitHub Codespace and save the files 'kiwo.csv', 'umsatzdaten_gekuerzt.csv', and 'wetter.csv' from this GitHub repository: https://github.com/opencampus-sh/einfuehrung-in-data-science-und-ml

• create a Jupyter notebook that

  • reads the dataset 'umsatzdaten_gekuerzt.csv' and

  • uses a bar chart to show the relationship of average sales per weekday.

• in a second step, add confidence intervals for the sales per weekday.

• in a further step, sort the weekdays from Monday to Sunday.