# abhishek6002/etl-assignment architecture

> Architecture diagram of the GitHub repository abhishek6002/etl-assignment, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-11-17). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/abhishek6002/etl-assignment
- Repository: https://github.com/abhishek6002/etl-assignment

## Overview

This is a Python/Pandas ETL assignment that reads the Stack Overflow Developer Survey 2019 CSV and runs six independent analyses, printing their results to the terminal. The workflow starts in `Assignment/main.py`, which loads the dataframe and invokes each task with it. The tasks cover coding age, Python usage by country, salary and hobby coding by continent, desired languages, and job/career satisfaction by continent. The CSV is referenced by the runner but is not present in the supplied tree; task-to-terminal edges reflect their print-based reporting.

Main entry points: [`Assignment/main.py`](https://github.com/abhishek6002/etl-assignment/blob/main/Assignment/main.py) (Survey runner), [`Assignment/codeAsHobby.py`](https://github.com/abhishek6002/etl-assignment/blob/main/Assignment/codeAsHobby.py) (Hobby coding), [`Assignment/jobAndCarrerSatisfication.py`](https://github.com/abhishek6002/etl-assignment/blob/main/Assignment/jobAndCarrerSatisfication.py) (Job and career satisfaction), [`Assignment/PythonPercentage.py`](https://github.com/abhishek6002/etl-assignment/blob/main/Assignment/PythonPercentage.py) (Python by country)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_ingest["Ingestion"]
  node_runner["Survey runner<br/>[main.py]"]
end

subgraph group_language["Language analysis"]
  node_python_analysis["Python by country"]
  node_desired_languages["Desired languages"]
end

subgraph group_geography["Geographic analysis"]
  node_salary_analysis["Salary by continent"]
end

subgraph group_wellbeing["Developer profile"]
  node_age_analysis["Coding start age<br/>[age1stcode.py]"]
  node_hobby_analysis["Hobby coding<br/>[codeAsHobby.py]"]
  node_satisfaction_analysis["Job and career satisfaction"]
end

node_survey_csv["Survey CSV"]
node_country_converter["Country Converter"]
node_terminal(("Terminal user"))

node_runner -->|"loads CSV"| node_survey_csv
node_runner -->|"calls with data"| node_age_analysis
node_runner -->|"calls with data"| node_python_analysis
node_runner -->|"calls with data"| node_salary_analysis
node_runner -->|"calls with data"| node_desired_languages
node_runner -->|"calls with data"| node_hobby_analysis
node_runner -->|"calls with data"| node_satisfaction_analysis
node_age_analysis -->|"prints results"| node_terminal
node_python_analysis -->|"prints results"| node_terminal
node_salary_analysis -->|"prints results"| node_terminal
node_desired_languages -->|"prints results"| node_terminal
node_hobby_analysis -->|"maps countries"| node_country_converter
node_hobby_analysis -->|"prints results"| node_terminal
node_satisfaction_analysis -->|"maps countries"| node_country_converter
node_satisfaction_analysis -->|"prints results"| node_terminal

click node_runner "https://github.com/abhishek6002/etl-assignment/blob/main/Assignment/main.py"
click node_age_analysis "https://github.com/abhishek6002/etl-assignment/blob/main/Assignment/age1stcode.py"
click node_python_analysis "https://github.com/abhishek6002/etl-assignment/blob/main/Assignment/PythonPercentage.py"
click node_salary_analysis "https://github.com/abhishek6002/etl-assignment/blob/main/Assignment/averageSalByContinent.py"
click node_desired_languages "https://github.com/abhishek6002/etl-assignment/blob/main/Assignment/mostDesiredProgrammingLanguage.py"
click node_hobby_analysis "https://github.com/abhishek6002/etl-assignment/blob/main/Assignment/codeAsHobby.py"
click node_satisfaction_analysis "https://github.com/abhishek6002/etl-assignment/blob/main/Assignment/jobAndCarrerSatisfication.py"

classDef toneNeutral fill:#f8fafc,stroke:#334155,stroke-width:1.5px,color:#0f172a
classDef toneBlue fill:#dbeafe,stroke:#2563eb,stroke-width:1.5px,color:#172554
classDef toneAmber fill:#fef3c7,stroke:#d97706,stroke-width:1.5px,color:#78350f
classDef toneMint fill:#dcfce7,stroke:#16a34a,stroke-width:1.5px,color:#14532d
classDef toneRose fill:#ffe4e6,stroke:#e11d48,stroke-width:1.5px,color:#881337
classDef toneIndigo fill:#e0e7ff,stroke:#4f46e5,stroke-width:1.5px,color:#312e81
classDef toneTeal fill:#ccfbf1,stroke:#0f766e,stroke-width:1.5px,color:#134e4a
class node_runner,node_terminal toneBlue
class node_python_analysis,node_desired_languages toneAmber
class node_salary_analysis toneMint
class node_age_analysis,node_hobby_analysis,node_satisfaction_analysis toneRose
class node_survey_csv,node_country_converter toneIndigo
```

## Components

### Ingestion

- [Survey runner](https://github.com/abhishek6002/etl-assignment/blob/main/Assignment/main.py): `Assignment/main.py`

### Language analysis

- [Python by country](https://github.com/abhishek6002/etl-assignment/blob/main/Assignment/PythonPercentage.py): `Assignment/PythonPercentage.py`
- [Desired languages](https://github.com/abhishek6002/etl-assignment/blob/main/Assignment/mostDesiredProgrammingLanguage.py): `Assignment/mostDesiredProgrammingLanguage.py`

### Geographic analysis

- [Salary by continent](https://github.com/abhishek6002/etl-assignment/blob/main/Assignment/averageSalByContinent.py): `Assignment/averageSalByContinent.py`

### Developer profile

- [Coding start age](https://github.com/abhishek6002/etl-assignment/blob/main/Assignment/age1stcode.py): `Assignment/age1stcode.py`
- [Hobby coding](https://github.com/abhishek6002/etl-assignment/blob/main/Assignment/codeAsHobby.py): `Assignment/codeAsHobby.py`
- [Job and career satisfaction](https://github.com/abhishek6002/etl-assignment/blob/main/Assignment/jobAndCarrerSatisfication.py): `Assignment/jobAndCarrerSatisfication.py`

### Other components

- **Survey CSV**
- **Country Converter**
- **Terminal user**

## Connections

- Survey runner → Survey CSV: loads CSV (evidence: `Assignment/main.py`)
- Survey runner → Coding start age: calls with data (evidence: `Assignment/main.py`)
- Survey runner → Python by country: calls with data (evidence: `Assignment/main.py`)
- Survey runner → Salary by continent: calls with data (evidence: `Assignment/main.py`)
- Survey runner → Desired languages: calls with data (evidence: `Assignment/main.py`)
- Survey runner → Hobby coding: calls with data (evidence: `Assignment/main.py`)
- Survey runner → Job and career satisfaction: calls with data (evidence: `Assignment/main.py`)
- Coding start age → Terminal user: prints results (evidence: `Assignment/age1stcode.py`)
- Python by country → Terminal user: prints results (evidence: `Assignment/PythonPercentage.py`)
- Salary by continent → Terminal user: prints results (evidence: `Assignment/averageSalByContinent.py`)
- Desired languages → Terminal user: prints results (evidence: `Assignment/mostDesiredProgrammingLanguage.py`)
- Hobby coding → Country Converter: maps countries (evidence: `Assignment/codeAsHobby.py`)
- Hobby coding → Terminal user: prints results (evidence: `Assignment/codeAsHobby.py`)
- Job and career satisfaction → Country Converter: maps countries (evidence: `Assignment/jobAndCarrerSatisfication.py`)
- Job and career satisfaction → Terminal user: prints results (evidence: `Assignment/jobAndCarrerSatisfication.py`)
