{ "cells": [ { "cell_type": "code", "execution_count": 1, "metadata": {}, "outputs": [], "source": [ "import pandas as pd \n", "import numpy as np\n", "import matplotlib.pyplot as plt\n", "import seaborn as sns\n", "import math\n", "import datetime\n", "\n", "import swat\n", "import warnings\n", "\n", "warnings.filterwarnings('ignore')\n", "pd.set_option('display.max_columns', None)\n", "sns.set_style('whitegrid')\n", "pd.options.display.max_rows = 999\n", "%matplotlib inline" ] }, { "cell_type": "code", "execution_count": 8, "metadata": {}, "outputs": [], "source": [ "path = '/Users/zhan009/Desktop/artist_benchmark/'" ] }, { "cell_type": "code", "execution_count": 9, "metadata": {}, "outputs": [], "source": [ "project_data = pd.read_csv(path + \"project_rank.csv\")\n", "project_data = project_data.sort_values(['project_artist_key', 'project_artist_name', \n", " 'project_id', 'project_name', 'project_date', 'report_date', 'date_diff'])" ] }, { "cell_type": "code", "execution_count": 11, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
project_artist_keyproject_artist_nameproject_idproject_namereport_dateproject_datedate_difftotal_stream
142302848628Camila Cabello1319646Romance2019-09-052019-09-050670257
112729848628Camila Cabello1319646Romance2019-09-062019-09-0511492181
151050848628Camila Cabello1319646Romance2019-09-072019-09-0521094120
18927848628Camila Cabello1319646Romance2019-09-082019-09-053910681
266024848628Camila Cabello1319646Romance2019-09-092019-09-0541032047
162431848628Camila Cabello1319646Romance2019-09-102019-09-0551010722
190235848628Camila Cabello1319646Romance2019-09-112019-09-056976476
250529848628Camila Cabello1319646Romance2019-09-122019-09-057974531
91374848628Camila Cabello1319646Romance2019-09-132019-09-058960840
155748848628Camila Cabello1319646Romance2019-09-142019-09-059844192
244496848628Camila Cabello1319646Romance2019-09-152019-09-0510745763
273446848628Camila Cabello1319646Romance2019-09-162019-09-0511857214
164713848628Camila Cabello1319646Romance2019-09-172019-09-0512870397
148351848628Camila Cabello1319646Romance2019-09-182019-09-0513849635
167884848628Camila Cabello1319646Romance2019-09-192019-09-0514820370
179414848628Camila Cabello1319646Romance2019-09-202019-09-0515819423
435213848628Camila Cabello1319646Romance2019-09-212019-09-0516765184
15807848628Camila Cabello1319646Romance2019-09-222019-09-0517688473
159631848628Camila Cabello1319646Romance2019-09-232019-09-0518781847
160764848628Camila Cabello1319646Romance2019-09-242019-09-0519783460
12613848628Camila Cabello1319646Romance2019-09-252019-09-0520782577
32696848628Camila Cabello1319646Romance2019-09-262019-09-0521780428
14752848628Camila Cabello1319646Romance2019-09-272019-09-0522733489
276141848628Camila Cabello1319646Romance2019-09-282019-09-0523653214
171693848628Camila Cabello1319646Romance2019-09-292019-09-0524578522
131127848628Camila Cabello1319646Romance2019-09-302019-09-0525649437
193132848628Camila Cabello1319646Romance2019-10-012019-09-0526675995
182264848628Camila Cabello1319646Romance2019-10-022019-09-0527664323
368907848628Camila Cabello1319646Romance2019-10-032019-09-0528672885
148542848628Camila Cabello1319646Romance2019-10-042019-09-05291221105
420978848628Camila Cabello1319646Romance2019-10-052019-09-0530958807
198638848628Camila Cabello1319646Romance2019-10-062019-09-0531811443
238811848628Camila Cabello1319646Romance2019-10-072019-09-0532912655
187585848628Camila Cabello1319646Romance2019-10-082019-09-0533895737
368732848628Camila Cabello1319646Romance2019-10-092019-09-0534867743
189560848628Camila Cabello1319646Romance2019-10-102019-09-0535885257
162641848628Camila Cabello1319646Romance2019-10-112019-09-05361490101
176552848628Camila Cabello1319646Romance2019-10-122019-09-05371173271
21789848628Camila Cabello1319646Romance2019-10-132019-09-05381028736
251697848628Camila Cabello1319646Romance2019-10-142019-09-05391212637
176565848628Camila Cabello1319646Romance2019-10-152019-09-05401194420
175573848628Camila Cabello1319646Romance2019-10-162019-09-05411151382
280698848628Camila Cabello1319646Romance2019-10-172019-09-05421161495
185227848628Camila Cabello1319646Romance2019-10-182019-09-05431134132
154965848628Camila Cabello1319646Romance2019-10-192019-09-0544964260
389637848628Camila Cabello1319646Romance2019-10-202019-09-0545866992
42057848628Camila Cabello1319646Romance2019-10-212019-09-0546993638
180449848628Camila Cabello1319646Romance2019-10-222019-09-0547990955
205719848628Camila Cabello1319646Romance2019-10-232019-09-05481038720
183763848628Camila Cabello1319646Romance2019-10-242019-09-05491025236
178194848628Camila Cabello1319646Romance2019-10-252019-09-05501084573
391543848628Camila Cabello1319646Romance2019-10-262019-09-0551934471
168661848628Camila Cabello1319646Romance2019-10-272019-09-0552808442
206424848628Camila Cabello1319646Romance2019-10-282019-09-0553946548
185265848628Camila Cabello1319646Romance2019-10-292019-09-0554951739
464603848628Camila Cabello1319646Romance2019-10-302019-09-05551072638
210559848628Camila Cabello1319646Romance2019-10-312019-09-05561005383
263135848628Camila Cabello1319646Romance2019-11-012019-09-0557922480
483155848628Camila Cabello1319646Romance2019-11-022019-09-0558824346
286073848628Camila Cabello1319646Romance2019-11-032019-09-0559742914
184920848628Camila Cabello1319646Romance2019-11-042019-09-0560877895
298323848628Camila Cabello1319646Romance2019-11-052019-09-0561895036
188823848628Camila Cabello1319646Romance2019-11-062019-09-0562882992
200786848628Camila Cabello1319646Romance2019-11-072019-09-0563858207
175978848628Camila Cabello1319646Romance2019-11-082019-09-0564843954
324335848628Camila Cabello1319646Romance2019-11-092019-09-0565747302
476934848628Camila Cabello1319646Romance2019-11-102019-09-0566666368
166320848628Camila Cabello1319646Romance2019-11-112019-09-0567747709
61155848628Camila Cabello1319646Romance2019-11-122019-09-0568762632
18200848628Camila Cabello1319646Romance2019-11-132019-09-0569769462
483188848628Camila Cabello1319646Romance2019-11-142019-09-0570777466
214225848628Camila Cabello1319646Romance2019-11-152019-09-05711133459
192125848628Camila Cabello1319646Romance2019-11-162019-09-0572938105
20772848628Camila Cabello1319646Romance2019-11-172019-09-0573788609
278748848628Camila Cabello1319646Romance2019-11-182019-09-0574908709
218274848628Camila Cabello1319646Romance2019-11-192019-09-0575936188
200470848628Camila Cabello1319646Romance2019-11-202019-09-0576910710
199453848628Camila Cabello1319646Romance2019-11-212019-09-0577895100
200660848628Camila Cabello1319646Romance2019-11-222019-09-0578864133
234449848628Camila Cabello1319646Romance2019-11-232019-09-0579767332
206981848628Camila Cabello1319646Romance2019-11-242019-09-0580686967
199110848628Camila Cabello1319646Romance2019-11-252019-09-0581868872
203473848628Camila Cabello1319646Romance2019-11-262019-09-0582931709
172537848628Camila Cabello1319646Romance2019-11-272019-09-0583932904
333625848628Camila Cabello1319646Romance2019-11-282019-09-0584715970
209227848628Camila Cabello1319646Romance2019-11-292019-09-0585629413
506579848628Camila Cabello1319646Romance2019-11-302019-09-0586683263
205398848628Camila Cabello1319646Romance2019-12-012019-09-0587681611
267311848628Camila Cabello1319646Romance2019-12-022019-09-0588770226
521965848628Camila Cabello1319646Romance2019-12-032019-09-0589791449
291170848628Camila Cabello1319646Romance2019-12-042019-09-0590810567
265223848628Camila Cabello1319646Romance2019-12-052019-09-0591733916
301725848628Camila Cabello1319646Romance2019-12-062019-09-05923229715
211089848628Camila Cabello1319646Romance2019-12-072019-09-05932624073
497439848628Camila Cabello1319646Romance2019-12-082019-09-05942113438
172638848628Camila Cabello1319646Romance2019-12-092019-09-05952498907
434991848628Camila Cabello1319646Romance2019-12-102019-09-05962530869
225626848628Camila Cabello1319646Romance2019-12-112019-09-05972417245
253817848628Camila Cabello1319646Romance2019-12-122019-09-05982437159
424919848628Camila Cabello1319646Romance2019-12-132019-09-05992313282
210596848628Camila Cabello1319646Romance2019-12-142019-09-051002044017
206838848628Camila Cabello1319646Romance2019-12-152019-09-051011837882
223621848628Camila Cabello1319646Romance2019-12-162019-09-051022068734
215901848628Camila Cabello1319646Romance2019-12-172019-09-051032036053
185657848628Camila Cabello1319646Romance2019-12-182019-09-051042000182
191486848628Camila Cabello1319646Romance2019-12-192019-09-051051933196
205546848628Camila Cabello1319646Romance2019-12-202019-09-051061817500
146647848628Camila Cabello1319646Romance2019-12-212019-09-051071587426
384612848628Camila Cabello1319646Romance2019-12-222019-09-051081408740
343682848628Camila Cabello1319646Romance2019-12-232019-09-051091540267
231956848628Camila Cabello1319646Romance2019-12-242019-09-051101428262
228607848628Camila Cabello1319646Romance2019-12-252019-09-051111064693
215985848628Camila Cabello1319646Romance2019-12-262019-09-051121413711
21743848628Camila Cabello1319646Romance2019-12-272019-09-051131548288
554562848628Camila Cabello1319646Romance2019-12-282019-09-051141463395
349698848628Camila Cabello1319646Romance2019-12-292019-09-051151328373
206730848628Camila Cabello1319646Romance2019-12-302019-09-051161498587
193203848628Camila Cabello1319646Romance2019-12-312019-09-051171564832
164214848628Camila Cabello1319646Romance2020-01-012019-09-051181226830
236809848628Camila Cabello1319646Romance2020-01-022019-09-051191503652
261593848628Camila Cabello1319646Romance2020-01-032019-09-051201705653
253006848628Camila Cabello1319646Romance2020-01-042019-09-051211512341
24791848628Camila Cabello1319646Romance2020-01-052019-09-051221362257
247441848628Camila Cabello1319646Romance2020-01-062019-09-051231583532
217503848628Camila Cabello1319646Romance2020-01-072019-09-051241582169
228647848628Camila Cabello1319646Romance2020-01-082019-09-051251564753
187930848628Camila Cabello1319646Romance2020-01-092019-09-051261511687
644938848628Camila Cabello1319646Romance2020-01-102019-09-051271485437
262798848628Camila Cabello1319646Romance2020-01-112019-09-051281342850
261621848628Camila Cabello1319646Romance2020-01-122019-09-051291247721
399798848628Camila Cabello1319646Romance2020-01-132019-09-051301410277
221950848628Camila Cabello1319646Romance2020-01-142019-09-051311454867
452918848628Camila Cabello1319646Romance2020-01-152019-09-051321441981
237172848628Camila Cabello1319646Romance2020-01-162019-09-051331439346
247321848628Camila Cabello1319646Romance2020-01-172019-09-051341405603
32330848628Camila Cabello1319646Romance2020-01-182019-09-051351242467
456438848628Camila Cabello1319646Romance2020-01-192019-09-051361122280
233756848628Camila Cabello1319646Romance2020-01-202019-09-051371221142
391368848628Camila Cabello1319646Romance2020-01-212019-09-051381280616
246154848628Camila Cabello1319646Romance2020-01-222019-09-051391258605
404159848628Camila Cabello1319646Romance2020-01-232019-09-051401285463
53457848628Camila Cabello1319646Romance2020-01-242019-09-051411277990
284127848628Camila Cabello1319646Romance2020-01-252019-09-051421172318
273040848628Camila Cabello1319646Romance2020-01-262019-09-051431065919
240971848628Camila Cabello1319646Romance2020-01-272019-09-051441506114
308214848628Camila Cabello1319646Romance2020-01-282019-09-051451571266
247756848628Camila Cabello1319646Romance2020-01-292019-09-051461514914
245501848628Camila Cabello1319646Romance2020-01-302019-09-051471478765
456264848628Camila Cabello1319646Romance2020-01-312019-09-051481453982
446125848628Camila Cabello1319646Romance2020-02-012019-09-051491307266
446131848628Camila Cabello1319646Romance2020-02-022019-09-051501202162
378303848628Camila Cabello1319646Romance2020-02-032019-09-051511256224
456275848628Camila Cabello1319646Romance2020-02-042019-09-051521348534
454544848628Camila Cabello1319646Romance2020-02-052019-09-051531326333
259002848628Camila Cabello1319646Romance2020-02-062019-09-051541304347
405157848628Camila Cabello1319646Romance2020-02-072019-09-051551310423
202461848628Camila Cabello1319646Romance2020-02-082019-09-051561219844
287768848628Camila Cabello1319646Romance2020-02-092019-09-051571115581
258829848628Camila Cabello1319646Romance2020-02-102019-09-051581247146
271813848628Camila Cabello1319646Romance2020-02-112019-09-051591303006
534372848628Camila Cabello1319646Romance2020-02-122019-09-051601310035
270139848628Camila Cabello1319646Romance2020-02-132019-09-051611332349
267407848628Camila Cabello1319646Romance2020-02-142019-09-051621373693
280467848628Camila Cabello1319646Romance2020-02-152019-09-051631193890
276037848628Camila Cabello1319646Romance2020-02-162019-09-051641068798
240356848628Camila Cabello1319646Romance2020-02-172019-09-051651163129
195858848628Camila Cabello1319646Romance2020-02-182019-09-051661194907
200050848628Camila Cabello1319646Romance2020-02-192019-09-051671201732
248301848628Camila Cabello1319646Romance2020-02-202019-09-051681176006
249992848628Camila Cabello1319646Romance2020-02-212019-09-051691200104
259538848628Camila Cabello1319646Romance2020-02-222019-09-051701131765
479607848628Camila Cabello1319646Romance2020-02-232019-09-051711030145
684606848628Camila Cabello1319646Romance2020-02-242019-09-051721130527
245202848628Camila Cabello1319646Romance2020-02-252019-09-051731157607
275986848628Camila Cabello1319646Romance2020-02-262019-09-051741162525
223272848628Camila Cabello1319646Romance2020-02-272019-09-051751155899
288129848628Camila Cabello1319646Romance2020-02-282019-09-051761166969
294147848628Camila Cabello1319646Romance2020-02-292019-09-051771078490
302859848628Camila Cabello1319646Romance2020-03-012019-09-05178960279
422672848628Camila Cabello1319646Romance2020-03-022019-09-051791039227
255730848628Camila Cabello1319646Romance2020-03-032019-09-051801071767
\n", "
" ], "text/plain": [ " project_artist_key project_artist_name project_id project_name \\\n", "142302 848628 Camila Cabello 1319646 Romance \n", "112729 848628 Camila Cabello 1319646 Romance \n", "151050 848628 Camila Cabello 1319646 Romance \n", "18927 848628 Camila Cabello 1319646 Romance \n", "266024 848628 Camila Cabello 1319646 Romance \n", "162431 848628 Camila Cabello 1319646 Romance \n", "190235 848628 Camila Cabello 1319646 Romance \n", "250529 848628 Camila Cabello 1319646 Romance \n", "91374 848628 Camila Cabello 1319646 Romance \n", "155748 848628 Camila Cabello 1319646 Romance \n", "244496 848628 Camila Cabello 1319646 Romance \n", "273446 848628 Camila Cabello 1319646 Romance \n", "164713 848628 Camila Cabello 1319646 Romance \n", "148351 848628 Camila Cabello 1319646 Romance \n", "167884 848628 Camila Cabello 1319646 Romance \n", "179414 848628 Camila Cabello 1319646 Romance \n", "435213 848628 Camila Cabello 1319646 Romance \n", "15807 848628 Camila Cabello 1319646 Romance \n", "159631 848628 Camila Cabello 1319646 Romance \n", "160764 848628 Camila Cabello 1319646 Romance \n", "12613 848628 Camila Cabello 1319646 Romance \n", "32696 848628 Camila Cabello 1319646 Romance \n", "14752 848628 Camila Cabello 1319646 Romance \n", "276141 848628 Camila Cabello 1319646 Romance \n", "171693 848628 Camila Cabello 1319646 Romance \n", "131127 848628 Camila Cabello 1319646 Romance \n", "193132 848628 Camila Cabello 1319646 Romance \n", "182264 848628 Camila Cabello 1319646 Romance \n", "368907 848628 Camila Cabello 1319646 Romance \n", "148542 848628 Camila Cabello 1319646 Romance \n", "420978 848628 Camila Cabello 1319646 Romance \n", "198638 848628 Camila Cabello 1319646 Romance \n", "238811 848628 Camila Cabello 1319646 Romance \n", "187585 848628 Camila Cabello 1319646 Romance \n", "368732 848628 Camila Cabello 1319646 Romance \n", "189560 848628 Camila Cabello 1319646 Romance \n", "162641 848628 Camila Cabello 1319646 Romance \n", "176552 848628 Camila Cabello 1319646 Romance \n", "21789 848628 Camila Cabello 1319646 Romance \n", "251697 848628 Camila Cabello 1319646 Romance \n", "176565 848628 Camila Cabello 1319646 Romance \n", "175573 848628 Camila Cabello 1319646 Romance \n", "280698 848628 Camila Cabello 1319646 Romance \n", "185227 848628 Camila Cabello 1319646 Romance \n", "154965 848628 Camila Cabello 1319646 Romance \n", "389637 848628 Camila Cabello 1319646 Romance \n", "42057 848628 Camila Cabello 1319646 Romance \n", "180449 848628 Camila Cabello 1319646 Romance \n", "205719 848628 Camila Cabello 1319646 Romance \n", "183763 848628 Camila Cabello 1319646 Romance \n", "178194 848628 Camila Cabello 1319646 Romance \n", "391543 848628 Camila Cabello 1319646 Romance \n", "168661 848628 Camila Cabello 1319646 Romance \n", "206424 848628 Camila Cabello 1319646 Romance \n", "185265 848628 Camila Cabello 1319646 Romance \n", "464603 848628 Camila Cabello 1319646 Romance \n", "210559 848628 Camila Cabello 1319646 Romance \n", "263135 848628 Camila Cabello 1319646 Romance \n", "483155 848628 Camila Cabello 1319646 Romance \n", "286073 848628 Camila Cabello 1319646 Romance \n", "184920 848628 Camila Cabello 1319646 Romance \n", "298323 848628 Camila Cabello 1319646 Romance \n", "188823 848628 Camila Cabello 1319646 Romance \n", "200786 848628 Camila Cabello 1319646 Romance \n", "175978 848628 Camila Cabello 1319646 Romance \n", "324335 848628 Camila Cabello 1319646 Romance \n", "476934 848628 Camila Cabello 1319646 Romance \n", "166320 848628 Camila Cabello 1319646 Romance \n", "61155 848628 Camila Cabello 1319646 Romance \n", "18200 848628 Camila Cabello 1319646 Romance \n", "483188 848628 Camila Cabello 1319646 Romance \n", "214225 848628 Camila Cabello 1319646 Romance \n", "192125 848628 Camila Cabello 1319646 Romance \n", "20772 848628 Camila Cabello 1319646 Romance \n", "278748 848628 Camila Cabello 1319646 Romance \n", "218274 848628 Camila Cabello 1319646 Romance \n", "200470 848628 Camila Cabello 1319646 Romance \n", "199453 848628 Camila Cabello 1319646 Romance \n", "200660 848628 Camila Cabello 1319646 Romance \n", "234449 848628 Camila Cabello 1319646 Romance \n", "206981 848628 Camila Cabello 1319646 Romance \n", "199110 848628 Camila Cabello 1319646 Romance \n", "203473 848628 Camila Cabello 1319646 Romance \n", "172537 848628 Camila Cabello 1319646 Romance \n", "333625 848628 Camila Cabello 1319646 Romance \n", "209227 848628 Camila Cabello 1319646 Romance \n", "506579 848628 Camila Cabello 1319646 Romance \n", "205398 848628 Camila Cabello 1319646 Romance \n", "267311 848628 Camila Cabello 1319646 Romance \n", "521965 848628 Camila Cabello 1319646 Romance \n", "291170 848628 Camila Cabello 1319646 Romance \n", "265223 848628 Camila Cabello 1319646 Romance \n", "301725 848628 Camila Cabello 1319646 Romance \n", "211089 848628 Camila Cabello 1319646 Romance \n", "497439 848628 Camila Cabello 1319646 Romance \n", "172638 848628 Camila Cabello 1319646 Romance \n", "434991 848628 Camila Cabello 1319646 Romance \n", "225626 848628 Camila Cabello 1319646 Romance \n", "253817 848628 Camila Cabello 1319646 Romance \n", "424919 848628 Camila Cabello 1319646 Romance \n", "210596 848628 Camila Cabello 1319646 Romance \n", "206838 848628 Camila Cabello 1319646 Romance \n", "223621 848628 Camila Cabello 1319646 Romance \n", "215901 848628 Camila Cabello 1319646 Romance \n", "185657 848628 Camila Cabello 1319646 Romance \n", "191486 848628 Camila Cabello 1319646 Romance \n", "205546 848628 Camila Cabello 1319646 Romance \n", "146647 848628 Camila Cabello 1319646 Romance \n", "384612 848628 Camila Cabello 1319646 Romance \n", "343682 848628 Camila Cabello 1319646 Romance \n", "231956 848628 Camila Cabello 1319646 Romance \n", "228607 848628 Camila Cabello 1319646 Romance \n", "215985 848628 Camila Cabello 1319646 Romance \n", "21743 848628 Camila Cabello 1319646 Romance \n", "554562 848628 Camila Cabello 1319646 Romance \n", "349698 848628 Camila Cabello 1319646 Romance \n", "206730 848628 Camila Cabello 1319646 Romance \n", "193203 848628 Camila Cabello 1319646 Romance \n", "164214 848628 Camila Cabello 1319646 Romance \n", "236809 848628 Camila Cabello 1319646 Romance \n", "261593 848628 Camila Cabello 1319646 Romance \n", "253006 848628 Camila Cabello 1319646 Romance \n", "24791 848628 Camila Cabello 1319646 Romance \n", "247441 848628 Camila Cabello 1319646 Romance \n", "217503 848628 Camila Cabello 1319646 Romance \n", "228647 848628 Camila Cabello 1319646 Romance \n", "187930 848628 Camila Cabello 1319646 Romance \n", "644938 848628 Camila Cabello 1319646 Romance \n", "262798 848628 Camila Cabello 1319646 Romance \n", "261621 848628 Camila Cabello 1319646 Romance \n", "399798 848628 Camila Cabello 1319646 Romance \n", "221950 848628 Camila Cabello 1319646 Romance \n", "452918 848628 Camila Cabello 1319646 Romance \n", "237172 848628 Camila Cabello 1319646 Romance \n", "247321 848628 Camila Cabello 1319646 Romance \n", "32330 848628 Camila Cabello 1319646 Romance \n", "456438 848628 Camila Cabello 1319646 Romance \n", "233756 848628 Camila Cabello 1319646 Romance \n", "391368 848628 Camila Cabello 1319646 Romance \n", "246154 848628 Camila Cabello 1319646 Romance \n", "404159 848628 Camila Cabello 1319646 Romance \n", "53457 848628 Camila Cabello 1319646 Romance \n", "284127 848628 Camila Cabello 1319646 Romance \n", "273040 848628 Camila Cabello 1319646 Romance \n", "240971 848628 Camila Cabello 1319646 Romance \n", "308214 848628 Camila Cabello 1319646 Romance \n", "247756 848628 Camila Cabello 1319646 Romance \n", "245501 848628 Camila Cabello 1319646 Romance \n", "456264 848628 Camila Cabello 1319646 Romance \n", "446125 848628 Camila Cabello 1319646 Romance \n", "446131 848628 Camila Cabello 1319646 Romance \n", "378303 848628 Camila Cabello 1319646 Romance \n", "456275 848628 Camila Cabello 1319646 Romance \n", "454544 848628 Camila Cabello 1319646 Romance \n", "259002 848628 Camila Cabello 1319646 Romance \n", "405157 848628 Camila Cabello 1319646 Romance \n", "202461 848628 Camila Cabello 1319646 Romance \n", "287768 848628 Camila Cabello 1319646 Romance \n", "258829 848628 Camila Cabello 1319646 Romance \n", "271813 848628 Camila Cabello 1319646 Romance \n", "534372 848628 Camila Cabello 1319646 Romance \n", "270139 848628 Camila Cabello 1319646 Romance \n", "267407 848628 Camila Cabello 1319646 Romance \n", "280467 848628 Camila Cabello 1319646 Romance \n", "276037 848628 Camila Cabello 1319646 Romance \n", "240356 848628 Camila Cabello 1319646 Romance \n", "195858 848628 Camila Cabello 1319646 Romance \n", "200050 848628 Camila Cabello 1319646 Romance \n", "248301 848628 Camila Cabello 1319646 Romance \n", "249992 848628 Camila Cabello 1319646 Romance \n", "259538 848628 Camila Cabello 1319646 Romance \n", "479607 848628 Camila Cabello 1319646 Romance \n", "684606 848628 Camila Cabello 1319646 Romance \n", "245202 848628 Camila Cabello 1319646 Romance \n", "275986 848628 Camila Cabello 1319646 Romance \n", "223272 848628 Camila Cabello 1319646 Romance \n", "288129 848628 Camila Cabello 1319646 Romance \n", "294147 848628 Camila Cabello 1319646 Romance \n", "302859 848628 Camila Cabello 1319646 Romance \n", "422672 848628 Camila Cabello 1319646 Romance \n", "255730 848628 Camila Cabello 1319646 Romance \n", "\n", " report_date project_date date_diff total_stream \n", "142302 2019-09-05 2019-09-05 0 670257 \n", "112729 2019-09-06 2019-09-05 1 1492181 \n", "151050 2019-09-07 2019-09-05 2 1094120 \n", "18927 2019-09-08 2019-09-05 3 910681 \n", "266024 2019-09-09 2019-09-05 4 1032047 \n", "162431 2019-09-10 2019-09-05 5 1010722 \n", "190235 2019-09-11 2019-09-05 6 976476 \n", "250529 2019-09-12 2019-09-05 7 974531 \n", "91374 2019-09-13 2019-09-05 8 960840 \n", "155748 2019-09-14 2019-09-05 9 844192 \n", "244496 2019-09-15 2019-09-05 10 745763 \n", "273446 2019-09-16 2019-09-05 11 857214 \n", "164713 2019-09-17 2019-09-05 12 870397 \n", "148351 2019-09-18 2019-09-05 13 849635 \n", "167884 2019-09-19 2019-09-05 14 820370 \n", "179414 2019-09-20 2019-09-05 15 819423 \n", "435213 2019-09-21 2019-09-05 16 765184 \n", "15807 2019-09-22 2019-09-05 17 688473 \n", "159631 2019-09-23 2019-09-05 18 781847 \n", "160764 2019-09-24 2019-09-05 19 783460 \n", "12613 2019-09-25 2019-09-05 20 782577 \n", "32696 2019-09-26 2019-09-05 21 780428 \n", "14752 2019-09-27 2019-09-05 22 733489 \n", "276141 2019-09-28 2019-09-05 23 653214 \n", "171693 2019-09-29 2019-09-05 24 578522 \n", "131127 2019-09-30 2019-09-05 25 649437 \n", "193132 2019-10-01 2019-09-05 26 675995 \n", "182264 2019-10-02 2019-09-05 27 664323 \n", "368907 2019-10-03 2019-09-05 28 672885 \n", "148542 2019-10-04 2019-09-05 29 1221105 \n", "420978 2019-10-05 2019-09-05 30 958807 \n", "198638 2019-10-06 2019-09-05 31 811443 \n", "238811 2019-10-07 2019-09-05 32 912655 \n", "187585 2019-10-08 2019-09-05 33 895737 \n", "368732 2019-10-09 2019-09-05 34 867743 \n", "189560 2019-10-10 2019-09-05 35 885257 \n", "162641 2019-10-11 2019-09-05 36 1490101 \n", "176552 2019-10-12 2019-09-05 37 1173271 \n", "21789 2019-10-13 2019-09-05 38 1028736 \n", "251697 2019-10-14 2019-09-05 39 1212637 \n", "176565 2019-10-15 2019-09-05 40 1194420 \n", "175573 2019-10-16 2019-09-05 41 1151382 \n", "280698 2019-10-17 2019-09-05 42 1161495 \n", "185227 2019-10-18 2019-09-05 43 1134132 \n", "154965 2019-10-19 2019-09-05 44 964260 \n", "389637 2019-10-20 2019-09-05 45 866992 \n", "42057 2019-10-21 2019-09-05 46 993638 \n", "180449 2019-10-22 2019-09-05 47 990955 \n", "205719 2019-10-23 2019-09-05 48 1038720 \n", "183763 2019-10-24 2019-09-05 49 1025236 \n", "178194 2019-10-25 2019-09-05 50 1084573 \n", "391543 2019-10-26 2019-09-05 51 934471 \n", "168661 2019-10-27 2019-09-05 52 808442 \n", "206424 2019-10-28 2019-09-05 53 946548 \n", "185265 2019-10-29 2019-09-05 54 951739 \n", "464603 2019-10-30 2019-09-05 55 1072638 \n", "210559 2019-10-31 2019-09-05 56 1005383 \n", "263135 2019-11-01 2019-09-05 57 922480 \n", "483155 2019-11-02 2019-09-05 58 824346 \n", "286073 2019-11-03 2019-09-05 59 742914 \n", "184920 2019-11-04 2019-09-05 60 877895 \n", "298323 2019-11-05 2019-09-05 61 895036 \n", "188823 2019-11-06 2019-09-05 62 882992 \n", "200786 2019-11-07 2019-09-05 63 858207 \n", "175978 2019-11-08 2019-09-05 64 843954 \n", "324335 2019-11-09 2019-09-05 65 747302 \n", "476934 2019-11-10 2019-09-05 66 666368 \n", "166320 2019-11-11 2019-09-05 67 747709 \n", "61155 2019-11-12 2019-09-05 68 762632 \n", "18200 2019-11-13 2019-09-05 69 769462 \n", "483188 2019-11-14 2019-09-05 70 777466 \n", "214225 2019-11-15 2019-09-05 71 1133459 \n", "192125 2019-11-16 2019-09-05 72 938105 \n", "20772 2019-11-17 2019-09-05 73 788609 \n", "278748 2019-11-18 2019-09-05 74 908709 \n", "218274 2019-11-19 2019-09-05 75 936188 \n", "200470 2019-11-20 2019-09-05 76 910710 \n", "199453 2019-11-21 2019-09-05 77 895100 \n", "200660 2019-11-22 2019-09-05 78 864133 \n", "234449 2019-11-23 2019-09-05 79 767332 \n", "206981 2019-11-24 2019-09-05 80 686967 \n", "199110 2019-11-25 2019-09-05 81 868872 \n", "203473 2019-11-26 2019-09-05 82 931709 \n", "172537 2019-11-27 2019-09-05 83 932904 \n", "333625 2019-11-28 2019-09-05 84 715970 \n", "209227 2019-11-29 2019-09-05 85 629413 \n", "506579 2019-11-30 2019-09-05 86 683263 \n", "205398 2019-12-01 2019-09-05 87 681611 \n", "267311 2019-12-02 2019-09-05 88 770226 \n", "521965 2019-12-03 2019-09-05 89 791449 \n", "291170 2019-12-04 2019-09-05 90 810567 \n", "265223 2019-12-05 2019-09-05 91 733916 \n", "301725 2019-12-06 2019-09-05 92 3229715 \n", "211089 2019-12-07 2019-09-05 93 2624073 \n", "497439 2019-12-08 2019-09-05 94 2113438 \n", "172638 2019-12-09 2019-09-05 95 2498907 \n", "434991 2019-12-10 2019-09-05 96 2530869 \n", "225626 2019-12-11 2019-09-05 97 2417245 \n", "253817 2019-12-12 2019-09-05 98 2437159 \n", "424919 2019-12-13 2019-09-05 99 2313282 \n", "210596 2019-12-14 2019-09-05 100 2044017 \n", "206838 2019-12-15 2019-09-05 101 1837882 \n", "223621 2019-12-16 2019-09-05 102 2068734 \n", "215901 2019-12-17 2019-09-05 103 2036053 \n", "185657 2019-12-18 2019-09-05 104 2000182 \n", "191486 2019-12-19 2019-09-05 105 1933196 \n", "205546 2019-12-20 2019-09-05 106 1817500 \n", "146647 2019-12-21 2019-09-05 107 1587426 \n", "384612 2019-12-22 2019-09-05 108 1408740 \n", "343682 2019-12-23 2019-09-05 109 1540267 \n", "231956 2019-12-24 2019-09-05 110 1428262 \n", "228607 2019-12-25 2019-09-05 111 1064693 \n", "215985 2019-12-26 2019-09-05 112 1413711 \n", "21743 2019-12-27 2019-09-05 113 1548288 \n", "554562 2019-12-28 2019-09-05 114 1463395 \n", "349698 2019-12-29 2019-09-05 115 1328373 \n", "206730 2019-12-30 2019-09-05 116 1498587 \n", "193203 2019-12-31 2019-09-05 117 1564832 \n", "164214 2020-01-01 2019-09-05 118 1226830 \n", "236809 2020-01-02 2019-09-05 119 1503652 \n", "261593 2020-01-03 2019-09-05 120 1705653 \n", "253006 2020-01-04 2019-09-05 121 1512341 \n", "24791 2020-01-05 2019-09-05 122 1362257 \n", "247441 2020-01-06 2019-09-05 123 1583532 \n", "217503 2020-01-07 2019-09-05 124 1582169 \n", "228647 2020-01-08 2019-09-05 125 1564753 \n", "187930 2020-01-09 2019-09-05 126 1511687 \n", "644938 2020-01-10 2019-09-05 127 1485437 \n", "262798 2020-01-11 2019-09-05 128 1342850 \n", "261621 2020-01-12 2019-09-05 129 1247721 \n", "399798 2020-01-13 2019-09-05 130 1410277 \n", "221950 2020-01-14 2019-09-05 131 1454867 \n", "452918 2020-01-15 2019-09-05 132 1441981 \n", "237172 2020-01-16 2019-09-05 133 1439346 \n", "247321 2020-01-17 2019-09-05 134 1405603 \n", "32330 2020-01-18 2019-09-05 135 1242467 \n", "456438 2020-01-19 2019-09-05 136 1122280 \n", "233756 2020-01-20 2019-09-05 137 1221142 \n", "391368 2020-01-21 2019-09-05 138 1280616 \n", "246154 2020-01-22 2019-09-05 139 1258605 \n", "404159 2020-01-23 2019-09-05 140 1285463 \n", "53457 2020-01-24 2019-09-05 141 1277990 \n", "284127 2020-01-25 2019-09-05 142 1172318 \n", "273040 2020-01-26 2019-09-05 143 1065919 \n", "240971 2020-01-27 2019-09-05 144 1506114 \n", "308214 2020-01-28 2019-09-05 145 1571266 \n", "247756 2020-01-29 2019-09-05 146 1514914 \n", "245501 2020-01-30 2019-09-05 147 1478765 \n", "456264 2020-01-31 2019-09-05 148 1453982 \n", "446125 2020-02-01 2019-09-05 149 1307266 \n", "446131 2020-02-02 2019-09-05 150 1202162 \n", "378303 2020-02-03 2019-09-05 151 1256224 \n", "456275 2020-02-04 2019-09-05 152 1348534 \n", "454544 2020-02-05 2019-09-05 153 1326333 \n", "259002 2020-02-06 2019-09-05 154 1304347 \n", "405157 2020-02-07 2019-09-05 155 1310423 \n", "202461 2020-02-08 2019-09-05 156 1219844 \n", "287768 2020-02-09 2019-09-05 157 1115581 \n", "258829 2020-02-10 2019-09-05 158 1247146 \n", "271813 2020-02-11 2019-09-05 159 1303006 \n", "534372 2020-02-12 2019-09-05 160 1310035 \n", "270139 2020-02-13 2019-09-05 161 1332349 \n", "267407 2020-02-14 2019-09-05 162 1373693 \n", "280467 2020-02-15 2019-09-05 163 1193890 \n", "276037 2020-02-16 2019-09-05 164 1068798 \n", "240356 2020-02-17 2019-09-05 165 1163129 \n", "195858 2020-02-18 2019-09-05 166 1194907 \n", "200050 2020-02-19 2019-09-05 167 1201732 \n", "248301 2020-02-20 2019-09-05 168 1176006 \n", "249992 2020-02-21 2019-09-05 169 1200104 \n", "259538 2020-02-22 2019-09-05 170 1131765 \n", "479607 2020-02-23 2019-09-05 171 1030145 \n", "684606 2020-02-24 2019-09-05 172 1130527 \n", "245202 2020-02-25 2019-09-05 173 1157607 \n", "275986 2020-02-26 2019-09-05 174 1162525 \n", "223272 2020-02-27 2019-09-05 175 1155899 \n", "288129 2020-02-28 2019-09-05 176 1166969 \n", "294147 2020-02-29 2019-09-05 177 1078490 \n", "302859 2020-03-01 2019-09-05 178 960279 \n", "422672 2020-03-02 2019-09-05 179 1039227 \n", "255730 2020-03-03 2019-09-05 180 1071767 " ] }, "execution_count": 11, "metadata": {}, "output_type": "execute_result" } ], "source": [ "project_data[project_data.project_artist_name == 'Camila Cabello']" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [] } ], "metadata": { "kernelspec": { "display_name": "Python 3", "language": "python", "name": "python3" }, "language_info": { "codemirror_mode": { "name": "ipython", "version": 3 }, "file_extension": ".py", "mimetype": "text/x-python", "name": "python", "nbconvert_exporter": "python", "pygments_lexer": "ipython3", "version": "3.7.4" } }, "nbformat": 4, "nbformat_minor": 2 }