First glance at data frame

Our dataset contains the following variables:

  1. Date: Represents the date of the trip.

  2. Request_Id: Unique identifier for each ride request.

  3. User_Name: The name or identifier of the user who requested the ride.

  4. Driver_Name: The name or identifier of the driver who completed the ride.

  5. Trip_Status: Indicates the status of the trip, such as completed or cancelled.

  6. Paid_Status: Represents the payment status of the trip, whether it has been paid or not.

  7. Payment_Option: The chosen payment option for the trip.

  8. Vehicle_Type: Specifies the type of vehicle used for the ride.

  9. Ride_Type: Indicates the type of ride, such as regular-instant, or regular-scheduled.

  10. Trip_Time_Minutes: Represents the duration of the trip in minutes.

  11. Trip_Distance_Km: The distance traveled during the trip in kilometers.

  12. Admin_Commission_ZAR: The commission amount charged by the administration for the ride in ZAR (South African Rand).

  13. Total_Amount_ZAR: The total amount paid for the trip in ZAR.

  14. Driver_Commission_ZAR: The commission amount earned by the driver for the ride in ZAR.

Three main elements will be the focus of this report: “Card”, “Cash”, and “Wallet”, which shows the types of payment options employed by Bozaride users.
The aim is to compare how much income is made monthly from each category for August and September 2024.

Data processing, preparation, and feature engineering.

Our dataset has undergone pre-processing, preparation and the necessary transformation.

We now observe that:

5 of the 14 variables are numeric or quantitative(or “numbers”) variables. These are Trip_Time_Minutes, Trip_Distance_Km, Admin_Commission_ZAR, Total_Amount_ZAR, and Driver_Commission_ZAR.

5 are factors (or categorical variables), with varying levels. These include: Paid_Status, Trip_status, payment_option, vehicle_type, and ride_type.

3 variables are character or name variables: Request_Id, User_name, and Driver_name.

1 variable is a Date variable.

For the purpose of our current analysis however, we will now streamline our dataset to accommodate only August and September 2024.
The following steps highlight such operations.

DATA FILTERING FOCUSING ON AUGUST 2024

(1.) Total Amount Break-down.

The total amounts in South African Rands, made from each payment options in August are:

Card R1691
Cash R1480
Wallet R15015

The Admin Commission Gained in South African Rands, made from each payment options in August are:
1 Card R230
2 Cash R201
3 Wallet R2048

Key summary for August 2024

summary(August_Only)
##       Date             Request_Id         User_Name         Driver_Name       
##  Min.   :2024-08-01   Length:171         Length:171         Length:171        
##  1st Qu.:2024-08-08   Class :character   Class :character   Class :character  
##  Median :2024-08-15   Mode  :character   Mode  :character   Mode  :character  
##  Mean   :2024-08-15                                                           
##  3rd Qu.:2024-08-22                                                           
##  Max.   :2024-08-31                                                           
##                                                                               
##     Trip_Status   Paid_Status Payment_Option    Vehicle_Type
##  Cancelled:97   Not Paid:97   Card  : 10     XL       : 1   
##  Completed:74   Paid    :74   Cash  : 27     Comfort  :60   
##                               Wallet:134     Pickup   :36   
##                                              Regular  :74   
##                                              Lux      : 0   
##                                              Boza Care: 0   
##                                                             
##            Ride_Type   Trip_Time_Minutes Trip_Distance_KM Driver_Commission_ZAR
##  Regular-Instant:171   Min.   :  0.00    Min.   : 0.00    Min.   : 27.6        
##                        1st Qu.:  0.00    1st Qu.: 0.00    1st Qu.:112.5        
##                        Median :  0.00    Median : 0.00    Median :176.0        
##                        Mean   : 20.42    Mean   :11.07    Mean   :212.6        
##                        3rd Qu.: 34.00    3rd Qu.:19.60    3rd Qu.:280.3        
##                        Max.   :157.00    Max.   :68.59    Max.   :524.2        
##                                                           NA's   :97           
##  Admin_Commision_ZAR Total_Amount_ZAR
##  Min.   : 4.35       Min.   : 18.0   
##  1st Qu.:17.71       1st Qu.:131.0   
##  Median :27.73       Median :204.5   
##  Mean   :33.49       Mean   :245.8   
##  3rd Qu.:44.15       3rd Qu.:324.8   
##  Max.   :82.56       Max.   :607.0   
##  NA's   :97          NA's   :97

