Hands on Assignment 3

profilejams_r1
demo.txt
StoreID Date Division Units Revenue
340001 01/01/2000 Handbags 4 780
340001 01/01/2000 Belts 8 392
340001 01/01/2000 Watches 6 270
340001 01/01/2000 Eyewear 8 400
340001 01/01/2000 Jewelry 40 880
340001 01/01/2000 Luggage 3 525
340001 01/01/2000 Shoes 4 600
340002 01/01/2000 Handbags 6 1170
340002 01/01/2000 Belts 6 294
340002 01/01/2000 Watches 4 180
340002 01/01/2000 Eyewear 7 350
340002 01/01/2000 Jewelry 34 748
340002 01/01/2000 Luggage 3 525
340002 01/01/2000 Shoes 4 600
340003 01/01/2000 Handbags 6 1170
340003 01/01/2000 Belts 10 490
340003 01/01/2000 Watches 6 270
340003 01/01/2000 Eyewear 8 400
340003 01/01/2000 Jewelry 40 880
340003 01/01/2000 Luggage 3 525
340003 01/01/2000 Shoes 4 600
340004 01/01/2000 Belts 8 392
340004 01/01/2000 Watches 6 270
340004 01/01/2000 Eyewear 8 400
340004 01/01/2000 Jewelry 40 880
340004 01/01/2000 Luggage 3 525
340004 01/01/2000 Shoes 4 600
340005 01/01/2000 Belts 8 392
340005 01/01/2000 Watches 6 270
340005 01/01/2000 Eyewear 8 400
340005 01/01/2000 Jewelry 40 880
340005 01/01/2000 Luggage 3 525
340005 01/01/2000 Shoes 4 600
340006 01/01/2000 Belts 8 392
340006 01/01/2000 Watches 6 270
340006 01/01/2000 Eyewear 8 400
340006 01/01/2000 Jewelry 40 880
340006 01/01/2000 Luggage 3 525
340006 01/01/2000 Shoes 4 600
340007 01/01/2000 Belts 8 392
340007 01/01/2000 Watches 6 270
340007 01/01/2000 Eyewear 8 400
340007 01/01/2000 Jewelry 40 880
340007 01/01/2000 Luggage 3 525
340007 01/01/2000 Shoes 4 600
340008 01/01/2000 Belts 8 392
340008 01/01/2000 Watches 6 270
340008 01/01/2000 Eyewear 8 400
340008 01/01/2000 Jewelry 40 880
340008 01/01/2000 Luggage 3 525
340008 01/01/2000 Shoes 4 600
340009 01/01/2000 Belts 8 392
340009 01/01/2000 Watches 6 270
340009 01/01/2000 Eyewear 8 400
340009 01/01/2000 Jewelry 40 880
340009 01/01/2000 Luggage 3 525
340009 01/01/2000 Shoes 4 600
340010 01/01/2001 Belts 8 392
340010 01/01/2001 Watches 6 270
340010 01/01/2001 Eyewear 8 400
340010 01/01/2001 Jewelry 40 880
340010 01/01/2001 Luggage 3 525
340010 01/01/2001 Shoes 4 600
340011 01/01/2001 books 22 780
340011 01/01/2001 Belts 8 392
340011 01/01/2001 Watches 6 270
340011 01/01/2001 Fashion 8 950
340011 01/01/2001 Jewelry 40 880
340011 01/01/2001 Luggage 3 525
340011 01/01/2001 kichenware 12 600
340012 01/01/2001 Belts 8 392
340012 01/01/2001 Watches 6 270
340012 01/01/2001 Eyewear 8 400
340012 01/01/2001 Jewelry 40 880
340012 01/01/2001 Luggage 3 525
340012 01/01/2001 Shoes 4 600
340013 01/01/2001 Glassware 2 292
340013 01/01/2001 Watches 6 270
340013 01/01/2001 Eyewear 8 400
340013 01/01/2001 Jewelry 40 880
340013 01/01/2001 Luggage 3 525
340013 01/01/2001 Furniture 36 900
340014 01/01/2001 Belts 8 392
340014 01/01/2001 Watches 6 270
340014 01/01/2001 Eyewear 8 400
340014 01/01/2001 Jewelry 40 880
340014 01/01/2001 Luggage 3 525
340014 01/01/2001 Shoes 4 600
340015 01/01/2001 Glassware 8 392
340015 01/01/2001 Watches 6 270
340015 01/01/2001 Eyewear 8 400
340015 01/01/2001 Jewelry 40 880
340015 01/01/2001 Fashion 3 525
340015 01/01/2001 Shoes 4 600
340016 01/01/2001 Belts 8 392
340016 01/01/2001 Watches 6 270
340016 01/01/2001 Eyewear 8 400
340016 01/01/2001 Jewelry 40 880
340016 01/01/2001 Luggage 3 525
340016 01/01/2001 Shoes 4 600
340017 01/01/2001 Belts 8 392
340017 01/01/2001 Watches 6 270
340017 01/01/2001 kichenware 8 400
340017 01/01/2001 Jewelry 40 880
340017 01/01/2001 Luggage 3 525
340017 01/01/2001 Shoes 4 600
340018 01/01/2001 Belts 8 392
340018 01/01/2001 Watches 6 270
340018 01/01/2001 Eyewear 8 400
340018 01/01/2001 Jewelry 40 880
340018 01/01/2001 Luggage 3 525
340018 01/01/2001 Shoes 4 600
340019 01/01/2001 Belts 8 392
340019 01/01/2001 Watches 6 270
340019 01/01/2001 Eyewear 8 400
340019 01/01/2001 Jewelry 40 880
340019 01/01/2001 Luggage 3 525
340019 01/01/2001 Shoes 4 600
340020 01/01/2001 Belts 8 392
340020 01/01/2001 Watches 6 270
340020 01/01/2001 Eyewear 8 400
340020 01/01/2001 Jewelry 40 880
340020 01/01/2001 Luggage 3 525
340020 01/01/2001 Shoes 4 600
340021 01/01/2001 Belts 8 392
340021 01/01/2001 Watches 6 270
340021 01/01/2001 Eyewear 8 400
340021 01/01/2001 Jewelry 40 880
340021 01/01/2001 Luggage 3 525
340021 01/01/2001 Shoes 4 600
340022 01/01/2001 Belts 8 392
340022 01/01/2001 Watches 6 270
340022 01/01/2001 Eyewear 8 400
340022 01/01/2001 Jewelry 40 880
340022 01/01/2001 Luggage 3 525
340022 01/01/2001 Shoes 4 600
340023 01/01/2001 Belts 8 392
340023 01/01/2001 Watches 6 270
340023 01/01/2001 Eyewear 8 400
340023 01/01/2001 Jewelry 40 880
340023 01/01/2001 Luggage 3 525
340023 01/01/2001 Shoes 4 600
340024 01/01/2001 Belts 8 392
340024 01/01/2001 Watches 6 270
340024 01/01/2001 Eyewear 8 400
340024 01/01/2001 Jewelry 40 880
340024 01/01/2001 Luggage 3 525
340024 01/01/2001 Shoes 4 600
340025 01/01/2001 Gifts 8 392
340025 01/01/2001 Watches 6 270
340025 01/01/2001 Eyewear 8 400
340025 01/01/2001 Jewelry 40 880
340025 01/01/2001 Luggage 3 525
340025 01/01/2001 Shoes 4 600
340026 01/01/2001 Belts 8 392
340026 01/01/2001 Watches 6 270
340026 01/01/2001 Eyewear 8 400
340026 01/01/2001 Jewelry 40 880
340026 01/01/2001 Luggage 3 525
340026 01/01/2001 Shoes 4 600
340027 01/01/2001 Silverware 8 392
340027 01/01/2001 Watches 6 270
340027 01/01/2001 Eyewear 8 400
340027 01/01/2001 Jewelry 40 880
340027 01/01/2001 Luggage 3 525
340027 01/01/2001 Shoes 4 600
340028 01/01/2001 Belts 8 392
340028 01/01/2001 Silverware 6 270
340028 01/01/2001 Eyewear 8 400
340028 01/01/2001 Jewelry 40 880
340028 01/01/2001 Luggage 3 525
340028 01/01/2001 Shoes 4 600
340029 01/01/2001 Belts 8 392
340029 01/01/2001 Watches 6 270
340029 01/01/2001 Eyewear 8 400
340029 01/01/2001 Jewelry 40 880
340029 01/01/2001 Luggage 3 525
340029 01/01/2001 Shoes 4 600
340030 01/01/2001 Belts 8 392
340030 01/01/2001 Watches 6 270
340030 01/01/2001 Eyewear 8 400
340030 01/01/2001 Jewelry 40 880
340030 01/01/2001 Furniture 3 525
340030 01/01/2001 Shoes 4 600