How to Create a Delimited Field in your SQLite Query with Python
In this episode, we’re going to use our Python SQLite database, and we’ll use the group_concat function to take many entries in a field, and put them into a delimited list in our aggregate query. This kind of function is extremely handy for SQL report writing, ad-hoc queries, data science, and other work that you might do with your data.
Join me on Patreon!
https://www.patreon.com/mackenziedataengineering
Want the code from this video?
http://mackenziemackenzie.com/downloads
For developers looking for a new role, check out and sign up:
https://www.toptal.com/qKaO2b/worlds-top-talent
Needing to hire technical resources for your project? Get the best:
https://www.toptal.com/qKaO2b/worlds-top-talent
Contact form you can find at http://www.mackenziemackenzie.com/
Follow me on social media:
https://www.facebook.com/mackenziedataanalytics
https://twitter.com/seamacke
https://www.instagram.com/seamacke/
https://www.reddit.com/user/seamacke
https://www.linkedin.com/in/psmackenzie/
Get Microsoft Office including Access:
https://click.linksynergy.com/fs-bin/click?id=BdGJecFFM8A&offerid=1160033.10004289&type=3&subid=0
Got a YouTube Channel? I use TubeBuddy, it is awesome. Give it a try:
https://www.tubebuddy.com/seanmackenziedataengineering
#python #sqlite #dataengineering
Comments are closed.