+- Python Forum (https://python-forum.io)
+-- Forum: Python Coding (https://python-forum.io/forum-7.html)
+--- Forum: General Coding Help (https://python-forum.io/forum-8.html)
+--- Thread: Script to read, write data to excel file and update it to firebase (/thread-7299.html)
Script to read, write data to excel file and update it to firebase - Expertlearner - Jan-03-2018
I am going to do a project on database analysis where the data is read from an excel file. The user should be able to search for the dates, employee ids etc. The no of hours attended by each employee should be calculated with the hours that the employee missed also the percentage of attendance, alert if it gets below a certain margin. All these details need to be updated in the employees' page in firebase from the excel file regularly. The admin should be able to update the details with GUI.
Now being new to python, I just know the basics like to create classes, function etc. So what should i learn to be able to do the above or is there some script already avail that i can use? what packages will i need?
I got like 3 months to this! Thank you!
RE: Script to read, write data to excel file and update it to firebase - nilamo - Jan-03-2018
Pick one part, and start there. The real starting point, should be figuring out what it is you're doing. For example, why would you let someone search through data in excel, if you're also copying an excel doc into firebase and allowing admins to update firebase? Anything they search in the excel file would be outdated, or missing information.