4 ms·
Not sure of the audience for this. If you understand SQL you'd already know most of it... The rest use Excel because that's what they understand. In this case
by jwilliams 13y ago
Not sure of the audience for this. If you understand SQL you'd already know most of it... The rest use Excel because that's what they understand.
In this case you have someone that understands SQL and Python, but still wants to use a spreadsheet. Applying the predicates at the start, this person should dump Excel entirely - they can get much better integrity using SQL and Python alone.
- gizzlon 13y agoThe person using Excel doesn't have to be the person writing the sql :) This could we useful to integrate Excel sheets & data with other systems without too much manual intervention.
- regularfry 13y agoThere are many, many organisations which use Excel sheets as de facto standard interfaces, or "applications" you have to use, because it's the only common tool the people with the domain knowledge have access to and are trained in, and sharing them is trivial - just email a .xlsx. I've seen government regulators supply template Excel sheets as the mandated standard by which private companies must, legally, submit data. Being able to interact with those spreadsheets in a sensible language with a front-end that doesn't suck would be huge.