M
M
Mark Mishchenko2020-03-02 16:30:06
Django
Mark Mishchenko, 2020-03-02 16:30:06

Dataframe or database for a trading application?

Good day to all, question:
There is an Excel table, the first line is the name of the equipment; the first column is additional equipment options. I want to try to write an application in python (as I understand it, it's better to do it in Django) so that I can create a commercial offer. That is, I select the equipment (from the drop-down list) and collect options for it, eventually getting the total cost of the equipment.
What is the right way to approach this issue? to throw an ex-fur-tree in dataframe and to work with it? or to work with a DB?
If anyone can point me to a similar solution, I'd be very grateful.
Do not throw slippers on my experience, I have little and, in principle, this is not my profile, but an elective.

Answer the question

In order to leave comments, you need to log in

2 answer(s)
B
beduin01, 2020-03-02
@beduin01

DataFrame is suitable for the case when there is little data.
If there is a lot of data, then only the database.

A
ArtiomK, 2020-03-02
@ArtiomK

According to the description, in any case, you need a database, in one table there will be a list of equipment names, in the second table a list of options + price, linked to the first table by a foreign key (this will be the equipment id, or you can use its name as a key). This is needed to get data for your user interface from somewhere. Further, the calculation of the cost can be done without the participation of the server using JavaScript, if you do not want, then you can also on the server side by sending FORM using the POST method.
The framework can choose Flask, there is an opinion that it is easier for beginners, there is also an opposite opinion that Flask is more difficult, but you can make a "more customizable" application on it.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question