Summary
Order ID Order Date
Length:5901 Min. :2019-01-01 00:00:00.00
Class :character 1st Qu.:2019-09-11 00:00:00.00
Mode :character Median :2020-03-16 00:00:00.00
Mean :2020-02-29 01:53:57.61
3rd Qu.:2020-09-14 00:00:00.00
Max. :2020-12-31 00:00:00.00
Ship Date Ship Mode Customer ID
Min. :2019-01-05 00:00:00.0 Length:5901 Length:5901
1st Qu.:2019-09-15 00:00:00.0 Class :character Class :character
Median :2020-03-19 00:00:00.0 Mode :character Mode :character
Mean :2020-03-04 00:08:47.0
3rd Qu.:2020-09-16 00:00:00.0
Max. :2021-01-05 00:00:00.0
Customer Name Segment Country City
Length:5901 Length:5901 Length:5901 Length:5901
Class :character Class :character Class :character Class :character
Mode :character Mode :character Mode :character Mode :character
State Region Product ID Category
Length:5901 Length:5901 Length:5901 Length:5901
Class :character Class :character Class :character Class :character
Mode :character Mode :character Mode :character Mode :character
Sub-Category Product Name Sales Quantity
Length:5901 Length:5901 Min. : 0.836 Min. : 1.000
Class :character Class :character 1st Qu.: 71.976 1st Qu.: 2.000
Mode :character Mode :character Median : 128.648 Median : 3.000
Mean : 265.346 Mean : 3.782
3rd Qu.: 265.170 3rd Qu.: 5.000
Max. :9099.930 Max. :14.000
Profit Returns Payment Mode
Min. :-6599.978 Length:5901 Length:5901
1st Qu.: 1.796 Class :character Class :character
Median : 8.502 Mode :character Mode :character
Mean : 29.700
3rd Qu.: 28.615
Max. : 8399.976
# A tibble: 6 × 20
`Order ID` `Order Date` `Ship Date` `Ship Mode` `Customer ID`
<chr> <dttm> <dttm> <chr> <chr>
1 CA-2019-160… 2019-01-01 00:00:00 2019-01-07 00:00:00 Standard C… BM-11575
2 CA-2019-160… 2019-01-02 00:00:00 2019-01-07 00:00:00 Standard C… BM-11575
3 CA-2019-160… 2019-01-02 00:00:00 2019-01-07 00:00:00 Standard C… BM-11575
4 CA-2019-125… 2019-01-03 00:00:00 2019-01-05 00:00:00 First Class LR-16915
5 US-2019-116… 2019-01-03 00:00:00 2019-01-08 00:00:00 Standard C… CA-12310
6 US-2019-116… 2019-01-03 00:00:00 2019-01-08 00:00:00 Standard C… CA-12310
# ℹ 15 more variables: `Customer Name` <chr>, Segment <chr>, Country <chr>,
# City <chr>, State <chr>, Region <chr>, `Product ID` <chr>, Category <chr>,
# `Sub-Category` <chr>, `Product Name` <chr>, Sales <dbl>, Quantity <dbl>,
# Profit <dbl>, Returns <chr>, `Payment Mode` <chr>
Structure
tibble [5,901 × 20] (S3: tbl_df/tbl/data.frame)
$ Order ID : chr [1:5901] "CA-2019-160304" "CA-2019-160304" "CA-2019-160304" "CA-2019-125206" ...
$ Order Date : POSIXct[1:5901], format: "2019-01-01" "2019-01-02" ...
$ Ship Date : POSIXct[1:5901], format: "2019-01-07" "2019-01-07" ...
$ Ship Mode : chr [1:5901] "Standard Class" "Standard Class" "Standard Class" "First Class" ...
$ Customer ID : chr [1:5901] "BM-11575" "BM-11575" "BM-11575" "LR-16915" ...
$ Customer Name: chr [1:5901] "Brendan Murry" "Brendan Murry" "Brendan Murry" "Lena Radford" ...
$ Segment : chr [1:5901] "Corporate" "Corporate" "Corporate" "Consumer" ...
$ Country : chr [1:5901] "United States" "United States" "United States" "United States" ...
$ City : chr [1:5901] "Gaithersburg" "Gaithersburg" "Gaithersburg" "Los Angeles" ...
$ State : chr [1:5901] "Maryland" "Maryland" "Maryland" "California" ...
$ Region : chr [1:5901] "East" "East" "East" "West" ...
$ Product ID : chr [1:5901] "FUR-BO-10004709" "FUR-BO-10004709" "TEC-PH-10000455" "OFF-ST-10003692" ...
$ Category : chr [1:5901] "Furniture" "Furniture" "Technology" "Office Supplies" ...
$ Sub-Category : chr [1:5901] "Bookcases" "Bookcases" "Phones" "Storage" ...
$ Product Name : chr [1:5901] "Bush Westfield Collection Bookcases, Medium Cherry Finish" "Bush Westfield Collection Bookcases, Medium Cherry Finish" "GE 30522EE2" "Recycled Steel Personal File for Hanging File Folders" ...
$ Sales : num [1:5901] 73.9 173.9 232 114.5 30.1 ...
$ Quantity : num [1:5901] 1 3 2 2 2 3 5 7 2 4 ...
$ Profit : num [1:5901] 28.27 38.27 67.27 28.61 -5.26 ...
$ Returns : chr [1:5901] "No" "No" "No" "No" ...
$ Payment Mode : chr [1:5901] "Online" "Online" "Cards" "Online" ...