(Total Points: 300)
Your mission is to help Professor Oak analyze the stats of seven Pokémon-owned companies in the Kanto region: Voltas, Blue Star, Crompton, Orient Electric, Havells, Symphony, and Whirlpool, to help the Pokémon understand their strengths and weaknesses better and improve their skills.
Note: This task must be completed using web-scraping techniques. You are allowed to use any available code-based web-scraping tools to complete the task. Data cannot be manually extracted or downloaded from the given site.
Professor Oak has provided a single Pokédex entry point (URL) to access all the Pokémon stats from Screener.in for these companies. You will start by analyzing Voltas, but remember, you can only use one entry point to extract data for all companies. You can navigate to the other companies using the search bar located at the top of the page.
- Voltas (CEO: Pikachu)
- Blue Star (CEO: Squirtle)
- Crompton (CEO: Charmander)
- Orient Electric (CEO: Bulbasaur)
- Havells (CEO: Eevee)
- Symphony (CEO: Jigglypuff)
- Whirlpool (CEO: Gyarados)
Help Pikachu and friends by gathering their basic Power Stats:
- Market Cap
- Stock P/E
- ROCE
- Current Price
- ROCE
- ROE
This will give them insights into their current strengths.
Extract their Item Inventory (balance sheet) to understand how much:
- Reserves
- Borrowings
- Total Liabilities
- Fixed Assets
- Investments
- Total Assets
Focus only on March 2024 for this task.
Finally, gather their Battle Performance Stats over the last three years (March 2022, March 2023, and March 2024):
- Sales
- Net Profit
- OPM
- EPS
This will help the trainers see how well they’ve done in recent Pokémon battles!
Each of these tasks needs to collect the specified data for all 7 companies, and aggregate them in the format given below. Each of the stats in every category needs to be extracted.
You need to return your findings to Professor Oak in the form of three Pokédex Data Files (CSV files):
- Basic_Pokemon_Stats.csv
- Pokemon_Item_Inventory.csv
- Battle_Performance_Stats.csv
Each CSV file should correspond to one of the tasks mentioned above. Write one separate function for each task to generate the respective Pokédex Data File. Each task will be graded separately. Finally, execute each function to generate the Data Files.
As a Pokémon researcher, you must also upload your code to GitHub (Pokémon HQ). This way, other Pokémon Trainers can also benefit from your findings! Follow the standard instructions from README.md. Also, make sure to upload the Data Files that you create to the GitHub repository.