Use transaction data to categorize clients
computer science java software engineering c++ analytics data analysis python data structures data visualization data mining data modeling data processing
$1,000
top 20
115
submissions
DONE
26 months ago
Small pic credit card istock 000004399002xsmall

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.

Deliverables

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)

    Submissions will be graded on the following criteria:
  • Meets Deliverables
  • Creativity
  • Clarity
Additional Materials:
Leaderboard
Top 20 share $1,000
$50.00 Square pic 60 blackcat University of Waterloo
$50.00 Square pic 60 taopeng University of Wisconsin
$50.00 Square pic 60 7669 University of Arizona
$50.00 L University of California, Los Angeles
$50.00 Square pic 60 img 20140714 170549 001 Indian Institute of Technology - Bombay
$50.00 Square pic 60 default profile pic Carnegie Mellon University
$50.00 Square pic 60 537000 1434045653485850 1328731353 n Indian Institute of Technology - Bombay
$50.00 Square pic 60 prof Princeton University
$50.00 Square pic 60 screen shot 2015 09 25 at 11.08.44 pm University of Washington
$50.00 B University of California at San Diego
$50.00 Square pic 60 img 2102 University of Florida
$50.00 D University of Maryland
$50.00 Square pic 60 screen shot 2015 06 08 at 9.28.13 pm University of California at Berkeley
$50.00 Square pic 60 screen shot 2016 01 21 at 9.18.05 am University of Toronto
$50.00 Square pic 60 self sept 1 2015 The Ohio State University
$50.00 R North Carolina State University
$50.00 Square pic 60 img 2402 Massachusetts Institute of Technology
$50.00 S University of Toronto
$50.00 S McMaster University
$50.00 S iiitd