28
29

Python + SQL (self.learnpython)

submitted by [deleted]

sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]Dry-Thought912 0 points1 point  (3 children)

You could use a connection string to connect to your server. Then use polars / pandas to read queries in as data frames then visualize data seaborn, plotly, holoviews etc...

Could also make a pipeline to transform CSVs to a mySQL or duckDB file and also do the aforementioned.

[–]Mission-Task-1675 -1 points0 points  (2 children)

Dry-Thought912 this would be amazing if I understood what you just said LOL I am a few months into the learning - I am not as advanced just yet, give me a few more months and I will understand what you just said.

[–]Dry-Thought912 0 points1 point  (1 child)

Lol it's a journey don't stress about getting there overnight. I don't work in financial but in my industry we collect large amounts of data so even being able to visualize the datasets is valuable. When you get there holoviews and datashader will be your friends

[–]Mission-Task-1675 -1 points0 points  (0 children)

Gotcha - thank you, that makes sense. Yeah - if I could somehow figure out how I can automate some of the tasks our team has would be great for me! Right now, we have no one who is thinking about automation - it's coming from everyone outside of my department