📁 Project File

Click here to access the full Excel project on Google Drive

library(readxl)
Cancer_case <- read_excel("C:/Users/PC/Downloads/CANCER CASE ANALYSIS - OMOSOLA GBENGA(2).xlsx")
View(Cancer_case)

Project Overview

A comprehensive exploratory data analysis (EDA) of a large-scale cancer patient dataset (~890,000 records) spanning multiple European countries. Built entirely in Microsoft Excel using PivotTables, calculated fields and dynamic charts across structured analytical worksheets, then reproduced and extended in R for portfolio publication.

head(Cancer_case)
## # A tibble: 6 x 17
##      ID   age gender country     diagnosis_date      cancer_stage family_history
##   <dbl> <dbl> <chr>  <chr>       <dttm>              <chr>        <chr>         
## 1     1    52 Female Denmark     2014-06-02 00:00:00 Stage IV     Yes           
## 2     2    46 Female Netherlands 2014-06-02 00:00:00 Stage II     No            
## 3     3    57 Female Greece      2014-06-02 00:00:00 Stage II     No            
## 4     4    55 Male   Malta       2014-06-02 00:00:00 Stage III    Yes           
## 5     5    64 Female Czech Repu~ 2014-06-02 00:00:00 Stage I      Yes           
## 6     6    66 Male   Greece      2014-06-02 00:00:00 Stage IV     No            
## # i 10 more variables: smoking_status <chr>, bmi <dbl>,
## #   cholesterol_level <dbl>, hypertension <dbl>, asthma <dbl>, cirrhosis <dbl>,
## #   treatment_type <chr>, end_treatment_date <dttm>, survived <dbl>,
## #   `Treatment Duration` <dbl>
summary(Cancer_case)
##        ID              age            gender            country         
##  Min.   :     1   Min.   :  4.00   Length:890000      Length:890000     
##  1st Qu.:222501   1st Qu.: 48.00   Class :character   Class :character  
##  Median :445001   Median : 55.00   Mode  :character   Mode  :character  
##  Mean   :445001   Mean   : 55.01                                        
##  3rd Qu.:667500   3rd Qu.: 62.00                                        
##  Max.   :890000   Max.   :104.00                                        
##  diagnosis_date                cancer_stage       family_history    
##  Min.   :2014-06-02 00:00:00   Length:890000      Length:890000     
##  1st Qu.:2016-12-01 00:00:00   Class :character   Class :character  
##  Median :2019-06-04 00:00:00   Mode  :character   Mode  :character  
##  Mean   :2019-06-02 01:22:51                                        
##  3rd Qu.:2021-12-01 00:00:00                                        
##  Max.   :2024-05-30 00:00:00                                        
##  smoking_status          bmi        cholesterol_level  hypertension 
##  Length:890000      Min.   :16.00   Min.   :150.0     Min.   :0.00  
##  Class :character   1st Qu.:23.30   1st Qu.:196.0     1st Qu.:1.00  
##  Mode  :character   Median :30.50   Median :242.0     Median :1.00  
##                     Mean   :30.49   Mean   :233.6     Mean   :0.75  
##                     3rd Qu.:37.70   3rd Qu.:271.0     3rd Qu.:1.00  
##                     Max.   :45.00   Max.   :300.0     Max.   :1.00  
##      asthma         cirrhosis     treatment_type    
##  Min.   :0.0000   Min.   :0.000   Length:890000     
##  1st Qu.:0.0000   1st Qu.:0.000   Class :character  
##  Median :0.0000   Median :0.000   Mode  :character  
##  Mean   :0.4697   Mean   :0.226                     
##  3rd Qu.:1.0000   3rd Qu.:0.000                     
##  Max.   :1.0000   Max.   :1.000                     
##  end_treatment_date               survived      Treatment Duration
##  Min.   :2014-12-02 00:00:00   Min.   :0.0000   Min.   :183.0     
##  1st Qu.:2018-03-06 00:00:00   1st Qu.:0.0000   1st Qu.:367.0     
##  Median :2020-09-03 00:00:00   Median :0.0000   Median :458.0     
##  Mean   :2020-09-02 03:28:22   Mean   :0.2202   Mean   :458.1     
##  3rd Qu.:2023-03-03 00:00:00   3rd Qu.:0.0000   3rd Qu.:550.0     
##  Max.   :2026-05-30 00:00:00   Max.   :1.0000   Max.   :730.0