This repository provides an in-depth analysis of the cab industry in the United States, focusing on two major companies, Pink Cab and Yellow Cab. It explores market trends, transaction comparisons, demographic insights, customer behavior, profitability ratios, regional profit analysis, and forecasting future performance. The goal is to present clear insights to help stakeholders make informed investment decisions and understand the dynamics of the cab industry.
- Market Trends: Understand yearly and monthly patterns, peak periods, and the growth of the cab market.
- Transaction Comparisons: Compare ride volumes, revenues, and costs between Pink Cab and Yellow Cab.
- Demographic Insights: Detailed analysis of customer segments based on age, income, location, and other demographics.
- Customer Behavior Analysis: Examine frequent destinations, ride frequency, and peak usage times to understand customer preferences.
- Profitability Ratios: Assess key financial ratios to evaluate the efficiency and profitability of both companies.
- Regional Profit Analysis: Identify regions that generate the highest revenue and profit.
- Forecasting: Use predictive models to forecast future trends, transaction volumes, and potential growth.
/analyze: Contains the results of the cab industry analysis, including trend analysis, comparisons, and insights. /etl: Contains data processing scripts, including data cleaning, transformation, and outlier handling for analysis purposes.
The data used in this analysis is obtained from open data sources and includes:
- Company transaction records (e.g., date, fees, profit, costs)
- Customer demographic information (e.g., age, gender, income level, location)
- Regional data on revenue and transactions
- Market Trends: Explore the growth patterns of the cab industry and identify peak periods.
- Transaction Comparisons: Understand the performance differences between Pink Cab and Yellow Cab across different regions.
- Customer Segmentation: Identify key customer segments and analyze their preferences and behavior.
- Profitability Analysis: Compare the financial efficiency of the two companies using key profitability ratios.
- Regional Analysis: Classify regions based on revenue and profit levels to identify potential areas for expansion.
We provide a range of visualizations to make the data easier to understand:
- Line charts: Display trends in daily and monthly transactions, revenues, and costs.
- Bar charts: Compare financial metrics and transaction volumes between Pink Cab and Yellow Cab.
- Heatmaps: Show regional profitability and highlight areas with high or low performance.
- Pie charts: Represent the distribution of transactions and profits across different customer segments.
- Clone the repository:
git clone https://github.com/Pra5etya/Covid-in-Indonesia.git
- Install Git lfs:
git lfs install
git lfs track 'file_name.extension'
- Setup environment:
python -m venv my_env
source my_env\Scripts\activate || my_env\Scripts\activate
- Install the required packages:
pip install -r requirements.txt
The detailed report can be found in the .pdf file within the repository. It provides an in-depth overview of all key insights, analysis methodologies, and future recommendations for stakeholders.