Use transaction data to categorize clients

Online businesses of all sorts are increasingly reliant on credit card transactions and the data they create. Information on where clients are, their likely purchasing behaviors, and other bits of data can be used by business to improve their practices. Taking the raw data and turning it into useful information is no easy task though, which is why many engineers find themselves processing and manipulating it on a regular basis.

top 20
16 months ago

Write a script:

Using the transactions data attached below, write a script in Java, Python, C/C++, or JavaScript that outputs a list of subscription IDs, their subscription type (daily, monthly, yearly, one-off), and the duration of their subscription.

Bonus Questions (not required):

1. Give annual revenue numbers for all years between 1966 and 2014. Which years had the highest revenue growth, and highest revenue loss?

2. Predict annual revenue for year 2015 (based on historical retention and new subscribers)

Additional Materials:
Submit your solution
This challenge has received 115 submissions
Top 20 share 10K
500 Square pic blackcat University of Waterloo
500 Square pic taopeng University of Wisconsin
500 Square pic 7669 University of Arizona
500 L University of California, Los Angeles
500 Square pic img 20140714 170549 001 Indian Institute of Technology - Bombay
500 Square pic default profile pic Carnegie Mellon University
500 Square pic 537000 1434045653485850 1328731353 n Indian Institute of Technology - Bombay
500 Square pic prof Princeton University
500 Square pic screen shot 2015 09 25 at 11.08.44 pm University of Washington
500 B University of California at San Diego
500 Square pic img 2102 University of Florida
500 D University of Maryland
500 Square pic screen shot 2015 06 08 at 9.28.13 pm University of California at Berkeley
500 Square pic screen shot 2016 01 21 at 9.18.05 am University of Toronto
500 Square pic self sept 1 2015 The Ohio State University
500 R North Carolina State University
500 Square pic img 2402 Massachusetts Institute of Technology
500 S University of Toronto
500 S McMaster University
500 S iiitd
Contact Us!
Share your thoughts, ideas and stories with 300,000 peers Write for our Blog