Pandas exercise in Python (Jupiter Notebook)
Device.csv
User,Device,OS,Transactions,Recent Visit,Revenue
A,Mobile,,5,4/5/2020 11:03,
B,Mobile,Android6,3,8/12/2020 23:03,
C,,iOS,7,8/7/2020 10:20,
D,Tablet,Android,1,7/18/2020 21:13,
E,PC,Win,4,8/17/2020 1:23,
F,iPad,iOS,,6/24/2020 15:23,
G,PC,Windows10,,5/1/2020 12:33,
H,iPhone 6,iOS5,2,6/12/2020 8:33,
A,Mobile,,5,4/5/2020 11:03,
B,Mobile,Android6,3,8/12/2020 23:03,
Pandas Exercise.ipynb
{
“cells”: [
{
“cell_type”: “markdown”,
“metadata”: {},
“source”: [
“# Exercise for Pandas n”,
“files device.csv and user.csv are needed.”
]
},
{
“cell_type”: “code”,
“execution_count”: 1,
“metadata”: {},
“outputs”: [],
“source”: [
“import numpy as npn”,
“import pandas as pd”
]
},
{
“cell_type”: “code”,
“execution_count”: 2,
“metadata”: {},
“outputs”: [
{
“name”: “stdout”,
“output_type”: “stream”,
“text”: [
“John 3.5n”,
“Amy 4.1n”,
“Elle 3.8n”,
“Kevin 3.8n”,
“dtype: float64n”
]
}
],
“source”: [
“# Create a series “GPA”” with a Python list [3.5
