Data formats

• Line files
  • Download exercises zip
  • Introduction
    • What to do
  • Line files
    • open command
    • The encoding
    • with block
  • people-complex line file
  • Exercise - line file immersione-in-python-toc
  • Continue
• CSV files
  • Download exercises zip
    • Why parsing a CSV ?
    • Reading a CSV
    • What’s a reader ?
    • Consuming a file
    • Reading as dictionaries
  • Writing a CSV
  • Reading and writing a CSV
  • CSV Botteghe storiche
    • Problem: wrong characters ??
    • Botteghe storiche in Python
    • Botteghe storiche - rank_categories
    • Botteghe storiche - enrich
  • CSV Air quality
    • load_air_quality
    • calc_avg_pollution
  • Continue
• JSON files
  • Download exercises zip
    • JSONL
  • Continue
• Challenges
  • Download exercises zip
  • Parsing challenge - Spam killer
    • Spam killer 1. mail reader
    • Spam killer 2. running filters
  • Parsing challenge - Markdown
  • Parsing challenge - Other languages
  • CSV Challenge - Over the top
    • Over the top 1. reading OpenStreetMap data
    • Over the top 2. extract peak
    • Over the top 3. write file

Visualization

• Intro
  • Download exercises zip
  • Introduction
    • What to do
  • First example
    • Plot style
    • x power 2 exercise
    • Axis limits
    • Axis size
    • Changing tick labels
  • Multiple lines
  • Numpy
    • Example without numpy
    • Example with numpy
    • Exercise - sin(x) + 3
  • Bar plots
    • Exercise - goleadors
    • Exercise - chemical elements
    • Exercise - superheroes
  • Showing plots side by side
    • Exercise - sin(kx)
  • Other plots
    • Pie chart
  • Fancy plots
    • Background color
    • Text
    • Images
    • Color intensity
    • Exercise - Be fancy
  • Continue
• Challenges
  • Download exercises zip
  • The variables
  • 1. plot_sheet
  • 2. plot_pentagram
  • 3. plot_notes
  • Final result 1:
  • Final result 2
• Images
  • Download exercises zip
    • What to do
  • Introduction
    • Monochrome
  • Focus
    • Exercise - Head focus
  • hstack and vstack
    • Exercise - Passport
  • flip
    • Exercise - Hall of mirrors
    • Exercise - The nose from above
  • Writing arrays
  • Writing into images
    • Exercise - Stripes
  • In a dark integer night
    • The Integer Shining
    • Exercise - Be bright
  • RGB - Get colorful
  • Exercise - Focus - top left
  • Exercise - Focus - bottom - left
  • Exercise - Focus - bottom - right
  • Exercise - Focus - top - right
  • Exercise - Look the other way
  • Exercise - Upside down world
  • Exercise - Shrinking Walls - X
  • Exercise - Shrinking Walls - Y
  • Exercise - Shrinking World
  • Exercise - Pixellate
  • Exercise - Feeling Red
  • Exercise - Feeling Green
  • Exercise - Feeling Blue
  • Exercise - No Red
  • Exercise - No Green
  • Exercise - No Blue
  • Exercise - Feeling Gray again
  • Exercise - Beyond the limit
  • Exercise - Gimme light
  • Exercise - When the darkness comes - with a warning
  • Exercise - When the darkness comes - without a warning
  • Exercise - Fade to black
  • Exercise - vertical fade

Pandas

• Intro
  • Download exercises zip
  • 1. What to do
    • Check installation
    • Which pandas should I use?
  • 2. Data analysis of Astro Pi
    • 2.1 Let’s import the file
    • 2.2 Memory
    • 2.3 Dimensions
    • 2.4 Let’s explore!
    • 2.5 Some stats
    • 2.6 Guardiamo le colonne
    • 2.7 What is a column?
    • 2.8 Exercise - meteo info
  • 3. MatPlotLib review
    • 3.1 An example
    • 3.2 Matplotlib plots from pandas datastructures
  • 4. Operations on rows
    • 4.1 Indexing integers
    • Difference between iloc and loc
    • 4.2 Filtering
    • 4.3 Sorting
    • 4.4 Exercise - Meteo stats
    • 4.5 Exercise - meteo plot
    • 4.6 Exercise - Meteo pressure and raining
  • 5. Object values and strings
    • 5.1 Filter by textual values
    • 5.2 Extracting strings
  • 6. Operations on columns
    • 6.1 - Selecting columns
    • 6.2 - Adding columns
    • 6.2.1 Exercise: Meteo temperature in Fahrenheit
    • 6.2.2 Exercise - Pressure vs Temperature
    • 6.3 Scrivere in colonne filtrate con loc
    • 6.3 Transforming columns
  • 7. Other exercises
    • 7.1 Exercise - Air pollutants
    • 7.2 Exercise - Game of Thrones
    • 7.3 Exercise - Healthcare facilities
  • Continue
