Mar-31-2020, 04:20 PM
Hi,
I have an application already built in VBA for Access that does data visualization on a user imported CSV files.
Its kind of boggy and slow. The graphing is poor.
I am thinking of rebuilding in Python. The fact that my project demands query-ability almost makes the idea of converting to python silly. I don't know anything about using DBs in Python and feel like its just going to be more work than keeping it in Access/VBA.
All i need to do is be able to query the CSV file and get the data quickly so I can put each column into graphs/etc.
What is the easiest solution for achieving this? How would you approach?
Regards --
I have an application already built in VBA for Access that does data visualization on a user imported CSV files.
Its kind of boggy and slow. The graphing is poor.
I am thinking of rebuilding in Python. The fact that my project demands query-ability almost makes the idea of converting to python silly. I don't know anything about using DBs in Python and feel like its just going to be more work than keeping it in Access/VBA.
All i need to do is be able to query the CSV file and get the data quickly so I can put each column into graphs/etc.
What is the easiest solution for achieving this? How would you approach?
Regards --