#đź”’ Seeking Collaboration on Python Dashboard Project Using Excel as Database

24 messages · Page 1 of 1 (latest)

coarse lichen
#

Hello Python enthusiasts! đź‘‹

I'm currently embarking on an exciting project to develop a dashboard using Python, with an Excel sheet serving as the database. My goal is to create a dynamic and interactive dashboard that can efficiently manipulate and display data pulled directly from Excel.

I'm looking for someone who can guide me through the best practices and possibly collaborate with me to:

Set up the Python environment to interact with Excel.
Design a responsive and intuitive user interface.
Implement functionalities that allow users to manipulate and visualize data seamlessly.
If you have experience with Python libraries like Pandas, OpenPyXL, or Dash, and you're interested in dashboard development, I would really appreciate your input and collaboration. I'm eager to learn and share this journey with someone who is as passionate about data and Python as I am.

Please DM me or reply here if you're interested in teaming up or if you have any advice or resources to share!

Thanks a lot! 🙏

crimson gazelleBOT
#

@coarse lichen

Python help channel opened

Remember to:

  • Ask your Python question, not if you can ask or if there's an expert who can help.
  • Show a code sample as text (rather than a screenshot) and the error message, if you've got one.
  • Explain what you expect to happen and what actually happens.

:warning: Do not pip install anything that isn't related to your question, especially if asked to over DMs.

Closes after a period of inactivity, or when you send !close.
near maple
#

Being brutally honest…
I doubt this is gonna go as well as you think.
A few questions you need to ask yourself before starting projects like this are:

  • has anyone done something like this before?
  • if not, why not?
  • if yes, did it work?
  • do people need this service?
  • how do I improve over the standard? (Just using Excel’s inbuilt tools)
  • what can I see being difficult to program? (Non standardised data comes to mind straight away)
coarse lichen
#

thank you, so what do you think is the right way to go about this project?

near maple
#

You’d probably need to do some investigating into other similar projects.
See if anyone else has done so.

#

And do a rough project outline

#

What features you want in your program

#

And how you’d expect yourself to go about it

#

What restrictions it’d have

#

If you come up with a rough project outline, you can send it in this server and have people tell you what they think of it

#

If the features make sense

#

If it’s even doable

coarse lichen
#

thank you

#

This project aims to develop an interactive, user-friendly dashboard that utilizes Python to manipulate and visualize data stored in an Excel spreadsheet. The dashboard will serve as a tool for real-time data analysis and decision support, enabling users to view, interact with, and draw insights from data dynamically.

sacred creek
#

One could argue that’s exactly what excel is.

If you do decide to follow through with this you’d be better off using a database instead of an excel sheet that way you’re actually building something on your own instead of just building a dumbed down excel on top of excel.

near maple
near maple
coarse lichen
#

Okay. Well noted

#

WIll you advice I turn the spreadsheet data to sql data?

coarse lichen
#

I want a web page to display this inputs in a form or cards, donut chart, bar chart, line graphs

coarse lichen
crimson gazelleBOT
#
Python help channel closed

This help channel has been closed and it's no longer possible to send messages here. If your question wasn't answered, feel free to create a new post in #1035199133436354600. To maximize your chances of getting a response, check out this guide on asking good questions.