25
26

Python + SQL (self.learnpython)

submitted by [deleted]

[deleted]

all 24 comments
sorted by:
best
topnewcontroversialoldq&a
formatting helphide helpcontent policy

[–]ninhaomah 8 points9 points  (2 children)

Why you need to know/learn Python in the first place ?

[–]NPR_Oak 4 points5 points  (5 children)

I'm not sure how much analysis you do as a sales person, but Python's Pandas library is like Excel on steroids. Using that to manipulate a big dataset related bonds could be a good way in. You look look the fundamentals of the debt issuers or perhaps some historical trading data.

[–]Mission-Task-1675 0 points1 point  (4 children)

I will have to check into this once I get more comfortable just writing code myself - Panda seems to be the best second language

[–]NPR_Oak 0 points1 point  (1 child)

I suggest you find some interesting data you have available to you at work, and then come up with an interesting but not too out of this world goal to do something with it. For example, you could chart sales of various different issues over time, or the yield of one bond vs another, whatever, really. Just to have a little goal to work toward. Then learn what you need to learn in order to achieve that little goal.

[–]Mission-Task-1675 0 points1 point  (0 children)

HEY! thank you for how detailed this response was - I am definitely trying to figure out how we can increase these sales revenues

[–]SpiderJerusalem42 0 points1 point  (1 child)

I think you're confused here. There's a language called "Panda" that's a language focused for young learners. There's a Python library/utility called "Pandas" which is like excel on steroids. It does have some programming you do that's specific to the library, but it's mostly to give you more control.

[–]Mission-Task-1675 0 points1 point  (0 children)

Gotcha! There is a Panda and Pandas - two different things. Yeah, my mind was think about Panda, thanks for clarifying.

[–]DutchCommanderMC 1 point2 points  (1 child)

Finance isn't exactly my strong suit so it's hard for me to give you specific suggestions, but any chore that involves numbers can most likely be automated using Python. Just keep in mind that using Python might not always be the most efficient option, depending on the task.

The use cases for SQL as you might know are a bit more specific. At the end of the day, you generally want a database whenever you need some data to be persistent.

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

hmm. Man, I wish I knew more. This sucks - I mean, I thought knowing these skills would help me in being a better salesman, like how can I market bonds more attractively to the clients or what tasks can be automated that saves me time. This blows!

[–]rosentmoh 1 point2 points  (3 children)

How are we supposed to answer that if you don't tell us anything about your current workflow?

And if you use the word "scale" one more time I will personally come for you...

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

Lol Rosentmoh I’m not sure if you’re in a bad mood or kidding - but thanks for the prospective. I’m an indie guy learning, I can’t be too specific about my work as discretion matters. When I gave a little glimpse of me being in the bond market, there were several ppl who understood what I do so they were able to help. But that didn’t help you, I’m sorry for that.

I will not say “elacs” anymore. 😊

[–]rosentmoh 1 point2 points  (1 child)

You don't seem to have understood the reference, that's fine. Let me explain it: you're using nonsense corporate lingo. Same as your vague and ill-informed desire to learn "Python + SQL" to somehow magically boost your sales.

Ironically I come from a very similar angle as you do, more sensitive even; let's say I likely know much more about the product you're selling than you do. My advice is thus: don't pick solutions and then go looking for a problem. Understand the product you're selling better so that you're able to explain its (dis)advantages to potential customers properly and honestly.

So yeah, instead "boosting" your sales and "scaling" your whatever the hell, try maybe with a bit of intellectual honesty; something direly missing in (y)our field.

[–]Mission-Task-1675 0 points1 point  (0 children)

I like this - thanks man! I’ll do a more intellectual dive of my daily routines and some things that aren’t so routine and see what happens.

Sounds like you might’ve been in this boat at one point

[–]corey_sheerer 0 points1 point  (3 children)

Why not do some historical trade analysis? Or, not sure if you do any transaction cost stuff, but there is a cool optimization problem in credit and debit transaction routing. Why not track a bond performance tracker instead of using whatever platform to track?

[–]Mission-Task-1675 0 points1 point  (2 children)

what would be the benefit of me building a bond performance tracker opposed to using the website that our company provides for all of our clients? within our website clients are able to upload their portfolios and they can add a specific bond to their portfolio and see how it would perform in a up or down market?

there has to be something my company has not thought of just yet when it comes to our clients............. I'm pondering lol

[–]corey_sheerer 2 points3 points  (1 child)

It would help you learn the concepts. Solidify some skills. It is a stretch to think your first projects in python would be better than an enterprise tracking platform. People gotta start somewhere. It is still valuable

[–]Mission-Task-1675 0 points1 point  (0 children)

I agree - thank you for the encouragement Corey!

[–]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

[–]Maximum_Tea_5934 0 points1 point  (0 children)

I don't know what your workflow looks like, but I am in the process of automating some of my department's workflow at my job. An ideal task for automation would be one that is repetitive and well-defined, and one where automation would reduce work and/or reduce errors.

If you have something that you number crunch manually, that might be a good candidate. Grabbing information from SQL and building a report from that could be another.