Movie Industry Data Analysis

This project performs a comprehensive analysis of the global movie industry using Python, pandas, and SQL.

Goals

• Identify the most profitable genres
• Analyze correlations between budget and revenue
• Rank countries by average box office earnings

Features

• Loads and transforms raw movie data
• Executes SQL queries for filtering and aggregation
• Creates visualizations for budget, revenue, and genre analysis

Files

• analysis.py – main analysis script
• movies.csv – source dataset
• task6.sql – SQL logic for extracting subsets
• izvjestaj.pdf – final report (in Bosnian)
• Visualizations: bar_zanrovi.png, bar_zemlje.png, scatter_budget_vs_box_office.png
• Summary data: analiza_zanrova.csv, prosjecan_budzet_i_zarada.csv, zemlje_po_prosjecnoj_zaradi.csv

How to Run

python analysis.py