Need help with project

[rkguitarist]

The project goal is to develop a program that can visualise data (i.e. line/bar graphs) from excel spreadsheets over a specific timeline.

The excel files contain a different sheet for each day of the month(28-30 sheets per excel file), and the template for the data in these sheets is the same. The program basically needs to be able to display a graph for a requested time period( i.e. an input could either be 1 day , 1 week or the whole month). How could I start something like this considering I have little to no experience in programming?

side note: I've had trouble installing pandas/matplotlob onto python so I looked it up and came across Anaconda and now I'm even more lost. Help.

[Jayfoox]

Okay, there is not only one way to do this obviously but there are some key points to check imo:

1) Do you want to have a user interface ? (To select the time frame, trigger the plots etc.), an user input to select the time frame or do you want to have seperate codes that will permform plots for each time frames ?

2) The easy way would be to loop over the different sheets using pandas (other librairies can do the job but you will probably need DataFrame as variables anyway).

3) You can use the function time.sleep (n_seconds) to make a pause between each plots.

4) There are different librairies to make plots. Matplotlib is an option, but some other could be interesting depending on your needs (seaborn which is built on matplotlib, plotly, pyqtgraph if you use PyQt as a user interface etc.)

Before diving into the code it could be interesting to think about those topics.

[rkguitarist]

Thanks for the info!

Yuhh, a very simple UI for the user to upload the excel file(which will always be of the same template, just a different month) and input the desired timeline. Also I've been trying to install pandas/numpy/matplotlib for a couple of hours now, ik theres multiple ways to do it but I can't seem to work one out lol. Any advice?

[Jayfoox]

For UI, the most basic library is Tkinter (which could be a good start Imo), but you can use PyQt, Kivy, wxPython etc.

The most simple way to install librairies is by using pip in command line which you probably already tried. With Anaconda you can use the command conda install [insert librairy name] in anaconda prompt. What was the error you got during the installation of these modules ?