@@ -0,0 +1,262 @@
+#Script to extract data from excel file and write it to JSON%0A# coding: utf-8%0A%0Aimport pandas as pd%0Adf = pd.read_excel('DH2.xlsx')%0Adf=df.dropna(how='any')%0Az=df.iloc%5B:,(1,2,3,4,5,6,7)%5D%0Az.columns=%5B'Mon','Tue','Wed','Thu','Fri','Sat','Sun'%5D%0Az.to_json(%22week.json%22)%0A%0A%0A%0A

Create data.py