Learn practical skills, build real-world projects, and advance your career
Created 5 years ago
import numpy as np
import pandas as pd
data = pd.read_csv("data.csv")
from datetime import datetime
data.head()
data.info()
<class 'pandas.core.frame.DataFrame'>
RangeIndex: 2823 entries, 0 to 2822
Data columns (total 24 columns):
ORDERNUMBER 2823 non-null int64
QUANTITYORDERED 2823 non-null int64
PRICEEACH 2823 non-null float64
ORDERLINENUMBER 2823 non-null int64
SALES 2823 non-null float64
ORDERDATE 2823 non-null object
STATUS 2823 non-null object
MONTH_ID 2823 non-null int64
YEAR_ID 2823 non-null int64
PRODUCTLINE 2823 non-null object
MSRP 2823 non-null int64
PRODUCTCODE 2823 non-null object
CUSTOMERNAME 2823 non-null object
PHONE 2823 non-null object
ADDRESSLINE1 2823 non-null object
ADDRESSLINE2 302 non-null object
CITY 2823 non-null object
STATE 1337 non-null object
POSTALCODE 2747 non-null object
COUNTRY 2823 non-null object
TERRITORY 1749 non-null object
CONTACTLASTNAME 2823 non-null object
CONTACTFIRSTNAME 2823 non-null object
DEALSIZE 2823 non-null object
dtypes: float64(2), int64(6), object(16)
memory usage: 529.4+ KB