What special things can
be done using python?
Recently I happen to
analyse a set of csv files atleast 100.
Each file contains several fields- variables, among them the
most is the purchaser Id, purchase date .
The task is,
List all the purchaser’s id and find them in the successive
date files, to identify whether the
purchaser has visited again.
If available list the dates and the value of all purchases
he has made.
The illustration
Day1 – 01-12-2018
Ids value of
purchase
123 10
234 15
456 25
Get the summary – 3 customers , Rs 50 /-
Find these ids in the next day – 02-12-2018
If available get the summary- only one purchaser id is
available – value is Rs 20
Extend this for the next 99 days. This is cycle 1.
Pick up the list of purchasers in the day 2 and continue
this process for the next 98 days.
WoW , what a wonderful tool is this ?
It is calculating the number of files available, running the iterations – say 100 factorial,
tabulating summarizing the results
as output in excel format, and what else, the capability is still more.
No comments:
Post a Comment