Exploring datasets

class: center, middle, inverse, title-slide

# Exploring datasets - Examples
## Workshop at NLU Odisha
### CivicDataLab
### 2022/08/08 (updated: 2024-01-05)

---

<div>
<style type="text/css">.xaringan-extra-logo {
width: 110px;
height: 128px;
z-index: 0;
background-image: url(https://drive.google.com/uc?id=1WbdosVvi6SBjYtEF6kHj-f0wotdHMRgw);
background-size: contain;
background-repeat: no-repeat;
position: absolute;
top:1em;right:1em;
}
</style>
<script>(function () {
  let tries = 0
  function addLogo () {
    if (typeof slideshow === 'undefined') {
      tries += 1
      if (tries < 10) {
        setTimeout(addLogo, 100)
      }
    } else {
      document.querySelectorAll('.remark-slide-content')
        .forEach(function (slide) {
          const logo = document.createElement('a')
          logo.classList = 'xaringan-extra-logo'
          logo.href = 'https://civicdatalab.in'
          slide.appendChild(logo)
        })
    }
  }
  document.addEventListener('DOMContentLoaded', addLogo)
})()</script>
</div>

# Crime in India

Source: [Wikipedia](https://en.wikipedia.org/wiki/Crime_in_India)

## Objective:

1. Download the table _Absolute number of reported crimes & crime rates across India_
2. Calculate _total reported crimes from 2016-2019_ in all states
3. Calculate _percent share of each state_ in reported crimes
4. Arrange the results in decreasing order of percent share

---

# Most cited acts and sections

Source: [Justice Hub - Indian Kanoon Statistics](https://justicehub.in/dataset/indian-kanoon-statistics)

## Objective:

1. Import data in google sheets
2. Filter data for IPC sections
3. Find how many sections contribute to 50% of the cases
4. Add a column for the section title

---

# Mortality data from DevDataLab

Source: Dropbox

Link: https://www.dropbox.com/sh/y949ncp39towulf/AACJRhJs6uzbjkB6uM5O9mKga/mortality/csv?dl=0&subfolder_nav_tracking=1

## Objective:

1. Import data in google sheets
2. Compare mortality data across states from 2019 - 2021
3. Compare mortality data for Karnataka across years, as shown [here](https://devdatalab.medium.com/making-sense-of-excess-mortality-f26cffe3643e)

---

# Judges of the Orissa High Court

Source: Justice Hub

Link: https://justicehub.in/dataset/khoj-orissa/resource/92c89ebb-3612-4ad5-a327-d55f65327577

## Objective:

1. Import data in google sheets
2. Find the number of Male and Female judges
3. Find the percentage of judges where _Parent High court_ is Odisha High Court
4. Find the total number of judges appointed each year
5. Find the total number of judges retiring each year

---

# India at CommonWealth Games

Source: Wikipedia

Link: https://en.wikipedia.org/wiki/India_at_the_Commonwealth_Games

## Objective:

1. Find the table titled - _Overall Medal Tally By Sport_
2. Import data in Microsoft Excel
3. Find the percentage share of total medals by sports
4. Arrange the sports in decreasing order of percentage share of total medals
5. Find the percentage share of gold, silver and bronze medals by each sport
6. Remove Grand Totals from Columns
7. Highlight the cells with the largest contribution to gold, silver and bronze medals respectively

---

# Vlookup

[Practice Sheet](https://docs.google.com/spreadsheets/d/1zpfyASP_49zHicC3ExsCgvS9lgydNexumHUkBMeqRHE/edit#gid=894546776)

---
class: center, middle

# Queries and Feedback