{ "cells": [ { "cell_type": "code", "execution_count": null, "metadata": { "collapsed": true }, "outputs": [], "source": [ "# import library" ] }, { "cell_type": "code", "execution_count": 92, "metadata": { "collapsed": true }, "outputs": [], "source": [ "import numpy as np\n", "import pandas as pd\n", "import matplotlib.pyplot as plt\n", "%matplotlib inline" ] }, { "cell_type": "code", "execution_count": null, "metadata": { "collapsed": true }, "outputs": [], "source": [ "# import file" ] }, { "cell_type": "code", "execution_count": 93, "metadata": { "collapsed": true }, "outputs": [], "source": [ "file_location = \"/Users/mingchang/Downloads/\"\n", "file_name = \"orders_new.csv\"\n", "my_data = pd.read_csv(file_location + file_name)" ] }, { "cell_type": "code", "execution_count": null, "metadata": { "collapsed": true }, "outputs": [], "source": [ "# what the data looks like" ] }, { "cell_type": "code", "execution_count": 94, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
| \n", " | country | \n", "date | \n", "experiment_id | \n", "order_id | \n", "spend_usd | \n", "user_id | \n", "vertical | \n", "
|---|---|---|---|---|---|---|---|
| 0 | \n", "US | \n", "2017-04-02 | \n", "12624549 | \n", "6720123150182430132 | \n", "49.99 | \n", "3659561261588336546 | \n", "ANDROID_APPS | \n", "
| 1 | \n", "US | \n", "2017-04-01 | \n", "12624549 | \n", "17511438899767627798 | \n", "0.99 | \n", "3659561261588336546 | \n", "ANDROID_APPS | \n", "
| 2 | \n", "US | \n", "2017-04-04 | \n", "12624549 | \n", "1549342062436664018 | \n", "39.99 | \n", "3659561261588336546 | \n", "ANDROID_APPS | \n", "
| 3 | \n", "US | \n", "2017-04-04 | \n", "12624549 | \n", "7771425263197855716 | \n", "19.99 | \n", "3659561261588336546 | \n", "ANDROID_APPS | \n", "
| 4 | \n", "US | \n", "2017-04-01 | \n", "12624549 | \n", "17943210556580942992 | \n", "19.99 | \n", "3659561261588336546 | \n", "ANDROID_APPS | \n", "