import pandas as pd
import matplotlib.pyplot as plt
import numpy as np

df = pd.read_excel('D4.xlsx')

x = df.Time_Receieved
y = df.Fifth_fuel
z = df.Sixth_fuel

array = []
x_array = []
y_array = []

for i in range(len(y)):
    array.append(i)
    x_array.append(' ')
    y_array.append(y[i])

array_new = np.array(array)
y_array_new = np.array(y_array)

x_array.insert(0, x[0])

x_array.insert(int(len(y)/4)-601, '.')
x_array.insert(int(len(y)/4)-501, '.')
x_array.insert(int(len(y)/4)-401, '.')
x_array.insert(int(len(y)/4)-301, '.')
x_array.insert(int(len(y)/4)-201, '.')
x_array.insert(int(len(y)/4)-101, '.')
x_array.insert(int(len(y)/4)-1, '.')
x_array.insert(int(len(y)/4)+99, '.')
x_array.insert(int(len(y)/4)+199, '.')
x_array.insert(int(len(y)/4)+299, '.')
x_array.insert(int(len(y)/4)+399, '.')
x_array.insert(int(len(y)/4)+499, '.')
x_array.insert(int(len(y)/4)+599, '.')

x_array.insert(int(len(y)/2)-1, x[(len(y)/2)-1])

x_array.insert(int(len(y)*3/4)-601, '.')
x_array.insert(int(len(y)*3/4)-501, '.')
x_array.insert(int(len(y)*3/4)-401, '.')
x_array.insert(int(len(y)*3/4)-301, '.')
x_array.insert(int(len(y)*3/4)-201, '.')
x_array.insert(int(len(y)*3/4)-101, '.')
x_array.insert(int(len(y)*3/4)-1, '.')
x_array.insert(int(len(y)*3/4)+99, '.')
x_array.insert(int(len(y)*3/4)+199, '.')
x_array.insert(int(len(y)*3/4)+299, '.')
x_array.insert(int(len(y)*3/4)+399, '.')
x_array.insert(int(len(y)*3/4)+499, '.')
x_array.insert(int(len(y)*3/4)+599, '.')

x_array.insert(len(y)-1, x[len(y)-1])

ax = plt.gca()
ax.tick_params(axis='both', which='major', labelsize=15)
ax.tick_params(axis='both', which='minor', labelsize=15)
plt.xticks(array_new, x_array)
plt.plot(array_new, y_array)
z.plot()
plt.title('Dataset_4 - Second Filtering vs Final Value', fontsize=22)
plt.xlabel('Date and Time', fontsize=20)
plt.ylabel('Fuel Level', fontsize=20)
plt.legend(('Second Filtering', 'Final Value'),
           loc='upper left', fontsize=15)
plt.show()