Last active
September 28, 2023 12:46
-
-
Save dvdsmpsn/02aaa0b09d4bb24b221439e79165faef to your computer and use it in GitHub Desktop.
examples csv from https://excelbianalytics.com/wp/downloads-18-sample-csv-files-data-sets-for-testing-sales/
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Region | Country | Item Type | Sales Channel | Order Priority | Order Date | Order ID | Ship Date | Units Sold | Unit Price | Unit Cost | Total Revenue | Total Cost | Total Profit | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Australia and Oceania | Tuvalu | Baby Food | Offline | H | 5/28/2010 | 669165933 | 6/27/2010 | 9925 | 255.28 | 159.42 | 2533654.00 | 1582243.50 | 951410.50 | |
| Central America and the Caribbean | Grenada | Cereal | Online | C | 8/22/2012 | 963881480 | 9/15/2012 | 2804 | 205.70 | 117.11 | 576782.80 | 328376.44 | 248406.36 | |
| Europe | Russia | Office Supplies | Offline | L | 5/2/2014 | 341417157 | 5/8/2014 | 1779 | 651.21 | 524.96 | 1158502.59 | 933903.84 | 224598.75 | |
| Sub-Saharan Africa | Sao Tome and Principe | Fruits | Online | C | 6/20/2014 | 514321792 | 7/5/2014 | 8102 | 9.33 | 6.92 | 75591.66 | 56065.84 | 19525.82 | |
| Sub-Saharan Africa | Rwanda | Office Supplies | Offline | L | 2/1/2013 | 115456712 | 2/6/2013 | 5062 | 651.21 | 524.96 | 3296425.02 | 2657347.52 | 639077.50 | |
| Australia and Oceania | Solomon Islands | Baby Food | Online | C | 2/4/2015 | 547995746 | 2/21/2015 | 2974 | 255.28 | 159.42 | 759202.72 | 474115.08 | 285087.64 | |
| Sub-Saharan Africa | Angola | Household | Offline | M | 4/23/2011 | 135425221 | 4/27/2011 | 4187 | 668.27 | 502.54 | 2798046.49 | 2104134.98 | 693911.51 | |
| Sub-Saharan Africa | Burkina Faso | Vegetables | Online | H | 7/17/2012 | 871543967 | 7/27/2012 | 8082 | 154.06 | 90.93 | 1245112.92 | 734896.26 | 510216.66 | |
| Sub-Saharan Africa | Republic of the Congo | Personal Care | Offline | M | 7/14/2015 | 770463311 | 8/25/2015 | 6070 | 81.73 | 56.67 | 496101.10 | 343986.90 | 152114.20 | |
| Sub-Saharan Africa | Senegal | Cereal | Online | H | 4/18/2014 | 616607081 | 5/30/2014 | 6593 | 205.70 | 117.11 | 1356180.10 | 772106.23 | 584073.87 | |
| Asia | Kyrgyzstan | Vegetables | Online | H | 6/24/2011 | 814711606 | 7/12/2011 | 124 | 154.06 | 90.93 | 19103.44 | 11275.32 | 7828.12 | |
| Sub-Saharan Africa | Cape Verde | Clothes | Offline | H | 8/2/2014 | 939825713 | 8/19/2014 | 4168 | 109.28 | 35.84 | 455479.04 | 149381.12 | 306097.92 | |
| Asia | Bangladesh | Clothes | Online | L | 1/13/2017 | 187310731 | 3/1/2017 | 8263 | 109.28 | 35.84 | 902980.64 | 296145.92 | 606834.72 | |
| Central America and the Caribbean | Honduras | Household | Offline | H | 2/8/2017 | 522840487 | 2/13/2017 | 8974 | 668.27 | 502.54 | 5997054.98 | 4509793.96 | 1487261.02 | |
| Asia | Mongolia | Personal Care | Offline | C | 2/19/2014 | 832401311 | 2/23/2014 | 4901 | 81.73 | 56.67 | 400558.73 | 277739.67 | 122819.06 | |
| Europe | Bulgaria | Clothes | Online | M | 4/23/2012 | 972292029 | 6/3/2012 | 1673 | 109.28 | 35.84 | 182825.44 | 59960.32 | 122865.12 | |
| Asia | Sri Lanka | Cosmetics | Offline | M | 11/19/2016 | 419123971 | 12/18/2016 | 6952 | 437.20 | 263.33 | 3039414.40 | 1830670.16 | 1208744.24 | |
| Sub-Saharan Africa | Cameroon | Beverages | Offline | C | 4/1/2015 | 519820964 | 4/18/2015 | 5430 | 47.45 | 31.79 | 257653.50 | 172619.70 | 85033.80 | |
| Asia | Turkmenistan | Household | Offline | L | 12/30/2010 | 441619336 | 1/20/2011 | 3830 | 668.27 | 502.54 | 2559474.10 | 1924728.20 | 634745.90 | |
| Australia and Oceania | East Timor | Meat | Online | L | 7/31/2012 | 322067916 | 9/11/2012 | 5908 | 421.89 | 364.69 | 2492526.12 | 2154588.52 | 337937.60 | |
| Europe | Norway | Baby Food | Online | L | 5/14/2014 | 819028031 | 6/28/2014 | 7450 | 255.28 | 159.42 | 1901836.00 | 1187679.00 | 714157.00 | |
| Europe | Portugal | Baby Food | Online | H | 7/31/2015 | 860673511 | 9/3/2015 | 1273 | 255.28 | 159.42 | 324971.44 | 202941.66 | 122029.78 | |
| Central America and the Caribbean | Honduras | Snacks | Online | L | 6/30/2016 | 795490682 | 7/26/2016 | 2225 | 152.58 | 97.44 | 339490.50 | 216804.00 | 122686.50 | |
| Australia and Oceania | New Zealand | Fruits | Online | H | 9/8/2014 | 142278373 | 10/4/2014 | 2187 | 9.33 | 6.92 | 20404.71 | 15134.04 | 5270.67 | |
| Europe | Moldova | Personal Care | Online | L | 5/7/2016 | 740147912 | 5/10/2016 | 5070 | 81.73 | 56.67 | 414371.10 | 287316.90 | 127054.20 | |
| Europe | France | Cosmetics | Online | H | 5/22/2017 | 898523128 | 6/5/2017 | 1815 | 437.20 | 263.33 | 793518.00 | 477943.95 | 315574.05 | |
| Australia and Oceania | Kiribati | Fruits | Online | M | 10/13/2014 | 347140347 | 11/10/2014 | 5398 | 9.33 | 6.92 | 50363.34 | 37354.16 | 13009.18 | |
| Sub-Saharan Africa | Mali | Fruits | Online | L | 5/7/2010 | 686048400 | 5/10/2010 | 5822 | 9.33 | 6.92 | 54319.26 | 40288.24 | 14031.02 | |
| Europe | Norway | Beverages | Offline | C | 7/18/2014 | 435608613 | 7/30/2014 | 5124 | 47.45 | 31.79 | 243133.80 | 162891.96 | 80241.84 | |
| Sub-Saharan Africa | The Gambia | Household | Offline | L | 5/26/2012 | 886494815 | 6/9/2012 | 2370 | 668.27 | 502.54 | 1583799.90 | 1191019.80 | 392780.10 | |
| Europe | Switzerland | Cosmetics | Offline | M | 9/17/2012 | 249693334 | 10/20/2012 | 8661 | 437.20 | 263.33 | 3786589.20 | 2280701.13 | 1505888.07 | |
| Sub-Saharan Africa | South Sudan | Personal Care | Offline | C | 12/29/2013 | 406502997 | 1/28/2014 | 2125 | 81.73 | 56.67 | 173676.25 | 120423.75 | 53252.50 | |
| Australia and Oceania | Australia | Office Supplies | Online | C | 10/27/2015 | 158535134 | 11/25/2015 | 2924 | 651.21 | 524.96 | 1904138.04 | 1534983.04 | 369155.00 | |
| Asia | Myanmar | Household | Offline | H | 1/16/2015 | 177713572 | 3/1/2015 | 8250 | 668.27 | 502.54 | 5513227.50 | 4145955.00 | 1367272.50 | |
| Sub-Saharan Africa | Djibouti | Snacks | Online | M | 2/25/2017 | 756274640 | 2/25/2017 | 7327 | 152.58 | 97.44 | 1117953.66 | 713942.88 | 404010.78 | |
| Central America and the Caribbean | Costa Rica | Personal Care | Offline | L | 5/8/2017 | 456767165 | 5/21/2017 | 6409 | 81.73 | 56.67 | 523807.57 | 363198.03 | 160609.54 | |
| Middle East and North Africa | Syria | Fruits | Online | L | 11/22/2011 | 162052476 | 12/3/2011 | 3784 | 9.33 | 6.92 | 35304.72 | 26185.28 | 9119.44 | |
| Sub-Saharan Africa | The Gambia | Meat | Online | M | 1/14/2017 | 825304400 | 1/23/2017 | 4767 | 421.89 | 364.69 | 2011149.63 | 1738477.23 | 272672.40 | |
| Asia | Brunei | Office Supplies | Online | L | 4/1/2012 | 320009267 | 5/8/2012 | 6708 | 651.21 | 524.96 | 4368316.68 | 3521431.68 | 846885.00 | |
| Europe | Bulgaria | Office Supplies | Online | M | 2/16/2012 | 189965903 | 2/28/2012 | 3987 | 651.21 | 524.96 | 2596374.27 | 2093015.52 | 503358.75 | |
| Sub-Saharan Africa | Niger | Personal Care | Online | H | 3/11/2017 | 699285638 | 3/28/2017 | 3015 | 81.73 | 56.67 | 246415.95 | 170860.05 | 75555.90 | |
| Middle East and North Africa | Azerbaijan | Cosmetics | Online | M | 2/6/2010 | 382392299 | 2/25/2010 | 7234 | 437.20 | 263.33 | 3162704.80 | 1904929.22 | 1257775.58 | |
| Sub-Saharan Africa | The Gambia | Cereal | Offline | H | 6/7/2012 | 994022214 | 6/8/2012 | 2117 | 205.70 | 117.11 | 435466.90 | 247921.87 | 187545.03 | |
| Europe | Slovakia | Vegetables | Online | H | 10/6/2012 | 759224212 | 11/10/2012 | 171 | 154.06 | 90.93 | 26344.26 | 15549.03 | 10795.23 | |
| Asia | Myanmar | Clothes | Online | H | 11/14/2015 | 223359620 | 11/18/2015 | 5930 | 109.28 | 35.84 | 648030.40 | 212531.20 | 435499.20 | |
| Sub-Saharan Africa | Comoros | Cereal | Offline | H | 3/29/2016 | 902102267 | 4/29/2016 | 962 | 205.70 | 117.11 | 197883.40 | 112659.82 | 85223.58 | |
| Europe | Iceland | Cosmetics | Online | C | 12/31/2016 | 331438481 | 12/31/2016 | 8867 | 437.20 | 263.33 | 3876652.40 | 2334947.11 | 1541705.29 | |
| Europe | Switzerland | Personal Care | Online | M | 12/23/2010 | 617667090 | 1/31/2011 | 273 | 81.73 | 56.67 | 22312.29 | 15470.91 | 6841.38 | |
| Europe | Macedonia | Clothes | Offline | C | 10/14/2014 | 787399423 | 11/14/2014 | 7842 | 109.28 | 35.84 | 856973.76 | 281057.28 | 575916.48 | |
| Sub-Saharan Africa | Mauritania | Office Supplies | Offline | C | 1/11/2012 | 837559306 | 1/13/2012 | 1266 | 651.21 | 524.96 | 824431.86 | 664599.36 | 159832.50 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment