Answered step by step
Verified Expert Solution
Question
1 Approved Answer
PYTHON: For morning transaction, which product code has the highest revenue # Create a newfile1 contains rows time_hour
PYTHON: For morning transaction, which product code has the highest revenue # Create a newfile1 contains rows time_hour <= 12 # From that file, calculate total dollar value for each (groupby) product code # What is product code with the highest total dollar value.
Firm | time_hour | unit sold | product code | dollar value |
Prudential Financial | 15 | 439 | 127 | 779546 |
Consolidated Edison | 10 | 985 | 116 | 237185 |
State Street Corporation | 18 | 905 | 119 | 199437 |
Ball Corp | 20 | 875 | 124 | 652241 |
Linde | 17 | 874 | 116 | 825544 |
Consolidated Edison | 12 | 346 | 127 | 895683 |
CenterPoint Energy | 17 | 227 | 106 | 363095 |
Kroger | 8 | 254 | 105 | 145291 |
Consolidated Edison | 20 | 845 | 137 | 484035 |
PVH | 10 | 337 | 139 | 253507 |
Eli Lilly & Co | 11 | 740 | 147 | 779108 |
M&T Bank | 18 | 902 | 127 | 245723 |
PVH | 12 | 945 | 124 | 145881 |
Zions Bancorp | 15 | 777 | 143 | 595041 |
Principal Financial Group | 16 | 510 | 148 | 428109 |
FMC Corporation | 11 | 883 | 120 | 251743 |
American Express | 7 | 862 | 134 | 37938 |
General Mills | 14 | 922 | 149 | 127441 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started