Question

You've just started a new job as a data analyst. You're working for a midsized pharmacy chain with 38 stores in the American Southwest. Your supervisor shares a new data analysis project with you.
She explains that the pharmacy is considering discontinuing a bubble bath product called Splashtastic. Your supervisor wants you to analyze sales data and determine what percentage of each store's total daily sales come from that product. Then, you'll present your findings to leadership.
You know that it's important to follow each step of the data analysis process: ask, prepare, process, analyze, share, and act. So, you begin by defining the problem and making sure you fully understand stakeholder expectations.
One of the questions you ask is where to find the dataset you'll be working with. Your supervisor explains that the company database has all the information you need.
Next, you continue to the prepare step. You access the database and write a query to retrieve data about Splashtastic. You notice that there are only 38 rows of data, representing the company's 38 stores. In addition, your dataset contains five columns: Store Number, Average Daily Customers, Average Daily Splashtastic Sales (Units), Average Daily Splashtastic Sales (Dollars), and Average Total Daily Sales (All Products).
You know that spreadsheets work well for processing and analyzing a small dataset, like the one you're using. To get the data from the database into a spreadsheet, what should you do?
Download the data as a .CSV file, then import it into a spreadsheet.

Answer 1

Using the knowledge in computational language in python it is possible to write a code that dataset contains five columns: Store Number, Average Daily Customers, Average Daily Splashtastic Sales (Units), Average Daily Splashtastic Sales (Dollars), and Average Total Daily Sales (All Products).

Writting the code:

def run_command(cmd):

   fields = map(unescape, cmd.split(";"))

   handlers[fields[0]](fields[1:])

...

handler("mail")

def mail_handler(address, template):

   import whatever

   ...

   send_mail(address, get_template(template) % user_info, ...)

def myMailCommand(...):

   ...

def myOtherCommand(...):

   ...

available_commands = {'mail': myMailCommand,

                     'other': myOtherCommand}

to_execute = [('mail', (arg1, arg2, arg3)),

             ('other', (arg1, arg2))]

for cmd, args in to_execute:

   available_commands[cmd](*args)

See more about python at brainly.com/question/18502436

#SPJ1