from mpl_toolkits.mplot3d import Axes3D
import matplotlib.pyplot as plt
import numpy as np
import pandas as pd
import sys
import os
import matplotlib
import matplotlib.dates as mdates
import datetime
from datetime import datetime


data = pd.read_csv(os.path.join(os.path.dirname(__file__), 'new.csv'))





fig = plt.figure()
ax = fig.add_subplot(111, projection='3d')

b = data.iloc[:, 8]
a = pd.to_datetime(b, format='%Y/%m/%dT%H:%M:%S.%fZ', errors='ignore')
print(a)

x = data.iloc[:, 0] #date  #.iloc[:, 0] grabs column without header
y = data.iloc[:, 2] #number
z = data.iloc[:, 6] #quantity
#c = data.bluered   #blue or red


ax.scatter(x, y, z)  #ax.scatter(x, y, z, c=c)
plt.xlim(-1, 35)
plt.ylim(0, 300)
ax.set_zlim(-1,150)
plt.show()