Checklist IOAI Indonesia 2025 OSN 2025 AI Exhibition – Final · P2 task
Exploratory Data Analysis of Cinema Ticket Sales
Indonesian title: Exploratory Data Analysis (EDA) Film & Bioskop
Answer aggregation questions on a small list of cinema screening records.
The task
A hard-coded list of screenings from 1 to 20 June 2025 gives film title, genre, ticket price, tickets sold, date, city, showtime and studio; some values are inconsistently formatted (for example city spellings and key names).
Questions: total revenue per genre (10 points); mean ticket price per genre (15); the date with the most tickets sold (20); the city showing the most distinct films (30); the most profitable film (25); and a bonus free-exploration insight (10).
Abridged and translated by SOTA from the official Indonesian materials. The official statement has the exact rules, and it wins wherever this summary differs.
In English
This task was published in Indonesian. SOTA translated it into English on 17 September 2026. Only the words changed in the notebooks: markdown, code comments, messages and printed output. The code, file names and paths are the original's, so a translated notebook runs with the original data.
Read the task notebook in English
📊 Exploratory Data Analysis (EDA)
This dataset contains cinema ticket sales information for various films shown in several major cities in Indonesia. The data were collected from 1 to 20 June 2025.
Each record consists of the following information:
📌 Dataset Column Description (Films & Cinemas)
- judul_film : Title of the film shown.
- genre : Genre category of the film.
- harga_tiket : Price of one film ticket in Rupiah.
- jumlah_tiket : Number of tickets sold for a particular screening.
- tanggal : Date of the film screening in the format YYYY-MM-DD.
- kota : City where the film was shown.
- jam_tayang : Screening time of the film.
- studio : Code of the studio (screen) where the film was shown.
RUN THE CODE BELOW AND DO NOT CHANGE THE DATA AT ALL.
data = [ # genre values: 'Animasi' = animation, 'Komedi' = comedy, 'Horor' = horror
{'judul_film': 'Train to Busan', 'genre': 'Drama', 'harga_tiket': 70000, 'jumlah_tiket': 121, 'tanggal': '2025-06-12', 'kota': 'Makassar', 'jam_tayang': '13:00', 'studio': 'C'},
{'judul_film': 'The Avengers: Endgame', 'genre': 'Drama', 'harga_tiket': 55000, 'jumlah_tiket': 130, 'tanggal': '2025-06-15', 'kota': 'yogyakarta', 'jam_tayang': '22:00', 'studio': 'C'},
{'judul_film': 'Spiderman: Homecoming', 'genre': 'Sci-Fi', 'harga_tiket': 70000, 'jumlah_tiket': 113, 'tanggal': '2025-06-12', 'kota': 'yogyakarta', 'jam_tayang': '16:00', 'studio': 'B'},
{'judul_film': 'Doctor Strange: Multiverse of Madness', 'genre': 'Animasi', 'harga_tiket': 50000, 'jumlah_tiket': 74, 'tanggal': '2025-06-09', 'kota': 'SBY', 'jam_tayang': '19:30', 'studio': 'C'},
{'judul_film': 'Frozen II', 'genre': 'Animasi', 'harga_tiket': 65000, 'jumlah_tiket': 132, 'tanggal': '2025-06-08', 'kota': 'MAKASSAR', 'jam_tayang': '18:00', 'studio': 'A'},
{'judul_film': 'Avengers: Infinity War', 'genre': 'Drama', 'harga_tiket': 75000, 'jumlah_tiket': 133, 'tanggal': '2025-06-01', 'kota': 'Jakarta', 'jam_tayang': '18:00', 'studio': 'D'},
{'judul_film': 'Train to Busan', 'genre': 'Komedi', 'harga_tiket': 55000, 'jumlah_tiket': 123, 'tanggal': '2025-06-01', 'kota': 'Bandung', 'jam_tayang': '19:30', 'studio': 'C'},
{'judul_film': 'Black Panther', 'genre': 'Action', 'harga_tiket': 55000, 'jumlah_tiket': 81, 'tanggal': '2025-06-04', 'kota': 'YOGYAKARTA', 'jam_tayang': '16:00', 'studio': 'C'},
{'judul_film': 'Captain America', 'genre': 'Komedi', 'harga_tiket': 80000, 'jumlah_tiket': 147, 'tanggal': '2025-06-09', 'kota': 'Surabaya', 'jam_tayang': '13:00', 'studio': 'D'},
{'judul_film': 'Avengers: Infinity War', 'genre': 'Sci-Fi', 'harga_tiket': 55000, 'jumlah_tiket': 150, 'tanggal': '2025-06-02', 'kota': 'jakarta', 'jam_tayang': '13:00', 'studio': 'C'},
{'judul_film': 'Inception', 'genre': 'Action', 'harga_tiket': 55000, 'jumlah_tiket': 130, 'tanggal': '2025-06-07', 'kota': 'Surabaya', 'jam_tayang': '14:30', 'studio': 'A'},
{'judul_film': 'Joker', 'genre': 'Animasi', 'harga_tiket': 75000, 'jumlah_tiket': 80, 'tanggal': '2025-06-14', 'kota': 'MEDAN', 'jam_tayang': '13:00', 'studio': 'A'},
{'judul_film': 'Iron Man', 'genre': 'Animasi', 'harga_tiket': 65000, 'jumlah_tiket': 67, 'tanggal': '2025-06-01', 'kota': 'makassar', 'jam_tayang': '18:00', 'studio': 'C'},
{'judul_film': 'Captain America', 'genre': 'Horor', 'harga_tiket': 80000, 'jumlah_tiket': 140, 'tanggal': '2025-06-15', 'kota': 'Semarang', 'jam_tayang': '20:00', 'studio': 'B'},
{'judul_film': 'Frozen II', 'genre': 'Sci-Fi', 'harga_tiket': 70000, 'jumlah_tiket': 65, 'tanggal': '2025-06-12', 'kota': 'JOGJA', 'jam_tayang': '20:00', 'studio': 'B'},
{'judul_film': 'Spiderman: No Way Home', 'genre': 'Komedi', 'harga_tiket': 80000, 'jumlah_tiket': 118, 'tanggal': '2025-06-12', 'kota': 'semarang', 'jam_tayang': '19:30', 'studio': 'D'},
{'judul_film': 'Captain America', 'genre': 'Drama', 'harga_tiket': 70000, 'jumlah_tiket': 131, 'tanggal': '2025-06-14', 'kota': 'JKT', 'jam_tayang': '16:00', 'studio': 'B'},
{'judul_film': 'Conjuring The Devil Made Me Do It', 'genre': 'Action', 'harga_tiket': 70000, 'jumlah_tiket': 103, 'tanggal': '2025-06-06', 'kota': 'Medan', 'jam_tayang': '14:30', 'studio': 'B'},
{'judul_film': 'Conjuring The Devil Made Me Do It', 'genre': 'Sci-Fi', 'harga_tiket': 75000, 'jumlah_tiket': 63, 'tanggal': '2025-06-10', 'kota': 'MEDAN', 'jam_tayang': '14:30', 'studio': 'B'},
{'judul_film': 'Doctor Strange: Multiverse of Madness', 'genre': 'Action', 'harga_tiket': 80000, 'jumlah_tiket': 66, 'tanggal': '2025-06-01', 'kota': 'MEDAN', 'jam_tayang': '19:30', 'studio': 'D'},
{'judul_film': 'Inception', 'genre': 'Action', 'harga_tiket': 60000, 'jumlah_tiket': 131, 'tanggal': '2025-06-08', 'kota': 'SURABAYA', 'jam_tayang': '13:00', 'studio': 'D'},
{'judul_film': 'Spiderman: No Way Home', 'genre': 'Sci-Fi', 'harga_tiket': 70000, 'jumlah_tiket': 66, 'tanggal': '2025-06-02', 'kota': 'Jakarta', 'jam_tayang': '19:30', 'studio': 'D'},
{'judul_film': 'Parasite', 'genre': 'Komedi', 'harga_tiket': 75000, 'jumlah_tiket': 85, 'tanggal': '2025-06-12', 'kota': 'SEMARANG', 'jam_tayang': '21:00', 'studio': 'D'},
{'judul_film': 'Frozen II', 'genre': 'Drama', 'harga_tiket': 75000, 'jumlah_tiket': 79, 'tanggal': '2025-06-11', 'kota': 'SURABAYA', 'jam_tayang': '20:00', 'studio': 'A'},
{'judul_film': 'Avenger Boy', 'genre': 'Komedi', 'harga_tiket': 55000, 'jumlah_tiket': 111, 'tanggal': '2025-06-08', 'kota': 'SMG', 'jam_tayang': '20:00', 'studio': 'A'},
{'judul_film': 'Black Panther', 'genre': 'Action', 'harga_tiket': 60000, 'jumlah_tiket': 105, 'tanggal': '2025-06-14', 'kota': 'SBY', 'jam_tayang': '18:00', 'studio': 'C'},
{'judul_film': 'Your Name', 'genre': 'Komedi', 'harga_tiket': 65000, 'jumlah_tiket': 77, 'tanggal': '2025-06-15', 'kota': 'SEMARANG', 'jam_tayang': '20:00', 'studio': 'B'},
{'judul_film': 'Spiderman: Far From Home', 'genre': 'Drama', 'harga_tiket': 65000, 'jumlah_tiket': 133, 'tanggal': '2025-06-06', 'kota': 'Yogyakarta', 'jam_tayang': '13:00', 'studio': 'B'},
{'judul_film': 'Spiderman: No Way Home', 'genre': 'Sci-Fi', 'harga_tiket': 80000, 'jumlah_tiket': 104, 'tanggal': '2025-06-13', 'kota': 'MAKASSAR', 'jam_tayang': '14:30', 'studio': 'A'},
{'judul_film': 'Laskar Pelangi', 'genre': 'Komedi', 'harga_tiket': 60000, 'jumlah_tiket': 139, 'tanggal': '2025-06-10', 'kota': 'SBY', 'jam_tayang': '19:30', 'studio': 'C'},
{'judul_film': 'Conjuring The Devil Made Me Do It', 'genre': 'Horor', 'harga_tiket': 80000, 'jumlah_tiket': 91, 'tanggal': '2025-06-15', 'kota': 'semarang', 'jam_tayang': '18:00', 'studio': 'A'},
{'judul_film': 'Inception', 'genre': 'Komedi', 'harga_tiket': 75000, 'jumlah_tiket': 78, 'tanggal': '2025-06-05', 'kota': 'MEDAN', 'jam_tayang': '22:00', 'studio': 'A'},
{'judul_film': 'Kimi no Na wa', 'genre': 'Komedi', 'harga_tiket': 80000, 'jumlah_tiket': 66, 'tanggal': '2025-06-04', 'kota': 'YOGYAKARTA', 'jam_tayang': '14:30', 'studio': 'D'},
{'judul_film': 'Frozen II', 'genre': 'Komedi', 'harga_tiket': 50000, 'jumlah_tiket': 61, 'tanggal': '2025-06-11', 'kota': 'Bandung', 'jam_tayang': '21:00', 'studio': 'C'},
{'judul_film': 'Avenger Boy', 'genre': 'Action', 'harga_tiket': 65000, 'jumlah_tiket': 85, 'tanggal': '2025-06-04', 'kota': 'makassar', 'jam_tayang': '19:30', 'studio': 'A'},
{'judul_film': 'Your Name', 'genre': 'Komedi', 'harga_tiket': 65000, 'jumlah_tiket': 135, 'tanggal': '2025-06-04', 'kota': 'JKT', 'jam_tayang': '20:00', 'studio': 'A'},
{'judul_film': 'The Avengers Assemble', 'genre': 'Horor', 'harga_tiket': 75000, 'jumlah_tiket': 132, 'tanggal': '2025-06-07', 'kota': 'Makassar', 'jam_tayang': '16:00', 'studio': 'A'},
{'judul_film': 'Parasite', 'genre': 'Horor', 'harga_tiket': 80000, 'jumlah_tiket': 74, 'tanggal': '2025-06-08', 'kota': 'MAKASSAR', 'jam_tayang': '21:00', 'studio': 'B'},
{'judul_film': 'The Batman', 'genre': 'Komedi', 'harga_tiket': 70000, 'jumlah_tiket': 62, 'tanggal': '2025-06-10', 'kota': 'MEDAN', 'jam_tayang': '13:00', 'studio': 'A'},
{'judul_film': 'Spiderman: Far From Home', 'genre': 'Animasi', 'harga_tiket': 60000, 'jumlah_tiket': 60, 'tanggal': '2025-06-08', 'kota': 'Jakarta', 'jam_tayang': '14:30', 'studio': 'B'},
{'judul_film': 'The Batman', 'genre': 'Animasi', 'harga_tiket': 75000, 'jumlah_tiket': 94, 'tanggal': '2025-06-02', 'kota': 'SMG', 'jam_tayang': '14:30', 'studio': 'C'},
{'judul_film': 'Captain America', 'genre': 'Action', 'harga_tiket': 60000, 'jumlah_tiket': 116, 'tanggal': '2025-06-12', 'kota': 'jakarta', 'jam_tayang': '19:30', 'studio': 'B'},
{'judul_film': 'Laskar Pelangi', 'genre': 'Drama', 'harga_tiket': 50000, 'jumlah_tiket': 75, 'tanggal': '2025-06-02', 'kota': 'SMG', 'jam_tayang': '14:30', 'studio': 'C'},
{'judul_film': 'Frozen II', 'genre': 'Horor', 'harga_tiket': 80000, 'jumlah_tiket': 123, 'tanggal': '2025-06-02', 'kota': 'JOGJA', 'jam_tayang': '20:00', 'studio': 'B'},
{'judul_film': 'Black Panther', 'genre': 'Komedi', 'harga_tiket': 80000, 'jumlah_tiket': 93, 'tanggal': '2025-06-04', 'kota': 'surabaya', 'jam_tayang': '16:00', 'studio': 'D'},
{'judul_film': 'Conjuring The Devil Made Me Do It', 'genre': 'Action', 'harga_tiket': 50000, 'jumlah_tiket': 68, 'tanggal': '2025-06-07', 'kota': 'SBY', 'jam_tayang': '22:00', 'studio': 'D'},
{'judul_film': 'Interstellar', 'genre': 'Komedi', 'harga_tiket': 60000, 'jumlah_tiket': 142, 'tanggal': '2025-06-15', 'kota': 'Makassar', 'jam_tayang': '20:00', 'studio': 'A'},
{'judul_film': 'Your Name', 'genre': 'Sci-Fi', 'harga_tiket': 55000, 'jumlah_tiket': 136, 'tanggal': '2025-06-01', 'kota': 'bandung', 'jam_tayang': '22:00', 'studio': 'B'},
{'judul_film': 'Parasite', 'genre': 'Action', 'harga_tiket': 60000, 'jumlah_tiket': 103, 'tanggal': '2025-06-07', 'kota': 'JAKARTA', 'jam_tayang': '22:00', 'studio': 'C'},
{'judul_film': 'Spiderman: Far From Home', 'genre': 'Komedi', 'harga_tiket': 80000, 'jumlah_tiket': 90, 'tanggal': '2025-06-02', 'kota': 'SBY', 'jam_tayang': '20:00', 'studio': 'C'},
{'judul_film': 'Black Panther', 'genre': 'Sci-Fi', 'harga_tiket': 80000, 'jumlah_tiket': 103, 'tanggal': '2025-06-11', 'kota': 'yogyakarta', 'jam_tayang': '20:00', 'studio': 'C'},
{'judul_film': 'Laskar Pelangi', 'genre': 'Komedi', 'harga_tiket': 65000, 'jumlah_tiket': 71, 'tanggal': '2025-06-07', 'kota': 'jakarta', 'jam_tayang': '14:30', 'studio': 'A'},
{'judul_film': 'Conjuring The Devil Made Me Do It', 'genre': 'Drama', 'harga_tiket': 60000, 'jumlah_tiket': 108, 'tanggal': '2025-06-11', 'kota': 'SEMARANG', 'jam_tayang': '19:30', 'studio': 'B'},
{'judul_film': 'Conjuring The Devil Made Me Do It', 'genre': 'Horor', 'harga_tiket': 60000, 'jumlah_tiket': 136, 'tanggal': '2025-06-01', 'kota': 'SMG', 'jam_tayang': '16:00', 'studio': 'D'},
{'judul_film': 'The Avengers Assemble', 'genre': 'Drama', 'harga_tiket': 75000, 'jumlah_tiket': 80, 'tanggal': '2025-06-13', 'kota': 'Surabaya', 'jam_tayang': '14:30', 'studio': 'B'},
{'judul_film': 'Spiderman: Homecoming', 'genre': 'Action', 'harga_tiket': 65000, 'jumlah_tiket': 100, 'tanggal': '2025-06-15', 'kota': 'SMG', 'jam_tayang': '18:00', 'studio': 'C'},
{'judul_film': 'Toy Story 4', 'genre': 'Action', 'harga_tiket': 60000, 'jumlah_tiket': 73, 'tanggal': '2025-06-06', 'kota': 'bandung', 'jam_tayang': '14:30', 'studio': 'B'},
{'judul_film': 'Frozen II', 'genre': 'Sci-Fi', 'harga_tiket': 55000, 'jumlah_tiket': 76, 'tanggal': '2025-06-01', 'kota': 'bandung', 'jam_tayang': '22:00', 'studio': 'A'},
{'judul_film': 'Frozen II', 'genre': 'Komedi', 'harga_tiket': 60000, 'jumlah_tiket': 82, 'tanggal': '2025-06-02', 'kota': 'BANDUNG', 'jam_tayang': '21:00', 'studio': 'A'},
{'judul_film': 'Doctor Strange: Multiverse of Madness', 'genre': 'Drama', 'harga_tiket': 55000, 'jumlah_tiket': 107, 'tanggal': '2025-06-05', 'kota': 'YOGYAKARTA', 'jam_tayang': '21:00', 'studio': 'D'}
]Problem 1 (10 points)
Calculate the total ticket revenue for each genre. (Revenue = harga_tiket × jumlah_tiket)
pendapatan_per_genre = {}
"""
Insert your code here.
"""
print("Total Revenue per Genre:")
for genre, total in pendapatan_per_genre.items():
print(f"- {genre}: {total}")Problem 2 (15 points)
Determine the average ticket price for each genre.
rata_rata_harga_per_genre = {}
"""
Insert your code here.
"""
print("Average Ticket Price per Genre:")
for genre, rata_rata in rata_rata_harga_per_genre.items():
print(f"- {genre}: {rata_rata:.2f}")Problem 3 (20 points)
Find the date with the largest number of tickets (accumulated over all films).
tanggal_terbanyak = None
"""
Insert your code here.
"""
print("\nDate with the largest number of tickets:", tanggal_terbanyak)Problem 4 (30 points)
Determine the city that showed the largest number of different films (number of unique titles).
kota_variasi_tertinggi = None
"""
Insert your code here.
"""
print("\nCity with the highest variety of films:", kota_variasi_tertinggi)Problem 5 (25 points)
Calculate the total revenue = harga_tiket * jumlah_tiket for each film. Determine the film with the highest revenue.
film_teruntung = None
"""
Insert your code here.
"""
print("\nMost profitable film:", film_teruntung)🎁 Bonus Problem: Find an Interesting Insight in the Dataset (10 points)
Explore this dataset freely, and find one interesting insight that was not asked about in the previous problems.
Examples of the kind of insight:
- The studio with the highest average revenue?
Translated by SOTA. The Indonesian original is the official version and wins wherever the two differ. Column names, genre values and variable names stay in Indonesian because the code uses them; the notebook explains each column, and a comment glosses the genre values. If you organise this olympiad and would like the translation removed, email [email protected] and we will take it down.
At a glance
- You get
- Data embedded in the notebook.
- You submit
- Printed answers from the completed code cells.
- Rules
- The data must not be modified.
- Format
- Final (on-site) of the AI Exhibition at OSN 2025, Universitas Muhammadiyah Malang, 6–10 October 2025: an essay paper and programming tasks in Google Colab.