You will find 4 separate csv datasets in the link above. Please download and use those
for the assignment.
- Sales Data is at Product-Store-Day Level
- Price is at Product-Month Level
- Availability is at Product-Store-Day level
- Target dataset is at Product-Month level, with target being a quantity
- Revenue = Price * Sales Quantity
- There could be missing values, duplicates and data type mismatches which you are
expected to handle
- Combine sales, price, availability and monthly target datasets to get daily sales,
price, availability and monthly target
We’re not going to do your homework for you. If you have a specific question about how to write python to do this assignment, you can ask that.
1 Like
yes man this is the question i am totally blank help me in this assignment question
Your teacher should have given you enough to get started.
As you seem too be very stuck suggest you start with your teacher.
1 Like
Hi,
reading .csv
files is relatively easy using the pandas
library package.
Start by referencing these two tutorials:
https://www.datacamp.com/tutorial/pandas-read-csv
Remember that in .csv
files, you can reference a particular cell by its row and column (much like a multiplication table).
1 Like