• Advanded operations
  • Download exercises zip
  • 1. Grouping
    • 1.1 Let’s see a group
    • 1.2 groupby
    • 1.3 Modifying a dataframe by plugging in the result of a grouping
    • 1.4 Exercise - meteo pressure intervals
    • 1.5 Exercise - meteo average temperature
  • 2. Merging tables
    • Exercise 2.1 - better merge
  • 3. GeoPandas
  • Continue
• Challenges
  • Download exercises
    • What to do
  • Load the dataset
  • Tell me more
  • Getting in shape
  • 10 rows
  • Born in Verona
  • How many people in Verona
  • Python is everywhere
  • Verona after 1500
  • First Antonio
  • Some Antonio
  • Cesares during 1800
  • The old ones
  • Cities of poets
  • Most duplicated poets
  • All duplicated poets
  • Northern poets
  • Papers please
  • Unknown poets
  • Better unknown poets

Relational data

• Intro
  • Download exercises zip
    • Required libraries
  • What to do
    • Graph definition
    • Edge weights
  • Matrices
    • Visualization examples
    • Saving a graph to an image file
    • Saving a graph to an dot file
    • Minimal graph
    • Graph with two nodes example
    • Distance matrix
    • Boolean matrix example
    • Matrix exercises
    • Exercise - line
    • Exercise - cross
    • union
    • Exercise - union
    • Subgraphs
    • Exercise - is_subgraph
    • Exercise - remove_node
    • Exercise - utriang
    • Edge difference
    • Exercise - ediff
    • Exercise - pyramid
  • Adjacency lists
    • Exercise - mat_to_adj
    • Exercise - mat_ids_to_adj
    • Exercise - adj_to_mat
    • Exercise - table_to_adj
  • Networkx
    • Fancy networkx graphs
    • Converting networkx graphs
    • Exercise - mat_to_nx
  • Continue
• Binary relations
  • Download exercises zip
  • What to do
  • Reflexive relations
    • Exercise - is_reflexive_mat
    • Exercise - is_reflexive_adj
  • Symmetric relations
    • Exercise - is_symmetric_mat
    • Exercise - is_symmetric_adj
  • Surjective relations
    • Exercise - surjective
  • Further resources
  • Continue
• Simple statistics
  • Download exercises zip
  • What to do
  • Outdegrees and indegrees
    • Exercise - outdegree_adj
    • Exercise - outdegree_mat
    • Exercise - outdegree_avg
    • Exercise - indegree_adj
    • Exercise - indegree_mat
    • Exercise - indegree_avg
    • Was it worth it?
    • networkx Indegrees and outdegrees
  • Visualizing distributions
  • indegree per node
    • indegree per node bar plot
    • indegree per node sorted alphabetically
    • indegree per node sorted
    • out degrees per node sorted
    • degrees per node
    • In out degrees per node
  • Frequency histogram
    • Exercise - better histogram display
  • Graph models
    • Exercise - Erdős–Rényi model
  • Continue
• Challenges
  • Download exercises zip
  • Matrices
    • Challenge - trichain
    • Challenge - Bipartite
    • Challenge - Luna park
    • Challenge - Factory
    • Challenge - Sharing is caring
    • Challenge - Hexagons
    • Challenge - Trust your tribe
  • Adjacency lists
    • Challenge - From matrices to adjacency lists
    • Challenge - Friends
    • Challenge - Counter Intelligence
  • Networkx
    • Challenge - Offshore
    • Challenge - Cashflow