The output above offers a pool of values which can be studied extensively for the activities of August.

DATA FILTERING FOCUSING ON SEPTEMBER 2024

(1.) Total Amount Break-down.

The total amounts in south African Rands, made from each payment options are:.

Card R197
Cash R1968
Wallet R13687

(2.) Admin Commision Break-down.

The admin commissions gained from each payment options are as follow:.
Card R26.72
Cash R290.38
Wallet R1858.74

Key summary for September 2024

summary(September_Only)
##       Date             Request_Id         User_Name         Driver_Name       
##  Min.   :2024-09-01   Length:247         Length:247         Length:247        
##  1st Qu.:2024-09-13   Class :character   Class :character   Class :character  
##  Median :2024-09-23   Mode  :character   Mode  :character   Mode  :character  
##  Mean   :2024-09-19                                                           
##  3rd Qu.:2024-09-25                                                           
##  Max.   :2024-09-29                                                           
##                                                                               
##     Trip_Status    Paid_Status  Payment_Option    Vehicle_Type
##  Cancelled:183   Not Paid:183   Card  :  5     XL       : 1   
##  Completed: 64   Paid    : 64   Cash  : 36     Comfort  :61   
##                                 Wallet:206     Pickup   :72   
##                                                Regular  :97   
##                                                Lux      :14   
##                                                Boza Care: 2   
##                                                               
##            Ride_Type   Trip_Time_Minutes Trip_Distance_KM Driver_Commission_ZAR
##  Regular-Instant:247   Min.   :  0.00    Min.   : 0.000   Min.   : 32.6        
##                        1st Qu.:  0.00    1st Qu.: 0.000   1st Qu.:132.2        
##                        Median :  0.00    Median : 0.000   Median :191.3        
##                        Mean   : 11.12    Mean   : 6.457   Mean   :215.9        
##                        3rd Qu.: 10.00    3rd Qu.: 3.020   3rd Qu.:240.0        
##                        Max.   :178.00    Max.   :61.510   Max.   :558.5        
##                                                           NA's   :183          
##  Admin_Commision_ZAR Total_Amount_ZAR
##  Min.   : 5.13       Min.   : 38.0   
##  1st Qu.:20.82       1st Qu.:153.8   
##  Median :30.14       Median :222.0   
##  Mean   :34.00       Mean   :247.7   
##  3rd Qu.:37.80       3rd Qu.:278.2   
##  Max.   :87.97       Max.   :647.0   
##  NA's   :183         NA's   :183

The output above offers a pool of values which can be studied extensively for the activities of September.

Performance Comparison: August vs. September

Total Amount by Payment Option.
-August:
Card: R 1691 (9.3%)
Cash: R 1480 (8.1%)
Wallet: R 15,000+ (82.6%)

-September:
Card: R 197 (1.2%)
Cash: R 1968 (12.4%)
Wallet: R 13,000+ (86.3%)

Comparison:

*** Wallet remains the dominant payment option in both months, slightly increasing its share in September.***

-Card usage significantly decreased in September. -Cash usage increased from August to September.

Admin Commission Gain by Payment Option

-August:
Card: R 229.68 (9.3%)
Cash: R 201.09 (8.1%)
Wallet: R 2000+ (82.6%)

-September:
Card: R 26.72 (1.2%)
Cash: R 290.38 (13.3%)
Wallet: R 1800+ (85.4%)

Comparison:

Similar to total amounts, wallet commissions increased in September.
Card commissions dropped significantly.
Cash commissions saw an increase from August to September.

Summary Overall, both total amounts and admin gains(or profit) show a consistent preference for wallet transactions, with a noticeable decline in card usage and an increase in cash transactions from August to September.

ADDITIONAL WEEKLY REPORT (from “tawk.to”) - 23rd - 29th September.

Number of visits: 1416
Number of Chats: 16
Missed Chats: 0
Received offline Messages: 156
Tickets Created: 54
Tickets resolved: 0
Engagement Response Rate: 1.1%