Analysis of Sales Data of an E-commerce Portal
Submitted by Group 4
Himanshu PGP32300
Shikhar Kohli PGP32117
Deepak Sharma PGP32146
Rounak Khemka PGP32199
Subhra Halder PGP32204
Abhishek PGP32279
Our key findings
- 31869 customers were unique (Total Transactions 45898)
- App05, Happy30, ICICV500JG, NEW30, NEW25, RUSH30, SALE30, STYLE25, STYLE30, WOW30 were the key website discount coupon codes
- Tops and dresses were the key subcategories (demand wise)
- Maharashtra, Karnatka, Delhi and UP were the top states (Transaction wise)
- New Delhi, Bengaluru, Mumbai, Pune, Hyderabad and Kolkata were the top cities (Transaction Wise)
- Black was the most demanded color in apparel category; followed by blue
- Medium followed by small were the most ordered sizes by customers
- Harpa followed by Gritsones, Faballey and Moneteil and Munero were the most ordered brands
- Gritstones was the only brand without any vendor discount
Decision tree analysis
We begin with a decision tree analysis
secondaryData.df$Brand_Numeric <- as.factor(secondaryData.df$Brand_Numeric);
secondaryData.df$Category_Numeric <- as.factor(secondaryData.df$Category_Numeric);
secondaryData.df$SubCategory_Numeric <- as.factor(secondaryData.df$SubCategory_Numeric);
secondaryData.df$ProductColor_Numeric <- as.factor(secondaryData.df$ProductColor_Numeric);
secondaryData.df$ProductSize_Numeric<- as.factor(secondaryData.df$ProductSize_Numeric);
secondaryData.df$ShippingCity_Numeric <- as.factor(secondaryData.df$ShippingCity_Numeric);
secondaryData.df$ShippingState_Numeric <- as.factor(secondaryData.df$ShippingState_Numeric);
secondaryData.df$WebsiteDiscountCode_Numeric <- as.factor(secondaryData.df$WebsiteDiscountCode_Numeric);
secondaryData.df$Website_Vendor <- as.factor (secondaryData.df$Website_Vendor);
## Plotting decision tree to see impact of website discount on Brand
dt1 <- secondaryData.df$Brand ~ secondaryData.df$HasWebsiteDiscount;
dt1_tree <- ctree(dt1, data=secondaryData.df);
plot(dt1_tree);
## Plotting decision tree to see impact of vendor discount on Brand
dt2 <- secondaryData.df$Brand ~ secondaryData.df$HasVendorDiscount;
dt2_tree <- ctree(dt2, data=secondaryData.df);
plot(dt2_tree);
## Plotting decision tree to see impact of vendor discount or website on Brand
dt3 <- secondaryData.df$Brand ~ secondaryData.df$Website_Vendor
dt3_tree <- ctree(dt3, data=secondaryData.df);
plot(dt3_tree);
## Plotting decision tree to see impact of vendor discount and website on Brand
dt4 <- secondaryData.df$Brand ~ secondaryData.df$HasVendorDiscount + secondaryData.df$HasWebsiteDiscount;
dt4_tree <- ctree(dt4, data=secondaryData.df);
plot(dt4_tree);
Determine the number of customers served in the time period
### Unique Customers
salesData.df$CustomerID <- as.numeric(salesData.df$CustomerID);
unique_customers<-unique(salesData.df$CustomerID);
length(unique_customers);
[1] 31869
Which are the most and least popular sizes?
Size M is the most popular. Shirt size 46 is the least popular
### Size Analysis (in descending order)
t = table(salesData.df$ProductSize);
z = as.data.frame(t);
head(z[order(-z$Freq),c(1,2)])
Var1 Freq
14 M 12959
13 L 11087
15 S 9556
16 XL 7350
18 XXL 2199
17 XS 670
head(z[order(z$Freq),c(1,2)])
Var1 Freq
11 46 1
7 3XL 18
5 36 21
1 28 55
4 34 56
2 30 71
Assessing subcategory demand
Through this analysis, the best sellers and worst sellers on the store can be determined
x <- aggregate ( salesData.df$OrderID ~ salesData.df$SubCategory, salesData.df, length)
x[order(x$`salesData.df$OrderID`, decreasing = TRUE),]
salesData.df$SubCategory salesData.df$OrderID
49 TOPS 14605
12 DRESSES 8869
30 POLO-T-SHIRTS 3793
33 ROUND NECK T-SHIRTS 2937
38 SHIRTS 2897
9 CASUAL SHIRTS 1882
56 V NECK T-SHIRTS 1707
17 HENLEY T-SHIRTS 1621
18 HIGH NECK T SHIRTS 1114
53 TROUSERS 1048
48 T SHIRTS 991
42 SKIRTS 826
58 WINTER JACKETS 548
57 WAISTCOATS 345
39 SHORTS 286
21 JEGGINGS 247
7 CAPS & HATS 238
40 SHRUGS 211
22 JUMPSUITS 165
10 CHINOS 148
24 KURTIS 137
46 SWEATERS 128
23 KURTAS 122
54 TUNICS 122
8 CASUAL JACKETS 96
47 SWEATSHIRTS 96
13 ETHNIC JACKETS 84
35 SALWAR 64
50 TRACK PANTS 62
27 MANDARIN T-SHIRTS 51
44 SUITS 50
37 SHIFT DRESS 44
28 NIGHTWEAR 41
6 CAPRIS 35
19 JACKETS & BLAZERS 34
5 CAMISOLES 32
41 SKATER DRESS 32
25 LEGGINGS 30
4 BODYCON DRESS 25
32 ROUND NECK SWEATERS 24
1 3/4THS 18
34 ROUND NECK VESTS 16
2 ASYMMETRIC DRESS 15
11 DENIM JACKETS 12
15 FORMAL TROUSERS 10
55 V NECK SWEATERS 8
36 SCARVES 7
3 BEACHWEAR 4
45 SUMMER JACKETS 4
26 LOUNGEWEAR 3
29 OFF SHOULDER/TUBE/HALTER 3
14 FORMAL SHIRTS 2
20 JEANS 2
31 QUILTED JACKETS 2
51 TRACKPANTS 2
16 GSTOP235BLK 1
43 STOCKINGS 1
52 TRACKSUITS 1
Assessing subcategory demand
The worst sellers are…
head(x[order(x$`salesData.df$OrderID`, decreasing = FALSE),])
salesData.df$SubCategory salesData.df$OrderID
16 GSTOP235BLK 1
43 STOCKINGS 1
52 TRACKSUITS 1
14 FORMAL SHIRTS 2
20 JEANS 2
31 QUILTED JACKETS 2
Brand analysis
setwd('~/code/DAM/project')
data<-read.csv("data/Data.csv");
x<- data.frame(data$Brand, data$HasVendorDiscount, data$HasWebsiteDiscount, data$Website_Vendor, data$
VendorDiscount, data$WebsiteDiscount);
source("http://pcwww.liv.ac.uk/~william/R/crosstab.r");
crosstab(x, row.vars = "data.Brand");
data.Brand Count Total %
ATHENA 4140.00 9.02
FABALLEY 6899.00 15.03
GRITSTONES 6901.00 15.04
HARPA 7271.00 15.84
MEIRA 5422.00 11.81
MISS CHASE 1678.00 3.66
MONTEIL & MUNERO 6539.00 14.25
MR BUTTON 848.00 1.85
THE VANCA 4804.00 10.47
TSHIRT COMPANY 1396.00 3.04
Sum 45898.00 100.00
crosstab(x, row.vars = "data.Brand", col.vars = "data.HasVendorDiscount");
data.HasVendorDiscount 0 1 Sum
data.Brand
ATHENA 1866 2274 4140
FABALLEY 4102 2797 6899
GRITSTONES 6901 0 6901
HARPA 3226 4045 7271
MEIRA 3001 2421 5422
MISS CHASE 8 1670 1678
MONTEIL & MUNERO 1918 4621 6539
MR BUTTON 340 508 848
THE VANCA 102 4702 4804
TSHIRT COMPANY 1218 178 1396
Sum 22682 23216 45898
crosstab(x, row.vars = "data.Brand", col.vars = "data.HasWebsiteDiscount");
data.HasWebsiteDiscount 0 1 Sum
data.Brand
ATHENA 2538 1602 4140
FABALLEY 2899 4000 6899
GRITSTONES 6154 747 6901
HARPA 4087 3184 7271
MEIRA 4485 937 5422
MISS CHASE 1281 397 1678
MONTEIL & MUNERO 3813 2726 6539
MR BUTTON 221 627 848
THE VANCA 3834 970 4804
TSHIRT COMPANY 559 837 1396
Sum 29871 16027 45898
crosstab(x, row.vars = "data.Brand", col.vars = "data.Website_Vendor");
data.Website_Vendor 0 1 Sum
data.Brand
ATHENA 710 3430 4140
FABALLEY 1232 5667 6899
GRITSTONES 6154 747 6901
HARPA 930 6341 7271
MEIRA 2452 2970 5422
MISS CHASE 6 1672 1678
MONTEIL & MUNERO 515 6024 6539
MR BUTTON 61 787 848
THE VANCA 56 4748 4804
TSHIRT COMPANY 420 976 1396
Sum 12536 33362 45898
Analysing select brands
brand_harpa.df <- subset(salesData.df, Brand == "HARPA")
mytable <- xtabs(~ FinalTotalPrice + HasVendorDiscount + HasWebsiteDiscount, data=brand_harpa.df)
margin.table(mytable, c(2,3))
HasWebsiteDiscount
HasVendorDiscount 0 1
0 930 2296
1 3157 888
brand_vanca.df <- subset(salesData.df, Brand == "THE VANCA")
mytable2 <- xtabs(~ FinalTotalPrice + HasVendorDiscount + HasWebsiteDiscount, data=brand_vanca.df)
margin.table(mytable2, c(2,3))
HasWebsiteDiscount
HasVendorDiscount 0 1
0 56 46
1 3778 924
brand_grit.df <- subset(salesData.df, Brand == "GRITSTONES")
mytable3 <- xtabs(~ FinalTotalPrice + HasVendorDiscount + HasWebsiteDiscount, data=brand_grit.df)
margin.table(mytable3, c(2,3))
HasWebsiteDiscount
HasVendorDiscount 0 1
0 6154 747
Shipments from states
x <- aggregate ( salesData.df$OrderID ~ salesData.df$ShippingState, salesData.df, length)
x[order(x$`salesData.df$OrderID`, decreasing = TRUE),1:2]
salesData.df$ShippingState salesData.df$OrderID
19 MH 8669
17 KA 5762
9 DL 5392
30 UP 3959
14 HR 3003
2 AP 2840
32 WB 2357
12 GJ 1905
28 TN 1749
26 RJ 1242
21 MP 1148
23 OR 1141
24 PB 1076
4 AS 861
16 JK 651
15 JH 557
6 CH 547
11 GA 523
31 UT 518
5 BR 423
18 KL 371
7 CT 360
13 HP 290
20 ML 275
22 MZ 121
29 TR 53
25 PY 32
10 DN 23
27 SK 22
1 AN 18
8 DD 9
3 AR 1
Billings to states
x <- aggregate ( salesData.df$OrderID ~ salesData.df$BillingState, salesData.df, length)
x[order(x$`salesData.df$OrderID`, decreasing = TRUE),1:2]
salesData.df$BillingState salesData.df$OrderID
18 MH 8668
16 KA 5750
8 DL 5504
31 UP 3962
13 HR 2916
2 AP 2864
33 WB 2345
11 GJ 1879
29 TN 1728
27 RJ 1244
24 OR 1160
21 MP 1157
25 PB 1050
3 AS 855
15 JK 648
14 JH 548
5 CH 543
10 GA 521
32 UT 515
4 BR 442
17 KL 386
6 CT 361
12 HP 297
19 ML 273
22 MZ 116
30 TR 52
26 PY 36
9 DN 24
28 SK 23
1 AN 16
7 DD 9
20 MN 3
23 NL 3
Shipments from cities
x <- aggregate ( salesData.df$OrderID ~ salesData.df$ShippingCity, salesData.df, length)
x[order(x$`salesData.df$OrderID`, decreasing = TRUE),]
salesData.df$ShippingCity
71 Bangalore
476 New Delhi
444 Mumbai
527 Pune
263 Gurgaon
286 Hyderabad
375 Kolkata
482 Noida
144 Chennai
643 Thane
243 Ghaziabad
478 New delhi
15 Ahmedabad
299 Jaipur
405 Lucknow
630 Surat
138 Chandigarh
388 Krda
220 Faridabad
266 Guwahati
623 Srinagar
459 Nagpur
289 Indore
177 Dehradun
309 Jammu
596 Shillong
549 Ranchi
692 Vadodara
34 Amritsar
707 Visakhapatnam
406 Ludhiana
514 Patna
485 North Goa
618 South Goa
303 Jalandhar
451 Mysore
119 Bpal
339 Kanchipuram
25 Allahabad
107 Bhubaneshwar
438 Mohali
161 Cuttack
311 Jamshedpur
323 Jodhpur
537 Raipur
432 Meerut
587 Secunderabad
338 Kamrup
296 Jabalpur
675 Udaipur
469 Navi Mumbai
597 Shimla
513 Patiala
156 Coimbatore
267 Gwalior
18 Aizawl
467 Nashik
500 Panchkula
13 Agra
212 Ernakulam
506 Panvel
696 Varanasi
341 Kanpur Dehat
652 Thiruvananthapuram
602 Siliguri
540 Rajkot
79 Bareily
105 Bhopal
191 Dibrugarh
29 Ambala
235 Gandhi Nagar
694 Valsad
421 Mangalore
701 Vellore
380 Kota
536 Raigarh (MH)
679 Udupi
440 Moradabad
49 Aurangabad
90 Belgaum
368 Khorda
178 Delhi
497 Panaji
253 Gorakhpur
713 West Midnapore
168 Dakshina Kannada
342 Kanpur Nagar
579 Sambalpur
12 Agartala
198 Durg
281 Hissar
184 Dhanbad
352 Karnal
23 Aligarh
374 Kolhapur
19 Ajmer
617 South Chennai
84 Bastar
318 Jhansi
535 Raigarh
559 Rohtak
600 Sikar
615 Sonipat
27 Alwar
78 Bardhaman
122 Budgam
538 Rajahmundry
560 Roorkee
86 Bathinda
94 Bhagalpur
176 Davangare
395 Kurnool
188 Dharward
584 Satara
657 Tinsukia
174 Darjiling
714 Wrah
16 Ahmedabad
97 Bharuch
112 Bikaner
429 Mathura
32 Amravati
260 Gulbarga
345 Kapurthala
601 Silchar
413 Madurai
521 Pondicherry
648 Thanesar
709 Warangal
611 Sivasagar
37 Anand
155 Cochin
262 Guntur
555 Rewa
572 Sagar
613 Solapur
139 Chandrapur
284 Howrah
627 Sundergarh
681 Ujjain
715 Yamuna Nagar
43 Angul
110 Bijapur
219 Faizabad
238 Ganjam
239 Gautam Budh Nagar
340 Kangra
703 Vijayawada
502 Panipat
641 Tezpur
99 Bhavnagar
162 DELHI
236 Gandhidham
379 Korba
272 Hamirpur
310 Jamnagar
658 Tiruchirappalli
676 Udham Singh Nagar
103 Bhiwandi
117 Bokaro
449 Muzaffarpur
474 Nellore
573 Saharanpur
607 Sirsa
91 Bellary
274 Haridwar
387 Kozhikode
471 Navsari
575 Salem
325 Junagadh
21 Akola
66 Balasore
333 Kakinada
486 North Lakhimpur
529 Purnia
612 Solan
790 varanasi
167 Dadri
208 East Singhbhum
671 Tumkur
237 Ganganagar
337 Kalyanpur
344 Kanyakumari
389 Krishna
487 Oghly
148 Chikmagalur
278 Hazaribagh
512 Pathankot
520 Ponda
563 Rourkela
581 Sangli
101 Bhilai
171 Daman
173 Darbhanga
360 Katni
460 Nainital
483 North 24 Parganas
557 Rishikesh
659 Tirunelveli
102 Bhilwara
157 Cooch Behar
271 Haldwani
282 Hooghly
324 Jorhat
80 Baripada
87 Beawar
305 Jalgaon
418 Mandi
532 ROORKEE
534 Raichur
616 Sonitpur
93 Bhadrak
104 Bhiwani
109 Bidar
145 Chhatarpur
159 Cuddalore
355 Karwar
359 Katihar
614 Sonbhadra
660 Tirupati
123 Bulandshahr
417 Malda
435 Mirzapur
594 Shiarpur
711 Wardha
8 Abohar
17 Ahmednagar
38 Ananthapur
44 Ankleshwar
151 Chittoor
213 Erode
367 Kheda
450 Mw
473 Nehru Road
523 Port Blair
585 Satna
626 Sultanpur
698 Vasai
77 Barbil
89 Begusarai
120 Brahmapur
137 Chandauli
186 Dharamshala
261 Guna
314 Jeypore
321 Jhujhunu
551 Ranipool
605 Singrauli
60 Bagalkot
72 Banswara
205 East Khasi Hills
249 Gonda
322 Jind
343 Kanpur dehat
349 Karim Nagar
420 Mandya
462 Nalanda
541 Rajpura
547 Rampur
553 Ratnagiri
561 Ropar
609 Sitapur
649 Thanjavur
712 West Godavari
732 chennai
40 Andlu
160 Cuddapah
204 East Godavari
230 GHAZIABAD
233 GURGAON
312 Jaunpur
63 Bahadurgarh
183 Dewas
187 Dharmapuri
199 Durgapur
241 Gaya
247 Golaghat
275 Hassan
285 Hubli
297 Jagdalpur
357 Kashipur
461 Nalagarh
488 Ooty
46 Asansol
48 Auraiya
116 Birbhum
132 Chaibasa
172 Damoh
270 Haldia
431 Medak
454 NEW DELHI
509 Pardi
522 Porbandar
719 ahmedabad
81 Barmer
126 Burdwan
169 Dakshina kannada
190 Dhule
194 Dindori
354 Karur
370 Kishangarh
398 Kutch
436 Modinagar
470 Navi mumbai
494 Palampur
516 Pauri
526 Proddatur
533 Raebareli
582 Sangrur
599 Sibmandir
664 Tiruvallur
727 bhopal
768 ludhiana
777 new delhi
781 pune
9 Abu Road
108 Bhuj
182 Derabassi
207 East Sikkim
209 East godavari
215 Etah
216 Etawah
227 Firozpur
301 Jaisalmer
306 Jalna
479 Nilgiris
492 Palakollu
621 Spet
738 delhi
788 tezpur
26 Aluva
75 Baramati
92 Berhampur
95 Bhandara
143 Chengalpet
165 Dadra and Nagar Haveli
193 Dindigul
221 Faridkot
234 Gadag
246 Godhra
251 Gondia
279 Himmatnagar
313 Jetpur
364 Khandur
376 Kollam
434 Miraj
443 Mughal Sarai
448 Muzaffarnagar
496 Pali
528 Puri
556 Rewari
562 Ropar
574 Sahibganj
639 Tehri Garhwal
693 Vaishali
11 Adur
51 Azamgarh
111 Bijnor
113 Bilaspur (Hp)
121 Budaun
250 Gondal
273 Hardoi
347 Karaikal
366 Kharagpur
373 Kolar
378 Koraput
415 Mahesana
430 Mayurbhanj
437 Moga
442 Morena
464 Namakkal
465 Nanded
493 Palamau
552 Ratlam
578 Samastipur
590 Sere
632 Surendra Nagar
636 Tamluk
653 Thrissur
668 Trichur
669 Tripunithura
688 Usur
747 gurgaon
786 srinagar
5 AHMEDABAD
33 Amreli
41 Anekal
52 B R D Medical College
74 Barabanki
85 Basti
88 Beed
96 Bharatpur
114 Billimora
152 Chittorgarh
185 Dhar
224 Fatehgarh Sahib
252 Gopalganj
258 Greater noida
259 Gudivada
302 Jajapur
346 Karad
385 Kottayam
391 Krishnagiri
392 Kullu
414 Mahboobnagar
422 Manipal
446 Munger
480 Nizamabad
489 PATNA
583 Saran
588 Seoni
591 Shahjahanpur
598 Shimoga
708 Vizianagaram
716 Yavatmal
769 mangalore
65 Balangir
82 Baroda
134 Chakradharpur
136 Champa
189 Dhenkanal
211 Eluru
226 Firozabad
242 Ghatkesar
320 Jharsuguda
329 Kachchh
350 Karim nagar
353 Karunagappally
412 Madikeri
423 Manjeri
427 Margherita
447 Murshidabad
455 Nadia
458 Nagaur
463 Nalgonda
466 Nandurbar
490 PUNE
580 Sangamner
622 Srikakulam
638 Tanuku
663 Tiruvalla
678 Udhampur
683 Umargam
685 Unjha
704 Villupuram
746 greater noida
776 navsari
1 Cuttack
3 400005
4 AGRA
6 AHMEDNAGAR
7 ANKLESHWAR
28 Amalapuram
30 Ambernath East
39 Andhra pradesh
50 Aurangabad (BR)
58 BULANDSHAHR
61 Bagdogra
67 Baleswar
118 Bolpur
125 Bundi
135 Chamarajanagar
164 Dad
181 Deoria
195 Dombivli
200 EAST KHASI HILLS
217 FARIDABAD
244 Ghazipur
245 Godavarikhani
248 Golconda
257 Greater Noida
280 Hisar
291 JABALPUR
298 Jagdishpur
304 Jalaun
307 Jalor
336 Kalyan
363 Khammam
372 Koderma
390 Krishnagar
401 Lakhimpur Kheri
408 MANGALORE
419 Mandsaur
441 Morbi
472 Neemuch
477 New Delhi
491 Palakkad
495 Palghar
507 Paradeep
517 Pauri Garhwal
518 Perumbavoor
530 Puttur
543 Ramanathapuram
606 Sirmaur
608 Sitamarhi
624 Sriperumbudur
642 Thalassery
650 Thirssur
665 Tonk
666 Tothukudi
677 Udham singh nagar
680 Ujhani
682 Ulhasnagar
686 Unnao
687 Uran
695 Vapi
702 Vidisha
717 Zirakhpur
724 bathinda
728 bohr saidan
729 bolpur
735 curchorem
743 ghaziabad
752 hubli
754 jaipur
759 jodhpur
767 lucknow
774 nagpur
778 panchkula
779 panvel
780 ponda
2 110058
10 Adilabad
22 Alappuzha
24 Alipurduar
35 Amritsar
42 Angamally
53 BAHADURGARH
57 BHOPAL
59 Badgam
68 Ballia
70 Banda
83 Barratpur
100 Bhawanipatna
106 Bhopal
124 Buldhana
127 Burhanpur
131 Calicut
141 Chas
153 Chowk bazaar
158 Cooch behar
192 Digboi
197 Dungarpur
201 ERNAKULAM
206 East Midnapore
222 Farukhabad
231 GREATER NOIDA
283 Hoshiarpur
292 JAIPUR
300 Jaipuripur
328 KURNOOL
330 Kadapa
332 Kaithal
334 Kakinada East Godavari
335 Kalavad
356 Kasaragod
358 Kathua
365 Khanna
369 Khurda
371 Kodaikanal
377 Koppal
382 Kothamanglam
384 Kottarakkara
386 Kozhencherry
394 Kupwara
396 Kurukshetra
403 Latur
409 Machilipatnam
416 Malappuram
424 Manmad
426 Margao
428 Marigaon
484 North 24 parganas
498 Panch mahals
501 Pandharpur
503 Panji
504 Panjim
508 Parasvanath greenville, Gurgaon
510 Patancheru
511 Pathanamthitta
519 Pilibhit
525 Prakasam
531 Quilon
539 Rajendranagar
542 Rajsamand
545 Ramnagar
548 Rampur Bushahr
550 Ranebennur
558 Robertsganj
589 SeraikelaKharsawan
610 Sivakasi
635 THANE
647 Thane West
651 Thiruvalla
670 Trivandrum
673 Tuticorin
684 Una
689 VAPI
700 Vashi
706 Virudhunagar
718 agra
720 ajmer
722 aurangabad
725 bellary
726 bhandara
740 dombivli
750 hooghly
761 khorda
772 mohali
775 navi mumbai
787 surat
789 vapi
791 wipro technologies, plot no. 2,3 and 4, gautam budha nagar, greater noida
14 Agra
20 Akalgarh
31 Ambikapur
36 Amroha
45 Anpara Tps
47 Attiana
54 BALESWAR
55 BARASAT
56 BHARUCH
62 Baghpat
64 Baidyabati
69 Banaskantha
73 Bapatla
76 Baramulla
98 Bhatinda
115 Binnaguri
128 CHENNAI
129 COIMBATORE
130 CURCHOREM
133 Chakdaha
140 Changanassery
142 Chavakkad
146 Chhattisgarh
147 Chhindwara
149 Chitradurga
150 Chittausa
154 Churu
163 DHANBAD
166 Dadra and nagar haveli
170 Daltonganj
175 Daund
179 DelhiI
180 Deoghar
196 Duliajan
202 ETAH
203 ETT tower 2,B-36 sector -132
210 East singhbhum
214 Eru Bo
218 FIROZPUR
223 Fatehabad
225 Fatehgarh sahib
228 GANDHIDHAM
229 GANJAM
232 GULBARGA
240 Gautam budh nagar
254 Gorakhpur
255 Goraya
256 Greater Faridabad
264 Gurgaon , On NH 8
265 Guruvayur
268 HARIDWAR
269 HOOGHLY
276 Hathras
277 Haveri
287 ILKAl
288 Igatpuri
290 Itanagar
293 JALGAON
294 JAMMU
295 JHALAWAR
308 Jalpaiguri
315 Jhabua
316 Jhalara Patan
317 Jhalawar
319 Jharsaguda
326 KAITHAL
327 KHARAGPUR
331 Kaduthuruthy
348 Karaikudi
351 Karkala
361 Kendujhar
362 Keshod
381 Kotdwara
383 Kothgudem
393 Kuloor
397 Kushalnagar
399 LUCKNOW
400 Lakhimpur
402 Lanjigarh
404 Lonavala
407 MADURAI
410 Madanganj kishangarh
411 Madathikkara Lane
425 Mapusa
433 Mhow
439 Moinabad
445 Mundra
452 N.C. Kundu road
453 NAVI MUMBAI
456 Nadiad
457 Nagapattinam
468 Nathdwara
475 Nellorelore
481 Noamundi
499 Panchgani
505 Panna
515 Pauri
524 Porvorim
544 Ramgarh Cantt
546 Ramnagar District
554 Rawatbhata
564 SANGRUR
565 SATNA
566 SHILLONG
567 SILIGURI
568 SOLAN
569 SOUTH GOA
570 SURAT
571 Sabarkantha
576 Saligo
577 Salugara
586 Sawai Madhopur
592 Shangabad
593 Shantiniketan
595 Shikohabad
603 Siliguri
604 Silvassa
619 South chennai
620 South goa
625 Sukna
628 Sur
629 Surajpur
631 Suratgarh
633 Surendra nagar
634 Suryapet
637 Tanda
640 Tenali
644 Thane
645 Thane (Rural)
646 Thane East
654 Tikamgarh
655 Tikiapara Police Phari
656 Tilaknagar Latur
661 Tirupur
662 Tirur
667 Trichirapalli
672 Turkayamzal
674 UDAIPUR
690 VELLORE
691 VIZIANAGARAM
697 Varanasi
699 Vasco da Gama
705 Virar
710 Warangal
721 amritsar
723 barrackpore
730 burdwan
731 ch
733 chiplun
734 coimbatore
736 cuttack
737 dehradun
739 digboi
741 farrukhabad
742 fatehgarh sahib
744 gidderbaha
745 greater Noida
748 hanumangarh
749 hapur
751 hosur
753 infosys limited, infocity patia
755 jalandhar
756 jamshedpur
757 jhansi
758 jharsuguda
760 kalyan
762 khurja
763 kolhapur
764 kollam
765 kota
766 kurukshetra
770 mapusa
771 mathura
773 mumbai
782 rajkot
783 shillong
784 solan
785 south goa
salesData.df$OrderID
71 4904
476 4585
444 3845
527 2557
263 2004
286 1999
375 1839
482 1142
144 1020
643 921
243 737
478 683
15 545
299 531
405 518
630 461
138 425
388 421
220 401
266 401
623 341
459 338
289 314
177 295
309 259
596 257
549 237
692 235
34 219
707 219
406 218
514 216
485 212
618 212
303 209
451 206
119 203
339 173
25 170
107 167
438 160
161 157
311 157
323 152
537 152
432 149
587 149
338 148
296 144
675 140
469 138
597 135
513 130
156 129
267 125
18 122
467 121
500 119
13 116
212 115
506 113
696 113
341 108
652 97
602 94
540 90
79 86
105 85
191 79
29 75
235 75
694 71
421 70
701 70
380 67
536 67
679 66
440 64
49 61
90 61
368 61
178 60
497 57
253 55
713 55
168 54
342 54
579 54
12 53
198 52
281 51
184 50
352 50
23 47
374 47
19 46
617 46
84 45
318 45
535 45
559 45
600 45
615 45
27 44
78 44
122 43
538 43
560 43
86 42
94 42
176 42
395 42
188 41
584 41
657 41
174 40
714 40
16 39
97 38
112 38
429 38
32 37
260 37
345 37
601 37
413 36
521 35
648 35
709 35
611 34
37 33
155 33
262 33
555 33
572 33
613 33
139 32
284 32
627 32
681 32
715 32
43 31
110 31
219 31
238 31
239 31
340 31
703 31
502 30
641 30
99 29
162 29
236 29
379 29
272 28
310 28
658 28
676 28
103 27
117 27
449 27
474 27
573 27
607 27
91 26
274 26
387 26
471 26
575 26
325 25
21 24
66 24
333 24
486 24
529 24
612 24
790 24
167 23
208 23
671 23
237 22
337 22
344 22
389 22
487 22
148 21
278 21
512 21
520 21
563 21
581 21
101 20
171 20
173 20
360 20
460 20
483 20
557 20
659 20
102 19
157 19
271 19
282 19
324 19
80 18
87 18
305 18
418 18
532 18
534 18
616 18
93 17
104 17
109 17
145 17
159 17
355 17
359 17
614 17
660 17
123 16
417 16
435 16
594 16
711 16
8 15
17 15
38 15
44 15
151 15
213 15
367 15
450 15
473 15
523 15
585 15
626 15
698 15
77 14
89 14
120 14
137 14
186 14
261 14
314 14
321 14
551 14
605 14
60 13
72 13
205 13
249 13
322 13
343 13
349 13
420 13
462 13
541 13
547 13
553 13
561 13
609 13
649 13
712 13
732 13
40 12
160 12
204 12
230 12
233 12
312 12
63 11
183 11
187 11
199 11
241 11
247 11
275 11
285 11
297 11
357 11
461 11
488 11
46 10
48 10
116 10
132 10
172 10
270 10
431 10
454 10
509 10
522 10
719 10
81 9
126 9
169 9
190 9
194 9
354 9
370 9
398 9
436 9
470 9
494 9
516 9
526 9
533 9
582 9
599 9
664 9
727 9
768 9
777 9
781 9
9 8
108 8
182 8
207 8
209 8
215 8
216 8
227 8
301 8
306 8
479 8
492 8
621 8
738 8
788 8
26 7
75 7
92 7
95 7
143 7
165 7
193 7
221 7
234 7
246 7
251 7
279 7
313 7
364 7
376 7
434 7
443 7
448 7
496 7
528 7
556 7
562 7
574 7
639 7
693 7
11 6
51 6
111 6
113 6
121 6
250 6
273 6
347 6
366 6
373 6
378 6
415 6
430 6
437 6
442 6
464 6
465 6
493 6
552 6
578 6
590 6
632 6
636 6
653 6
668 6
669 6
688 6
747 6
786 6
5 5
33 5
41 5
52 5
74 5
85 5
88 5
96 5
114 5
152 5
185 5
224 5
252 5
258 5
259 5
302 5
346 5
385 5
391 5
392 5
414 5
422 5
446 5
480 5
489 5
583 5
588 5
591 5
598 5
708 5
716 5
769 5
65 4
82 4
134 4
136 4
189 4
211 4
226 4
242 4
320 4
329 4
350 4
353 4
412 4
423 4
427 4
447 4
455 4
458 4
463 4
466 4
490 4
580 4
622 4
638 4
663 4
678 4
683 4
685 4
704 4
746 4
776 4
1 3
3 3
4 3
6 3
7 3
28 3
30 3
39 3
50 3
58 3
61 3
67 3
118 3
125 3
135 3
164 3
181 3
195 3
200 3
217 3
244 3
245 3
248 3
257 3
280 3
291 3
298 3
304 3
307 3
336 3
363 3
372 3
390 3
401 3
408 3
419 3
441 3
472 3
477 3
491 3
495 3
507 3
517 3
518 3
530 3
543 3
606 3
608 3
624 3
642 3
650 3
665 3
666 3
677 3
680 3
682 3
686 3
687 3
695 3
702 3
717 3
724 3
728 3
729 3
735 3
743 3
752 3
754 3
759 3
767 3
774 3
778 3
779 3
780 3
2 2
10 2
22 2
24 2
35 2
42 2
53 2
57 2
59 2
68 2
70 2
83 2
100 2
106 2
124 2
127 2
131 2
141 2
153 2
158 2
192 2
197 2
201 2
206 2
222 2
231 2
283 2
292 2
300 2
328 2
330 2
332 2
334 2
335 2
356 2
358 2
365 2
369 2
371 2
377 2
382 2
384 2
386 2
394 2
396 2
403 2
409 2
416 2
424 2
426 2
428 2
484 2
498 2
501 2
503 2
504 2
508 2
510 2
511 2
519 2
525 2
531 2
539 2
542 2
545 2
548 2
550 2
558 2
589 2
610 2
635 2
647 2
651 2
670 2
673 2
684 2
689 2
700 2
706 2
718 2
720 2
722 2
725 2
726 2
740 2
750 2
761 2
772 2
775 2
787 2
789 2
791 2
14 1
20 1
31 1
36 1
45 1
47 1
54 1
55 1
56 1
62 1
64 1
69 1
73 1
76 1
98 1
115 1
128 1
129 1
130 1
133 1
140 1
142 1
146 1
147 1
149 1
150 1
154 1
163 1
166 1
170 1
175 1
179 1
180 1
196 1
202 1
203 1
210 1
214 1
218 1
223 1
225 1
228 1
229 1
232 1
240 1
254 1
255 1
256 1
264 1
265 1
268 1
269 1
276 1
277 1
287 1
288 1
290 1
293 1
294 1
295 1
308 1
315 1
316 1
317 1
319 1
326 1
327 1
331 1
348 1
351 1
361 1
362 1
381 1
383 1
393 1
397 1
399 1
400 1
402 1
404 1
407 1
410 1
411 1
425 1
433 1
439 1
445 1
452 1
453 1
456 1
457 1
468 1
475 1
481 1
499 1
505 1
515 1
524 1
544 1
546 1
554 1
564 1
565 1
566 1
567 1
568 1
569 1
570 1
571 1
576 1
577 1
586 1
592 1
593 1
595 1
603 1
604 1
619 1
620 1
625 1
628 1
629 1
631 1
633 1
634 1
637 1
640 1
644 1
645 1
646 1
654 1
655 1
656 1
661 1
662 1
667 1
672 1
674 1
690 1
691 1
697 1
699 1
705 1
710 1
721 1
723 1
730 1
731 1
733 1
734 1
736 1
737 1
739 1
741 1
742 1
744 1
745 1
748 1
749 1
751 1
753 1
755 1
756 1
757 1
758 1
760 1
762 1
763 1
764 1
765 1
766 1
770 1
771 1
773 1
782 1
783 1
784 1
785 1
Billings to cities
x <- aggregate ( salesData.df$OrderID ~ salesData.df$BillingCity, salesData.df, length)
x[order(x$`salesData.df$OrderID`, decreasing = TRUE),]
salesData.df$BillingCity
80 Bangalore
543 New Delhi
505 Mumbai
595 Pune
334 Hyderabad
305 Gurgaon
431 Kolkata
549 Noida
172 Chennai
724 Thane
281 Ghaziabad
545 New delhi
463 Lucknow
347 Jaipur
14 Ahmedabad
711 Surat
308 Guwahati
446 Krda
163 Chandigarh
256 Faridabad
524 Nagpur
340 Indore
705 Srinagar
210 Dehradun
357 Jammu
676 Shillong
580 Patna
775 Vadodara
623 Ranchi
515 Mysore
34 Amritsar
464 Ludhiana
700 South Goa
350 Jalandhar
793 Visakhapatnam
142 Bpal
24 Allahabad
499 Mohali
371 Jodhpur
189 Cuttack
388 Kanchipuram
553 North Goa
493 Meerut
359 Jamshedpur
387 Kamrup
613 Raipur
344 Jabalpur
668 Secunderabad
536 Navi Mumbai
678 Shimla
758 Udaipur
309 Gwalior
183 Coimbatore
533 Nashik
12 Agra
569 Panchkula
579 Patiala
393 Kanpur Dehat
17 Aizawl
249 Ernakulam
574 Panvel
781 Varanasi
125 Bhopal
734 Thiruvananthapuram
127 Bhubaneshwar
616 Rajkot
128 Bhubaneswar
684 Siliguri
28 Ambala
211 Delhi
778 Valsad
438 Kota
786 Vellore
227 Dibrugarh
501 Moradabad
480 Mangalore
51 Aurangabad
423 Khorda
635 Roorkee
566 Panaji
762 Udupi
109 Belgaum
236 Durg
96 Barelly
294 Gorakhpur
405 Karnal
11 Agartala
328 Hissar
657 Sambalpur
200 Dakshina Kannada
207 Darjiling
23 Aligarh
271 Gandhi Nagar
366 Jhansi
634 Rohtak
697 Sonipat
19 Ajmer
105 Bathinda
145 Budgam
682 Sikar
26 Alwar
92 Bardhaman
103 Bastar
209 Davangare
218 Dhanbad
471 Madurai
608 Raigarh
117 Bharuch
430 Kolhapur
224 Dharward
609 Raigarh (Mh)
454 Kurnool
555 North goa
114 Bhagalpur
795 Warangal
32 Amravati
133 Bikaner
398 Kapurthala
665 Satara
489 Mathura
614 Rajahmundry
980 wrah
182 Cochin
391 Kanpur
15 Ahmedabad
683 Silchar
740 Tinsukia
301 Gulbarga
695 Solapur
710 Sundergarh
788 Vijayawada
35 Anand
588 Pondicherry
699 South Chennai
652 Sagar
166 Chandrapur
276 Ganjam
630 Rewa
693 Sivasagar
729 Thanesar
358 Jamnagar
541 Nellore
437 Korba
571 Panipat
655 Salem
110 Bellary
118 Bhavnagar
303 Guntur
331 Howrah
381 Kakinada
389 Kangra
538 Navsari
653 Saharanpur
801 West Midnapore
123 Bhiwandi
131 Bijapur
318 Haridwar
513 Muzaffarpur
689 Sirsa
723 Tezpur
741 Tiruchirappalli
73 Balasore
130 Bidar
277 Gautam Budh Nagar
373 Junagadh
822 bangalore
94 Bareily
139 Bokaro
244 East Singhbhum
273 Gandhidham
329 Hooghly
21 Akola
255 Faizabad
445 Kozhikode
765 Ujjain
274 Gandhinagar
275 Ganganagar
397 Kanyakumari
759 Udham Singh Nagar
313 Haldwani
600 Purnia
661 Sangli
203 Daman
323 Hazaribagh
372 Jorhat
385 Kalyanpur
800 West Mednipur
807 Yamuna Nagar
970 varanasi
162 Chandauli
165 Chandigharh
241 East Khasi Hills
447 Krishna
551 North 24 Parganas
694 Solan
122 Bhilwara
395 Kanpur dehat
554 North Lakhimpur
587 Ponda
632 Rishikesh
755 Tumkur
840 chennai
36 Ananthapur
138 Birbhum
177 Chikmagalur
184 Cooch Behar
199 Dadri
352 Jalgaon
414 Katni
607 Raichur
638 Rourkela
743 Tirupati
42 Angul
106 Beawar
225 Dhenkanal
250 Erode
476 Malda
477 Mandi
797 Wardha
834 bhubaneswar
913 mumbai
918 new delhi
922 oghly
113 Bhadrak
146 Bulandshahr
174 Chhatarpur
187 Cuddalore
201 Dakshina kannada
525 Nainital
578 Pathankot
617 Rajpura
627 Ratnagiri
691 Sitapur
709 Sultanpur
91 Barbil
97 Baripada
124 Bhiwani
178 Chittoor
272 Gandhi nagar
315 Hamirpur
345 Jagdalpur
402 Karim Nagar
413 Katihar
422 Kheda
496 Mirzapur
497 Modinagar
514 Mw
742 Tirunelveli
205 Darbhanga
222 Dharamshala
240 East Godavari
527 Nalanda
540 Nehru Road
590 Port Blair
611 Raigarh(mh)
792 Visakapatanam
811 ahmedabad
946 shiarpur
16 Ahmednagar
43 Ankleshwar
108 Begusarai
120 Bhilai
143 Brahmapur
188 Cuddapah
302 Guna
362 Jeypore
369 Jhujhunu
481 Manipal
518 NEW DELHI
621 Rampur
636 Ropar
666 Satna
696 Sonbhadra
876 hyderabad
934 pune
39 Andlu
243 East Sikkim
279 Gaya
290 Gonda
360 Jaunpur
370 Jind
563 Palampur
662 Sangrur
784 Vasai
809 Yavatmal
48 Asansol
58 BANGALORE
86 Banswara
93 Bareilly
217 Dewas
252 Etah
314 Hamirpur
319 Hassan
411 Kashipur
557 Ooty
561 Palakollu
606 Raebareli
833 bhopal
959 srinagar
46 Anugul
50 Auraiya
70 Bahadurgarh
82 Bangalore South
111 Berhampur
288 Golaghat
312 Haldia
332 Hubli
408 Karwar
436 Koraput
625 Ranipool
680 Sibmandir
730 Thanjavur
747 Tiruvallur
849 delhi
864 gurgaon
25 Aluva
158 Chaibasa
204 Damoh
223 Dharmapuri
226 Dhule
230 Dindori
237 Durgapur
253 Etawah
376 KOLKATA
467 MUMBAI
479 Mandya
531 Nanded
589 Porbandar
594 Proddatur
605 ROORKEE
698 Sonitpur
921 north goa
7 Abohar
8 Abu Road
98 Barmer
129 Bhuj
149 Burdwan
262 Firozabad
263 Firozpur
298 Greater Noida
353 Jalna
407 Karur
457 Kutch
474 Mahesana
490 Mayurbhanj
491 Medak
526 Nalagarh
565 Pali
567 Panch mahals
576 Pardi
631 Rewari
686 Singrauli
799 West Godavari
859 ghaziabad
963 tezpur
10 Adur
89 Baramati
115 Bhandara
135 Bilaspur (Hp)
197 Dadra and Nagar Haveli
260 Fatehgarh Sahib
270 Gadag
292 Gondia
348 Jaisalmer
394 Kanpur Nagar
434 Kollam
443 Kottayam
495 Miraj
530 Namakkal
537 Navi mumbai
559 PUNE
598 Puri
626 Ratlam
637 Ropar
654 Sahibganj
656 Samastipur
663 Saran
777 Vaishali
808 Yamuna nagar
883 jamshedpur
904 lucknow
905 ludhiana
915 navi mumbai
917 navsari
33 Amreli
53 Azamgarh
67 Bagalkot
116 Bharatpur
132 Bijnor
144 Budaun
191 DELHI
245 East godavari
291 Gondal
325 Himatnagar
361 Jetpur
392 Kanpur
400 Karaikal
429 Kolar
459 Lakhimpur
498 Moga
503 Morena
504 Mughal Sarai
512 Muzaffarnagar
546 Nilgiris
562 Palamau
581 Pauri
592 Prakasam
639 Rudrapur
650 SURAT
669 Seoni
672 Sere
673 Shahjahanpur
712 Surendra Nagar
718 Tamluk
752 Trichur
753 Tripunithura
794 Vizianagaram
803 West godavari
865 guwahati
879 jaipur
893 kishangarh
964 thane
2 AHMEDABAD
40 Anekal
56 BAGALKOT
88 Barabanki
104 Basti
107 Beed
179 Chittorgarh
257 Faridkot
300 Gudivada
349 Jajapur
399 Karad
418 Khandur
420 Kharagpur
484 Mapusa
510 Munger
511 Murshidabad
529 Nalgonda
539 Neemuch
547 Nizamabad
615 Rajamundhry
679 Shimoga
736 Thrissur
746 Tiruvalla
754 Trivandrum
789 Villupuram
858 gauhati
882 jammu
887 karwar
896 kolkata
947 shillong
958 spet
968 usur
18 Aizwal
27 Amalapuram
54 B R D Medical College
72 Balangir
74 Baleswar
134 Bilaspur
136 Billimora
152 CHANDIGARH
160 Chakradharpur
161 Champa
170 Chengalpet
186 Cudalore
216 Derabassi
229 Dindigul
231 Dombivili-east
248 Eluru
265 GHAZIABAD
268 GURGAON
280 Ghatkesar
283 Ghumarwin
293 Gopalganj
299 Greater noida
311 HYDERABAD
317 Hardoi
342 JAIPUR
368 Jharsuguda
377 Kachchh
380 Kaithal
384 Kalyan
390 Kannur
396 Kanpur nagar
403 Karim nagar
406 Karunagappally
417 Khammam
419 Khanna
449 Krishnagiri
450 Kullu
472 Mahboobnagar
475 Malappuram
482 Manjeri
483 Manmad
485 Margao
486 Margherita
523 Nagaur
532 Nandurbar
582 Pauri Garhwal
612 RaigarhMh
628 Raurkela Industrial Township
681 Sibsagar
704 Srikakulam
720 Tanuku
731 Thirssur
756 Tuticorin
830 bhadravathi
862 greater noida
872 howrah
877 india
885 jodhpur
888 kc road Mangalore
931 pondicherry
944 secunderabad
952 solan
3 AHMEDNAGAR
5 ANKLESHWAR
31 Ambernath(e)
38 Andhra pradesh
52 Aurangabad (Bh)
63 BHUBANESWAR
65 BULANDSHAHR
77 Banaskantha
83 Bangalore south
168 Chas
196 Dad
213 Delhidelhi
215 Deoria
221 Dhar MP
266 GREATER NOIDA
286 Godavarikhani
289 Golconda
321 Haveri
327 Hisar
333 Hyd-begumpet
341 JABALPUR
346 Jagdishpur
351 Jalaun
354 Jalor
427 Koderma
428 Kohima
448 Krishnagar
453 Kupwara
460 Lakhimpur Kheri
462 Lohardaga
466 MANGALORE
468 Machilipatnam
470 Madikeri
478 Mandsaur
506 Mumbai 400091
521 Nadia
534 Nasik
560 Palakkad
575 Paradeep
584 Perumbavoor
593 Pratapgarh
599 Purnea
619 Ramanathapuram
660 Sangamner
664 Sasaram
677 Shillong
687 Sirmaur
688 Sirohi
690 Sitamarhi
707 Sriperumbudur
721 Tehri Garhwal
725 Thane
751 Tothukudi
760 Udham singh nagar
761 Udhampur
769 Unjha
770 Unnao
776 Vadodara
787 Vidisha
791 Virudhunagar
798 West Garo Hills
805 West midnapore
823 banglore
836 bohr saidan
839 chandigarh
842 chitraduraga
845 curchorem
878 jagraon
899 kumarhatti
909 mangalore
914 nagpur
920 noida
925 panchkula
926 panvel
929 patna
930 ponda
937 rajhamundry
942 rudrapur
961 surat
9 Adilabad
37 Anantnag
57 BAHADURGARH
64 BILASPUR
66 Badgam
68 Bagdogra
75 Ballia
81 Bangalore
85 Banglore
95 Barelliy
100 Baroda
102 Barratpur
126 Bhopal
140 Bokaro steel city
147 Buldhana
148 Bundi
150 Burhanpur
153 CHENNAI
157 Calicut
185 Cooch behar
220 Dhar
228 Digboi
232 Dombivli
233 Duliajan
235 Dungarpur
238 ERNAKULAM
242 East Midnapore
259 Fatehabad
282 Ghazipur
316 Hamirpur(hp)
322 Hazaribag
339 Imphal East
365 Jhalawar
378 Kadapa
382 Kalahandi
383 Kalavad
412 Kathua
424 Khushkhera
425 Kishangarh
426 Kodaikanal
435 Koppal
440 Kothamanglam
442 Kottarakkara
444 Kozhencherry
487 Marigaon
494 Mhow
502 Morbi
517 NEEMUCH
522 Nagapattinam
552 North 24 parganas
558 PATNA
564 Palghar
570 Pandharpur
583 Pauri garhwal
586 Pilibhit
596 Pune.
601 Puttur
602 Quilon
610 Raigarh Mh
618 Rajsamand
620 Ramnagar
622 Rampur Bushahr
624 Ranebennur
633 Robertsganj
641 SANGRUR
648 SOUTH-GOA
658 Sambhal
659 Samstipur
671 SeraikelaKharsawan
703 Spet
722 Tehri garhwal
727 Thane West
733 Thiruvalla
750 Tonk
757 UNA (HIMACHAL PRADESH)
764 Ujhani(badaun)
768 Una
773 VAPI
804 West mednipur
810 agra
813 ajmer
814 alipurduar
816 alwar
820 aurangabad
829 bellary
831 bhandara
832 bhilai
843 chittoor
844 coimbatore
850 dhanbad
852 didihat
869 hooghly
873 howrah mandirtala
874 hubli
886 kalyan
890 khorda
902 latur
908 mandya
928 patiala
936 rajendranagar
940 rewari
941 ropar
949 silchar
955 sonebhadra
966 udaipur
969 vapi
972 vashi
977 vizag
979 wipro technologies, plot no. 2,3 and 4, gautam budha nagar, greater noida
1 190008
4 AIZAWL
6 Abbowal
13 Agra
20 Akalgarh
22 Alappuzha
29 Ambala Cantt
30 Ambalapuzha
41 Angamally
44 Anpara
45 Anpara Tps
47 Ara
49 Attiana
55 B r d medical college
59 BATHINDA
60 BBSR
61 BERHAMPUR
62 BHILAI
69 Baghpat
71 Baidyabati
76 Balurghat
78 Banda
79 Bangalor
84 Bangalorebangalore
87 Bapatla
90 Baramulla
99 Baroadhaman
101 Baroda, Gujarat
112 Betul
119 Bhawanipatna
121 Bhillai
137 Binnaguri
141 Bongaingaon
151 Buxar
154 CHINSURAH
155 COIMBATORE
156 CURCHOREM
159 Chakdaha
164 Chandigarh
167 Changanacherry
169 Chavakkad
171 Chenna
173 Chennaiai
175 Chhattisgarh
176 Chhindwara
180 Chowk bazaar
181 Churu
190 DEHRADUN
192 DHANBAD
193 DIBRUGARH
194 DULIAJAN
195 DURG
198 Dadra and nagar haveli
202 Daltonganj
206 Darjeeling
208 Daund
212 Delhi/NCR
214 Deoghar
219 Dhar
234 Dumka
239 ETT tower 2,B-36 sector -132
246 East sikkim
247 East singhbhum
251 Eru Bo
254 FARIDABAD
258 Farrukhabad
261 Fatehgarh sahib
264 GANDHIDHAM
267 GUNTUR
269 GUWAHATI
278 Gautam budh nagar
284 Ghy
285 Goa
287 Godhra
295 Gorakhpur
296 Goraya
297 Greater Faridabad
304 Gurdaspur
306 Gurgaon , On NH 8
307 Guruvayur
310 HARIDWAR
320 Hathras
324 Hiighly
326 Himmatnagar
330 Hoshiarpur
335 ILKAl
336 INDORE
337 Igatpuri
338 Imphal
343 JAMMU
355 Jalpaiguri
356 Jamalpur
363 Jhabua
364 Jhalara Patan
367 Jharsaguda
374 KANPUR
375 KHARAGPUR
379 Kaduthuruthy
386 Kamareddy
401 Karaikudi
404 Karkala
409 Kasaragod
410 Kasargod
415 Kerala
416 Keshod
421 Khatiar
432 Kolkatal
433 Kolkatta
439 Kotdwara
441 Kothgudem
451 Kundapur
452 Kunnamangalam
455 Kurukshetra
456 Kushalnagar
458 Lajpat Nagar IV
461 Lanjigarh
465 MADURAI
469 Madathikkara Lane
473 Mahbubnagar
488 Marthandam
492 Medinipur
500 Moinabad
507 Mumbaimbai
508 Mumbaiumbai
509 Mundra
516 NAVI MUMBAI
519 NEW DELHI
520 NOIDA
528 Nalbari
535 Nausar
542 Nellorelore
544 New Delhi
548 NlRMAL
550 Noida 62
556 Oghly
568 Panchgani
572 Panjim
573 Panna
577 Patan
585 Phagwara
591 Porvorim
597 Punee
603 RAMPUR ,SHIMLA
604 RAWATBHATA
629 Rawatbhata
640 SALIGAO
642 SHILLONG
643 SILIGURI
644 SINGRAULI
645 SIRSA
646 SOLAN
647 SOLAPUR
649 SURAJPUR
651 Sabarkantha
667 Sawai madhopur
670 Seraikela-kharsawan
674 Shambhu
675 Shiarpur
685 Siliguri
692 Sivakasi
701 South chennai
702 South goa
706 Srinagar bemina
708 Sukna
713 Surendra nagar
714 Suryapet
715 THANE
716 TONK
717 Tadipatri
719 Tanda
726 Thane (Rural)
728 Thane east
732 Thiruchirapalli
735 Thiruvantapuram
737 Tikamgarh
738 Tikiapara police phari
739 Tilaknagar Latur
744 Tirupur
745 Tirur
748 Tiruvannamalai
749 Tiruvarur
763 Ujhani
766 Ulhasnagar
767 Umargam
771 Uran
772 VADODARA
774 VARANASI
779 Vapi
780 Var
782 Varanasi
783 Varkala
785 Vasco da Gama
790 Virar
796 Warangal
802 West bengal
806 Wrah
812 aizawl
815 allahabad
817 ambala
818 ambikapur
819 amritsar
821 bagdogra
824 baroda
825 barrackpore
826 beejpur
827 begusarai
828 bellandur Bangalore
835 bhubaneswar
837 bokaro steel city
838 burdwan
841 chhatarpur
846 daman
847 damoh
848 dehradun
851 dharmanagar
853 dombivli
854 faridabad
855 faridkot
856 farrukhabad
857 fatehgarh sahib
860 gidderbaha
861 greater Noida
863 guna
866 gzb
867 hanumangarh
868 hapur
870 hospet
871 hosur
875 hyd
880 jalandhar
881 jalandhar city
884 jhansi
889 khanpur
891 khurja
892 kishanganj
894 kolar
895 kolhapur
897 kollam
898 kota
900 kurukshetra
901 lLucknow
903 lonavla (Mh)
906 madanganj kishangarh
907 malviya nagar
910 manipal
911 mohali
912 morvi
916 navimumbai
919 noamundi
923 palghar
924 panchgani
927 patia
932 porbandar
933 porvorim,
935 puttur
938 rajkot
939 ramnagar district
943 sagar
945 shangabad
948 shimoga
950 sivakasi
951 sivasagar
953 solapur
954 somnath dwar infantry line jamnagar
956 south Goa
957 south goa
960 sur
962 tenali
965 trivandrum
967 uran navi mumbai
971 varodra
973 vellore
974 visakhapatnam
975 vishakapatnam
976 vishakhapatnam
978 wankaner
981 yamunanagar
982 zaheerabad
983 zirakpur
salesData.df$OrderID
80 4829
543 4707
505 3867
595 2513
334 1983
305 1927
431 1808
549 1130
172 1011
724 888
281 711
545 662
463 523
347 515
14 513
711 450
308 405
446 393
163 390
256 389
524 338
340 327
705 325
210 277
357 255
676 241
580 231
775 223
623 221
515 217
34 216
464 213
700 207
350 205
793 198
142 191
24 177
499 165
371 164
189 162
388 161
553 159
493 158
359 154
387 143
613 143
344 139
668 137
536 136
678 136
758 131
309 130
183 123
533 122
12 118
569 118
579 117
393 112
17 110
249 110
574 107
781 106
125 102
734 101
127 91
616 89
128 84
684 83
28 75
211 75
778 75
438 74
786 74
227 69
501 64
480 63
51 62
423 62
635 62
566 59
762 58
109 56
236 55
96 52
294 52
405 52
11 51
328 51
657 51
200 50
207 50
23 49
271 49
366 49
634 49
697 49
19 48
105 48
145 47
682 45
26 44
92 44
103 44
209 44
218 44
471 44
608 44
117 43
430 43
224 42
609 42
454 41
555 41
114 40
795 40
32 39
133 39
398 39
665 39
489 38
614 38
980 38
182 37
391 37
15 36
683 36
740 36
301 35
695 35
710 35
788 35
35 34
588 34
699 34
652 33
166 32
276 32
630 32
693 32
729 32
358 31
541 31
437 30
571 30
655 29
110 28
118 28
303 28
331 28
381 28
389 28
538 28
653 28
801 28
123 27
131 27
318 27
513 27
689 27
723 27
741 27
73 26
130 26
277 26
373 26
822 26
94 25
139 25
244 25
273 25
329 25
21 24
255 24
445 24
765 24
274 23
275 23
397 23
759 23
313 22
600 22
661 22
203 21
323 21
372 21
385 21
800 21
807 21
970 21
162 20
165 20
241 20
447 20
551 20
694 20
122 19
395 19
554 19
587 19
632 19
755 19
840 19
36 18
138 18
177 18
184 18
199 18
352 18
414 18
607 18
638 18
743 18
42 17
106 17
225 17
250 17
476 17
477 17
797 17
834 17
913 17
918 17
922 17
113 16
146 16
174 16
187 16
201 16
525 16
578 16
617 16
627 16
691 16
709 16
91 15
97 15
124 15
178 15
272 15
315 15
345 15
402 15
413 15
422 15
496 15
497 15
514 15
742 15
205 14
222 14
240 14
527 14
540 14
590 14
611 14
792 14
811 14
946 14
16 13
43 13
108 13
120 13
143 13
188 13
302 13
362 13
369 13
481 13
518 13
621 13
636 13
666 13
696 13
876 13
934 13
39 12
243 12
279 12
290 12
360 12
370 12
563 12
662 12
784 12
809 12
48 11
58 11
86 11
93 11
217 11
252 11
314 11
319 11
411 11
557 11
561 11
606 11
833 11
959 11
46 10
50 10
70 10
82 10
111 10
288 10
312 10
332 10
408 10
436 10
625 10
680 10
730 10
747 10
849 10
864 10
25 9
158 9
204 9
223 9
226 9
230 9
237 9
253 9
376 9
467 9
479 9
531 9
589 9
594 9
605 9
698 9
921 9
7 8
8 8
98 8
129 8
149 8
262 8
263 8
298 8
353 8
407 8
457 8
474 8
490 8
491 8
526 8
565 8
567 8
576 8
631 8
686 8
799 8
859 8
963 8
10 7
89 7
115 7
135 7
197 7
260 7
270 7
292 7
348 7
394 7
434 7
443 7
495 7
530 7
537 7
559 7
598 7
626 7
637 7
654 7
656 7
663 7
777 7
808 7
883 7
904 7
905 7
915 7
917 7
33 6
53 6
67 6
116 6
132 6
144 6
191 6
245 6
291 6
325 6
361 6
392 6
400 6
429 6
459 6
498 6
503 6
504 6
512 6
546 6
562 6
581 6
592 6
639 6
650 6
669 6
672 6
673 6
712 6
718 6
752 6
753 6
794 6
803 6
865 6
879 6
893 6
964 6
2 5
40 5
56 5
88 5
104 5
107 5
179 5
257 5
300 5
349 5
399 5
418 5
420 5
484 5
510 5
511 5
529 5
539 5
547 5
615 5
679 5
736 5
746 5
754 5
789 5
858 5
882 5
887 5
896 5
947 5
958 5
968 5
18 4
27 4
54 4
72 4
74 4
134 4
136 4
152 4
160 4
161 4
170 4
186 4
216 4
229 4
231 4
248 4
265 4
268 4
280 4
283 4
293 4
299 4
311 4
317 4
342 4
368 4
377 4
380 4
384 4
390 4
396 4
403 4
406 4
417 4
419 4
449 4
450 4
472 4
475 4
482 4
483 4
485 4
486 4
523 4
532 4
582 4
612 4
628 4
681 4
704 4
720 4
731 4
756 4
830 4
862 4
872 4
877 4
885 4
888 4
931 4
944 4
952 4
3 3
5 3
31 3
38 3
52 3
63 3
65 3
77 3
83 3
168 3
196 3
213 3
215 3
221 3
266 3
286 3
289 3
321 3
327 3
333 3
341 3
346 3
351 3
354 3
427 3
428 3
448 3
453 3
460 3
462 3
466 3
468 3
470 3
478 3
506 3
521 3
534 3
560 3
575 3
584 3
593 3
599 3
619 3
660 3
664 3
677 3
687 3
688 3
690 3
707 3
721 3
725 3
751 3
760 3
761 3
769 3
770 3
776 3
787 3
791 3
798 3
805 3
823 3
836 3
839 3
842 3
845 3
878 3
899 3
909 3
914 3
920 3
925 3
926 3
929 3
930 3
937 3
942 3
961 3
9 2
37 2
57 2
64 2
66 2
68 2
75 2
81 2
85 2
95 2
100 2
102 2
126 2
140 2
147 2
148 2
150 2
153 2
157 2
185 2
220 2
228 2
232 2
233 2
235 2
238 2
242 2
259 2
282 2
316 2
322 2
339 2
365 2
378 2
382 2
383 2
412 2
424 2
425 2
426 2
435 2
440 2
442 2
444 2
487 2
494 2
502 2
517 2
522 2
552 2
558 2
564 2
570 2
583 2
586 2
596 2
601 2
602 2
610 2
618 2
620 2
622 2
624 2
633 2
641 2
648 2
658 2
659 2
671 2
703 2
722 2
727 2
733 2
750 2
757 2
764 2
768 2
773 2
804 2
810 2
813 2
814 2
816 2
820 2
829 2
831 2
832 2
843 2
844 2
850 2
852 2
869 2
873 2
874 2
886 2
890 2
902 2
908 2
928 2
936 2
940 2
941 2
949 2
955 2
966 2
969 2
972 2
977 2
979 2
1 1
4 1
6 1
13 1
20 1
22 1
29 1
30 1
41 1
44 1
45 1
47 1
49 1
55 1
59 1
60 1
61 1
62 1
69 1
71 1
76 1
78 1
79 1
84 1
87 1
90 1
99 1
101 1
112 1
119 1
121 1
137 1
141 1
151 1
154 1
155 1
156 1
159 1
164 1
167 1
169 1
171 1
173 1
175 1
176 1
180 1
181 1
190 1
192 1
193 1
194 1
195 1
198 1
202 1
206 1
208 1
212 1
214 1
219 1
234 1
239 1
246 1
247 1
251 1
254 1
258 1
261 1
264 1
267 1
269 1
278 1
284 1
285 1
287 1
295 1
296 1
297 1
304 1
306 1
307 1
310 1
320 1
324 1
326 1
330 1
335 1
336 1
337 1
338 1
343 1
355 1
356 1
363 1
364 1
367 1
374 1
375 1
379 1
386 1
401 1
404 1
409 1
410 1
415 1
416 1
421 1
432 1
433 1
439 1
441 1
451 1
452 1
455 1
456 1
458 1
461 1
465 1
469 1
473 1
488 1
492 1
500 1
507 1
508 1
509 1
516 1
519 1
520 1
528 1
535 1
542 1
544 1
548 1
550 1
556 1
568 1
572 1
573 1
577 1
585 1
591 1
597 1
603 1
604 1
629 1
640 1
642 1
643 1
644 1
645 1
646 1
647 1
649 1
651 1
667 1
670 1
674 1
675 1
685 1
692 1
701 1
702 1
706 1
708 1
713 1
714 1
715 1
716 1
717 1
719 1
726 1
728 1
732 1
735 1
737 1
738 1
739 1
744 1
745 1
748 1
749 1
763 1
766 1
767 1
771 1
772 1
774 1
779 1
780 1
782 1
783 1
785 1
790 1
796 1
802 1
806 1
812 1
815 1
817 1
818 1
819 1
821 1
824 1
825 1
826 1
827 1
828 1
835 1
837 1
838 1
841 1
846 1
847 1
848 1
851 1
853 1
854 1
855 1
856 1
857 1
860 1
861 1
863 1
866 1
867 1
868 1
870 1
871 1
875 1
880 1
881 1
884 1
889 1
891 1
892 1
894 1
895 1
897 1
898 1
900 1
901 1
903 1
906 1
907 1
910 1
911 1
912 1
916 1
919 1
923 1
924 1
927 1
932 1
933 1
935 1
938 1
939 1
943 1
945 1
948 1
950 1
951 1
953 1
954 1
956 1
957 1
960 1
962 1
965 1
967 1
971 1
973 1
974 1
975 1
976 1
978 1
981 1
982 1
983 1
Corrgrams between price and discounts
corrgram(salesData.df[,c("FinalTotalPrice","VendorDiscount","WebsiteDiscount")], lower.panel = panel.shade, upper.panel = panel.pie)
Corrgrams between COD and the availability of discounts
corrgram(salesData.df[,c("COD","HasVendorDiscount","HasWebsiteDiscount")], lower.panel = panel.shade, upper.panel = panel.pie)
Hypothesis testing for finding COD's significance in price
cyes <- subset( salesData.df, salesData.df$COD == 1)
cno <- subset( salesData.df, salesData.df$COD == 0)
t.test(cyes$FinalTotalPrice, cno$FinalTotalPrice)
Welch Two Sample t-test
data: cyes$FinalTotalPrice and cno$FinalTotalPrice
t = 16.261, df = 42172, p-value < 2.2e-16
alternative hypothesis: true difference in means is not equal to 0
95 percent confidence interval:
45.24489 57.64667
sample estimates:
mean of x mean of y
774.6938 723.2480
Hypothesis testing for finding Metro/Non-metro Significance
myes <- subset( salesData.df, salesData.df$IsMetro == 1)
mno <- subset( salesData.df, salesData.df$IsMetro == 0)
t.test(cyes$FinalTotalPrice, cno$FinalTotalPrice)
Welch Two Sample t-test
data: cyes$FinalTotalPrice and cno$FinalTotalPrice
t = 16.261, df = 42172, p-value < 2.2e-16
alternative hypothesis: true difference in means is not equal to 0
95 percent confidence interval:
45.24489 57.64667
sample estimates:
mean of x mean of y
774.6938 723.2480