fork download
  1. import sys
  2. import csv
  3. import sqlite3
  4. import fileinput
  5.  
  6. con = sqlite3.connect(':memory:')
  7. cur = con.cursor()
  8.  
  9. cur.execute('''
  10. CREATE TABLE courses (
  11. id integer primary key AUTOINCREMENT,
  12. title varchar(200),
  13. author varchar(200),
  14. lessons varchar(200),
  15. ctime varchar(200)
  16. );
  17. ''')
  18.  
  19. cur.execute('''
  20. CREATE TABLE tags (
  21. id integer primary key AUTOINCREMENT,
  22. tag varchar(200)
  23. );
  24. ''')
  25.  
  26. cur.execute('''
  27. CREATE TABLE courses_tags (
  28. id integer primary key AUTOINCREMENT,
  29. course_id varchar(200),
  30. tag_id varchar(200)
  31. );
  32. ''')
  33.  
  34. alltags = {}
  35. with fileinput.input() as csvfile:
  36. reader = csv.reader(csvfile)
  37. for row in reader:
  38. *rec, tags = row
  39. cur.execute("insert into courses(title, author, lessons, ctime) values (?, ?, ?, ?)", rec)
  40. course_id = cur.lastrowid
  41. taglist = tags.split(', ')
  42. for tag in taglist:
  43. if tag not in alltags:
  44. cur.execute("INSERT INTO tags(tag) VALUES (?)", (tag, ))
  45. alltags[tag] = cur.lastrowid
  46. cur.execute("INSERT INTO courses_tags(course_id, tag_id) VALUES (?, ?)", (course_id, alltags[tag]))
  47. con.commit()
  48. qr = '''
  49. SELECT courses.id, courses.title , GROUP_CONCAT(tags.tag) as tags FROM courses
  50. JOIN courses_tags ct on courses.id = ct.course_id
  51. JOIN tags on tags.id = ct.tag_id GROUP BY courses.id;
  52. '''
  53. cur.execute(qr)
  54. for row in cur:
  55. print(row)
  56.  
  57. con.close()
Success #stdin #stdout 0.04s 11644KB
stdin
Using the Python not Operator,Howard Francis,14 Lessons,30m,"basics, python"
SQLite and SQLAlchemy in Python: Moving Your Data Beyond Flat Files,Christopher Trudeau,8 Lessons,1h 11m,"databases, intermediate, web-dev"
Using the Python and Operator,Howard Francis,15 Lessons,36m,"basics, best-practices, python"
Building a Site Connectivity Checker,Darren Jones,10 Lessons,41m,"intermediate, projects, python"
Python mmap: Doing File I/O With Memory Mapping,Christopher Trudeau,6 Lessons,41m,"intermediate, python"
Combining Data in pandas With concat() and merge(),Martin Breuss,20 Lessons,1h 34m,"data-science, intermediate"
Write and Test a Python Function: Interview Practice,Real Python Team,8 Lessons,54m,testing
Data Cleaning With pandas and NumPy,Ian Currie,16 Lessons,1h 28m,"data-science, intermediate"
Exploring Scopes and Closures in Python,Martin Breuss,5 Lessons,28m,"community, intermediate, python"
Using Python Class Constructors,Darren Jones,11 Lessons,36m,"intermediate, python"
Deploying a Flask Application Using Heroku,Darren Jones,6 Lessons,28m,"devops, flask, intermediate, web-dev"
Testing Your Code With pytest,Christopher Trudeau,5 Lessons,25m,"intermediate, python, testing"
Building a Django User Management System,Darren Jones,13 Lessons,42m,"django, intermediate"
Exploring Keywords in Python,Philipp Acsany,7 Lessons,30m,"basics, python"
Python REST APIs With FastAPI,Douglas Starnes,9 Lessons,37m,"api, basics, web-dev"
Using Python's datetime Module,Christopher Trudeau,6 Lessons,35m,intermediate
Python Basics: Code Your First Python Program,Christopher Bailey,6 Lessons,33m,"basics, python"
Sorting Data in Python With Pandas,Darren Jones,9 Lessons,26m,"data-science, intermediate"
Counting With Python's Counter,Christopher Trudeau,7 Lessons,36m,"basics, python"
Exploring the Fibonacci Sequence With Python,Darren Jones,11 Lessons,23m,"intermediate, python"
Starting With Linear Regression in Python,Cesar Aguilar,9 Lessons,46m,"data-science, intermediate, machine-learning"
Python any(): Powered Up Boolean Function,Ian Currie,9 Lessons,36m,"basics, python"
Defining Python Functions With Optional Arguments,Darren Jones,13 Lessons,34m,"basics, python"
Python's len() Function,Christopher Trudeau,6 Lessons,24m,"basics, python"
Looping With Python enumerate(),Philipp Acsany,7 Lessons,28m,"basics, best-practices"
Starting With Python IDLE,Darren Jones,8 Lessons,25m,"basics, python"
Working With Pipenv,Christopher Trudeau,5 Lessons,35m,"intermediate, tools"
Deploy Your Python Script on the Web With Flask,Darren Jones,11 Lessons,56m,"devops, flask, intermediate, web-dev"
Raising and Handling Python Exceptions,Martin Breuss,9 Lessons,33m,"basics, python"
Host Your Django Project on Heroku,Bartosz Zaczyński,14 Lessons,45m,"devops, django, intermediate, python, web-dev"
"Binary, Bytes, and Bitwise Operators in Python",Christopher Trudeau,12 Lessons,1h 39m,"intermediate, python"
Data Visualization Interfaces in Python With Dash,Darren Jones,13 Lessons,51m,"data-science, intermediate"
Building a Neural Network & Making Predictions With Python AI,Douglas Starnes,8 Lessons,25m,"data-science, intermediate, machine-learning"
Building Lists With Python's .append(),Howard Francis,11 Lessons,40m,"basics, python"
Using plt.scatter() to Visualize Data in Python,Darren Jones,11 Lessons,31m,intermediate
Reading Input and Writing Output in Python,Martin Breuss,6 Lessons,15m,"basics, python"
Writing Idiomatic Python,Martin Breuss,10 Lessons,22m,"basics, best-practices, python"
Python Assignment Expressions and Using the Walrus Operator,Darren Jones,13 Lessons,47m,"best-practices, intermediate"
Using Pygame to Build an Asteroids Game in Python,Christopher Trudeau,14 Lessons,1h 24m,"gamedev, intermediate, projects"
Cool New Features in Python 3.10,Christopher Trudeau,9 Lessons,58m,"intermediate, python"
"Rock, Paper, Scissors With Python: A Command Line Game",Christopher Trudeau,5 Lessons,26m,"basics, gamedev, python"
Pass by Reference in Python: Best Practices,Howard Francis,16 Lessons,1h 17m,"best-practices, intermediate, python"
Using Data Classes in Python,Darren Jones,12 Lessons,45m,"intermediate, python"
Graph Your Data With Python and ggplot,Martin Breuss,18 Lessons,59m,"data-science, intermediate"
Splitting Datasets With scikit-learn and train_test_split(),Darren Jones,11 Lessons,29m,"data-science, intermediate, machine-learning"
Exploring the Python math Module,Cesar Aguilar,16 Lessons,1h 20m,"intermediate, python"
Reading and Writing Files With Pandas,Darren Jones,19 Lessons,49m,"databases, data-science, intermediate"
Using the Python return Statement Effectively,Howard Francis,21 Lessons,1h 26m,"basics, best-practices, python"
Using sleep() to Code a Python Uptime Bot,Martin Breuss,8 Lessons,22m,"intermediate, python"
The Pandas DataFrame: Working With Data Efficiently,Cesar Aguilar,25 Lessons,2h 10m,"data-science, intermediate"
Speech Recognition With Python,Darren Jones,11 Lessons,38m,"advanced, data-science, machine-learning"
The Square Root Function in Python,Christopher Trudeau,5 Lessons,19m,basics
Defining and Calling Python Functions,Howard Francis,27 Lessons,2h 23m,"basics, python"
Python Inner Functions,Christopher Trudeau,6 Lessons,37m,"intermediate, python"
Python vs JavaScript for Python Developers,Christopher Trudeau,13 Lessons,1h 56m,"front-end, intermediate, python"
Using Pandas to Make a Gradebook in Python,Cesar Aguilar,13 Lessons,1h 37m,"advanced, data-science, projects"
Python Basics: Setting Up Python,David Amos,5 Lessons,25m,"basics, python"
Explore Your Dataset With Pandas,Douglas Starnes,14 Lessons,47m,"basics, data-science"
How to Set Up a Django Project,Martin Breuss,10 Lessons,32m,"basics, best-practices, django, web-dev"
Using the Python or Operator,Howard Francis,20 Lessons,1h,"basics, python"
Stacks and Queues: Selecting the Ideal Data Structure,Christopher Trudeau,10 Lessons,40m,"basics, python"
Simplify Python GUI Development With PySimpleGUI,Darren Jones,9 Lessons,35m,"gui, intermediate"
Python's map() Function: Transforming Iterables,Cesar Aguilar,9 Lessons,1h 17m,"basics, best-practices, python"
Learn Text Classification With Python and Keras,Douglas Starnes,10 Lessons,36m,"advanced, data-science, machine-learning"
Start Managing Multiple Python Versions With pyenv,Johan Vergeer,14 Lessons,40m,"advanced, tools"
Python vs Java: Object Oriented Programming,Howard Francis,16 Lessons,1h 17m,"intermediate, python"
Understanding Python List Comprehensions,Rich Bibby,5 Lessons,18m,"basics, python"
Records and Sets: Selecting the Ideal Data Structure,Christopher Trudeau,5 Lessons,34m,"basics, python"
Python Booleans: Leveraging the Values of Truth,Cesar Aguilar,9 Lessons,1h 9m,intermediate
Django View Authorization: Restricting Access,Darren Jones,8 Lessons,32m,"django, intermediate, web-dev"
Navigating Namespaces and Scope in Python,Johan Vergeer,11 Lessons,27m,"basics, python"
Dictionaries and Arrays: Selecting the Ideal Data Structure,Christopher Trudeau,9 Lessons,50m,"basics, python"
Creating PyQt Layouts for GUI Applications,Christian Koch,12 Lessons,1h 9m,"gui, intermediate"
Python Modulo: Using the % Operator,Christopher Trudeau,6 Lessons,33m,"basics, python"
Plot With Pandas: Python Data Visualization Basics,Darren Jones,9 Lessons,28m,"data-science, intermediate"
Evaluate Expressions Dynamically With Python eval(),Christopher Trudeau,8 Lessons,49m,"intermediate, python"
Introduction to Sorting Algorithms in Python,Liam Pulsifer,9 Lessons,1h 3m,"intermediate, python"
Managing Python Dependencies,Dan Bader,37 Lessons,1h 59m,"best-practices, intermediate"
Building HTTP APIs With Django REST Framework,Christopher Trudeau,13 Lessons,2h 10m,"advanced, api, django, web-dev"
Django Admin Customization,Darren Jones,11 Lessons,29m,"advanced, django, web-dev"
Serializing Objects With the Python pickle Module,Joe Tatusko,9 Lessons,28m,"intermediate, python"
Python Turtle for Beginners,Darren Jones,10 Lessons,37m,"basics, python"
Speed Up Python With Concurrency,Christopher Trudeau,9 Lessons,1h 12m,"advanced, best-practices"
How Python Manages Memory,Austin Cepalia,10 Lessons,27m,"intermediate, python"
Formatting Python Strings,Liam Pulsifer,7 Lessons,32m,"basics, python"
Regular Expressions and Building Regexes in Python,Christopher Trudeau,14 Lessons,1h 53m,"basics, python"
Handling Missing Keys With the Python defaultdict Type,Christian Mondorf,7 Lessons,43m,"basics, python"
Simulating Real-World Processes in Python With SimPy,Joe Tatusko,11 Lessons,27m,"data-science, intermediate, tools"
Creating a Binary Search in Python,Liam Pulsifer,8 Lessons,45m,"intermediate, python"
Getting Started With MicroPython,Darren Jones,10 Lessons,55m,"intermediate, python"
Web Scraping With Beautiful Soup and Python,Martin Breuss,24 Lessons,1h 39m,"data-science, intermediate, tools, web-scraping"
Cool New Features in Python 3.9,Christopher Trudeau,10 Lessons,55m,"intermediate, python"
Using Google Login With Flask,Douglas Starnes,8 Lessons,21m,"flask, intermediate, web-dev"
Working With Linked Lists in Python,Austin Cepalia,15 Lessons,53m,"intermediate, python"
Command Line Interfaces in Python,Liam Pulsifer,19 Lessons,1h 29m,"best-practices, intermediate, tools"
Exploring HTTPS and Cryptography in Python,Christopher Trudeau,9 Lessons,1h 28m,"intermediate, web-dev"
Editing Excel Spreadsheets in Python With openpyxl,Joe Tatusko,16 Lessons,1h 13m,intermediate
Django Redirects,Christopher Trudeau,7 Lessons,37m,"django, intermediate, web-dev"
Office Hours Archive,David Amos,51 Lessons,55h 38m,community
Identify Invalid Python Syntax,Darren Jones,12 Lessons,25m,"basics, python"
Practical Recipes for Working With Files in Python,Liam Pulsifer,13 Lessons,1h 13m,"basics, python"
Python's None: Null in Python,Christian Mondorf,5 Lessons,20m,"basics, python"
Mastering Python's Built-in time Module,Liam Pulsifer,7 Lessons,39m,intermediate
Grow Your Python Portfolio With 13 Intermediate Project Ideas,Darren Jones,22 Lessons,1h 9m,"gui, intermediate, projects, web-dev"
Pointers and Objects in Python,Austin Cepalia,12 Lessons,47m,"intermediate, python"
Unicode in Python: Working With Character Encodings,Christopher Trudeau,9 Lessons,51m,"advanced, best-practices, python"
Creating a Discord Bot in Python,Andrew Stephen,14 Lessons,52m,"api, intermediate, projects"
Python Generators 101,Christian Mondorf,5 Lessons,31m,"intermediate, python"
Getting the Most Out of a Python Traceback,Rich Bibby,5 Lessons,21m,"basics, python"
Parallel Iteration With Python's zip() Function,Liam Pulsifer,6 Lessons,35m,"basics, python"
A Beginner's Guide to Pip,Austin Cepalia,10 Lessons,34m,"basics, tools"
Convert a Python String to int,Darren Jones,5 Lessons,9m,"basics, python"
Improve Your Tests With the Python Mock Object Library,Lee Gaines,31 Lessons,1h 29m,"intermediate, testing"
The Python print() Function: Go Beyond the Basics,Christopher Trudeau,12 Lessons,57m,"basics, python"
Structuring a Python Application,Christopher Trudeau,6 Lessons,35m,"basics, best-practices, python"
Python Coding Interviews: Tips & Best Practices,James Uejio,22 Lessons,2h 21m,best-practices
Inheritance and Composition: A Python OOP Guide,Austin Cepalia,22 Lessons,2h 46m,"best-practices, intermediate, python"
Arduino With Python: How to Get Started,Christopher Bailey,9 Lessons,1h 6m,"intermediate, python"
"Comparing Python Objects the Right Way: ""is"" vs ""==""",Liam Pulsifer,5 Lessons,28m,"best-practices, intermediate, python"
Using NumPy's np.arange() Effectively,Liam Pulsifer,6 Lessons,28m,"data-science, intermediate"
Make a 2D Side-Scroller Game With PyGame,Christopher Bailey,24 Lessons,1h 48m,"gamedev, intermediate, projects"
Defining Main Functions in Python,Rich Bibby,4 Lessons,18m,"best-practices, intermediate"
How to Implement a Python Stack,Liam Pulsifer,4 Lessons,20m,"basics, python"
How to Work With a PDF in Python,Andrew Stephen,6 Lessons,31m,intermediate
Finding the Perfect Python Code Editor,Martin Breuss,36 Lessons,2h 28m,"basics, tools"
Playing and Recording Sound in Python,Joe Tatusko,16 Lessons,40m,"basics, python"
Sets in Python,James Uejio,15 Lessons,47m,"basics, python"
Python Modules and Packages: An Introduction,Christopher Bailey,12 Lessons,1h 2m,"basics, python"
Basic Data Types in Python,Darren Jones,18 Lessons,1h 27m,"basics, python"
Supercharge Your Classes With Python super(),Christopher Trudeau,3 Lessons,23m,"best-practices, intermediate, python"
Python args and kwargs: Demystified,Rich Bibby,6 Lessons,12m,"intermediate, python"
Sorting Data With Python,Joe Tatusko,9 Lessons,33m,"basics, python"
Python Dictionary Iteration: Advanced Tips & Tricks,Liam Pulsifer,9 Lessons,47m,"intermediate, python"
Documenting Python Code: A Complete Guide,Andrew Stephen,7 Lessons,32m,"best-practices, intermediate, python"
Variables in Python,Martin Breuss,11 Lessons,41m,"basics, python"
"Python, Boto3, and AWS S3: Demystified",Joe Tatusko,16 Lessons,1h 9m,"devops, intermediate"
Python KeyError Exceptions and How to Handle Them,Rich Bibby,5 Lessons,10m,"basics, python"
Threading in Python,Lee Gaines,19 Lessons,1h 30m,"best-practices, intermediate"
Thinking Recursively in Python,James Uejio,6 Lessons,24m,"intermediate, python"
Cool New Features in Python 3.8,Christopher Bailey,11 Lessons,57m,"intermediate, python"
Python Type Checking,Christopher Bailey,10 Lessons,55m,"best-practices, intermediate"
Python Plotting With Matplotlib,Austin Cepalia,14 Lessons,1h 14m,"basics, data-science"
The Python range() Function,Austin Cepalia,7 Lessons,22m,"basics, python"
Get Started With Django: Build a Portfolio App,Martin Breuss,45 Lessons,3h 44m,"basics, django, projects, web-dev"
Strings and Character Data in Python,Christopher Bailey,19 Lessons,1h 48m,"basics, python"
Thonny: The Beginner-Friendly Python Editor,Darren Jones,9 Lessons,34m,"basics, tools"
Python Debugging With pdb,Austin Cepalia,11 Lessons,36m,"intermediate, python, tools"
Absolute vs Relative Imports in Python,Joe Tatusko,4 Lessons,16m,"best-practices, intermediate, python"
Lists and Tuples in Python,Christopher Bailey,11 Lessons,1h 1m,"basics, python"
How to Use Python Lambda Functions,Darren Jones,10 Lessons,34m,"best-practices, intermediate, python"
"Python Histogram Plotting: NumPy, Matplotlib, Pandas & Seaborn",Joe Tatusko,8 Lessons,39m,"basics, data-science"
Traditional Face Detection With Python,Austin Cepalia,11 Lessons,29m,"data-science, intermediate, machine-learning"
11 Beginner Tips for Learning Python,Darren Jones,13 Lessons,37m,"basics, python"
Dictionaries in Python,Paul Mealus,4 Lessons,20m,"basics, python"
Logging in Python,Austin Cepalia,11 Lessons,26m,"intermediate, tools"
How to Write Pythonic Loops,Dan Bader,6 Lessons,9m,"basics, best-practices, python"
Reading and Writing Files in Python,Darren Jones,9 Lessons,30m,"intermediate, python"
Functional Programming in Python,Dan Bader,32 Lessons,1h 25m,"advanced, python"
Generating Random Data in Python,Jackie Wilson,4 Lessons,26m,"data-science, intermediate, python"
How to Publish Your Own Python Package to PyPI,Joe Tatusko,10 Lessons,29m,"best-practices, intermediate, tools"
OOP Method Types in Python: @classmethod vs @staticmethod vs Instance Methods,Dan Bader,7 Lessons,14m,"intermediate, python"
Introduction to Git and GitHub for Python Developers,Paul Mealus,9 Lessons,37m,"intermediate, tools"
Continuous Integration With Python,Joe Tatusko,6 Lessons,21m,"best-practices, devops, intermediate, testing"
Interactive Data Visualization in Python With Bokeh,Christopher Bailey,26 Lessons,2h 7m,"data-science, intermediate"
"Installing Python on Windows, macOS, and Linux",Darren Jones,8 Lessons,10m,"basics, python"
Writing Cleaner Python Code With PyLint,Dan Bader,8 Lessons,17m,"intermediate, python"
"Python Context Managers and the ""with"" Statement",Dan Bader,6 Lessons,12m,"intermediate, python"
Make a Location-Based Web App With Django and GeoDjango,Jackie Wilson,11 Lessons,56m,"django, intermediate, web-dev"
Conditional Statements in Python (if/elif/else),Paul Mealus,6 Lessons,21m,"basics, python"
Sending Emails With Python,Joe Tatusko,8 Lessons,35m,"intermediate, web-dev"
Immutability in Python,Dan Bader,5 Lessons,9m,"intermediate, python"
Hands-On Python 3 Concurrency With the asyncio Module,Chyld Medford,12 Lessons,1h 3m,"advanced, python"
Python String Formatting Tips & Best Practices,Paul Mealus,6 Lessons,16m,"basics, best-practices, python"
Running Python Scripts,Darren Jones,7 Lessons,18m,"basics, python"
Python Development in Visual Studio Code (Setup Guide),Austin Cepalia,6 Lessons,29m,"intermediate, tools"
Idiomatic Pandas: Tricks & Features You May Not Know,Joe Tatusko,11 Lessons,47m,"data-science, intermediate"
Working With JSON Data in Python,Austin Cepalia,7 Lessons,36m,"intermediate, python"
Django Migrations 101,Darren Jones,8 Lessons,13m,"intermediate, web-dev"
Documenting Python Projects With Sphinx and Read The Docs,Mahdi Yusuf,6 Lessons,17m,"best-practices, intermediate"
Intro to Object-Oriented Programming (OOP) in Python,Austin Cepalia,7 Lessons,40m,"intermediate, python"
Python Decorators 101,Christopher Bailey,20 Lessons,1h 7m,"intermediate, python"
Writing Comments in Python,Jackie Wilson,4 Lessons,13m,"basics, best-practices, python"
Making HTTP Requests With Python,Christopher Bailey,17 Lessons,49m,"intermediate, web-dev"
Introduction to Python Exceptions,Darren Jones,3 Lessons,13m,"basics, python"
Writing Beautiful Pythonic Code With PEP 8,Joe Tatusko,8 Lessons,39m,"best-practices, intermediate, python"
Python 3's f-Strings: An Improved String Formatting Syntax,Christopher Bailey,8 Lessons,22m,"basics, python"
Idiomatic Python 101,Mahdi Yusuf,8 Lessons,9m,"basics, best-practices, python"
Pythonic OOP String Conversion: __repr__ vs __str__,Dan Bader,7 Lessons,13m,"intermediate, python"
Test-Driven Development With PyTest,Chyld Medford,6 Lessons,29m,"intermediate, python, testing"
Pandas DataFrames 101,Mahdi Yusuf,5 Lessons,18m,"basics, data-science"
Emulating switch/case Statements in Python,Dan Bader,4 Lessons,10m,"intermediate, python"
Migrating Applications From Python 2 to Python 3,Mahdi Yusuf,5 Lessons,16m,"advanced, python"
@staticmethod vs @classmethod in Python,Mahdi Yusuf,5 Lessons,14m,"intermediate, python"
"Splitting, Concatenating, and Joining Strings in Python",Jackie Wilson,4 Lessons,18m,"basics, python"
Mastering While Loops,Katy Gibson,11 Lessons,26m,"basics, python"
Using List Comprehensions Effectively,Dan Bader,8 Lessons,13m,"intermediate, python"
Reading and Writing CSV Files,Joe Tatusko,6 Lessons,21m,"data-science, intermediate, python"
Using Jupyter Notebooks,Martin Breuss,9 Lessons,36m,"intermediate, tools"
Python Imports 101,Mahdi Yusuf,5 Lessons,14m,"basics, python"
For Loops in Python (Definite Iteration),Darren Jones,4 Lessons,16m,"basics, python"
Working With Python Virtual Environments,Dan Bader,6 Lessons,8m,"basics, tools"
Welcome to Real Python!,Dan Bader,18 Lessons,46m,"basics, community"
stdout
(1, 'Using the Python not Operator', 'basics,python')
(2, 'SQLite and SQLAlchemy in Python: Moving Your Data Beyond Flat Files', 'databases,intermediate,web-dev')
(3, 'Using the Python and Operator', 'basics,best-practices,python')
(4, 'Building a Site Connectivity Checker', 'intermediate,projects,python')
(5, 'Python mmap: Doing File I/O With Memory Mapping', 'intermediate,python')
(6, 'Combining Data in pandas With concat() and merge()', 'data-science,intermediate')
(7, 'Write and Test a Python Function: Interview Practice', 'testing')
(8, 'Data Cleaning With pandas and NumPy', 'data-science,intermediate')
(9, 'Exploring Scopes and Closures in Python', 'community,intermediate,python')
(10, 'Using Python Class Constructors', 'intermediate,python')
(11, 'Deploying a Flask Application Using Heroku', 'devops,flask,intermediate,web-dev')
(12, 'Testing Your Code With pytest', 'intermediate,python,testing')
(13, 'Building a Django User Management System', 'django,intermediate')
(14, 'Exploring Keywords in Python', 'basics,python')
(15, 'Python REST APIs With FastAPI', 'api,basics,web-dev')
(16, "Using Python's datetime Module", 'intermediate')
(17, 'Python Basics: Code Your First Python Program', 'basics,python')
(18, 'Sorting Data in Python With Pandas', 'data-science,intermediate')
(19, "Counting With Python's Counter", 'basics,python')
(20, 'Exploring the Fibonacci Sequence With Python', 'intermediate,python')
(21, 'Starting With Linear Regression in Python', 'data-science,intermediate,machine-learning')
(22, 'Python any(): Powered Up Boolean Function', 'basics,python')
(23, 'Defining Python Functions With Optional Arguments', 'basics,python')
(24, "Python's len() Function", 'basics,python')
(25, 'Looping With Python enumerate()', 'basics,best-practices')
(26, 'Starting With Python IDLE', 'basics,python')
(27, 'Working With Pipenv', 'intermediate,tools')
(28, 'Deploy Your Python Script on the Web With Flask', 'devops,flask,intermediate,web-dev')
(29, 'Raising and Handling Python Exceptions', 'basics,python')
(30, 'Host Your Django Project on Heroku', 'devops,django,intermediate,python,web-dev')
(31, 'Binary, Bytes, and Bitwise Operators in Python', 'intermediate,python')
(32, 'Data Visualization Interfaces in Python With Dash', 'data-science,intermediate')
(33, 'Building a Neural Network & Making Predictions With Python AI', 'data-science,intermediate,machine-learning')
(34, "Building Lists With Python's .append()", 'basics,python')
(35, 'Using plt.scatter() to Visualize Data in Python', 'intermediate')
(36, 'Reading Input and Writing Output in Python', 'basics,python')
(37, 'Writing Idiomatic Python', 'basics,best-practices,python')
(38, 'Python Assignment Expressions and Using the Walrus Operator', 'best-practices,intermediate')
(39, 'Using Pygame to Build an Asteroids Game in Python', 'gamedev,intermediate,projects')
(40, 'Cool New Features in Python 3.10', 'intermediate,python')
(41, 'Rock, Paper, Scissors With Python: A Command Line Game', 'basics,gamedev,python')
(42, 'Pass by Reference in Python: Best Practices', 'best-practices,intermediate,python')
(43, 'Using Data Classes in Python', 'intermediate,python')
(44, 'Graph Your Data With Python and ggplot', 'data-science,intermediate')
(45, 'Splitting Datasets With scikit-learn and train_test_split()', 'data-science,intermediate,machine-learning')
(46, 'Exploring the Python math Module', 'intermediate,python')
(47, 'Reading and Writing Files With Pandas', 'databases,data-science,intermediate')
(48, 'Using the Python return Statement Effectively', 'basics,best-practices,python')
(49, 'Using sleep() to Code a Python Uptime Bot', 'intermediate,python')
(50, 'The Pandas DataFrame: Working With Data Efficiently', 'data-science,intermediate')
(51, 'Speech Recognition With Python', 'advanced,data-science,machine-learning')
(52, 'The Square Root Function in Python', 'basics')
(53, 'Defining and Calling Python Functions', 'basics,python')
(54, 'Python Inner Functions', 'intermediate,python')
(55, 'Python vs JavaScript for Python Developers', 'front-end,intermediate,python')
(56, 'Using Pandas to Make a Gradebook in Python', 'advanced,data-science,projects')
(57, 'Python Basics: Setting Up Python', 'basics,python')
(58, 'Explore Your Dataset With Pandas', 'basics,data-science')
(59, 'How to Set Up a Django Project', 'basics,best-practices,django,web-dev')
(60, 'Using the Python or Operator', 'basics,python')
(61, 'Stacks and Queues: Selecting the Ideal Data Structure', 'basics,python')
(62, 'Simplify Python GUI Development With PySimpleGUI', 'gui,intermediate')
(63, "Python's map() Function: Transforming Iterables", 'basics,best-practices,python')
(64, 'Learn Text Classification With Python and Keras', 'advanced,data-science,machine-learning')
(65, 'Start Managing Multiple Python Versions With pyenv', 'advanced,tools')
(66, 'Python vs Java: Object Oriented Programming', 'intermediate,python')
(67, 'Understanding Python List Comprehensions', 'basics,python')
(68, 'Records and Sets: Selecting the Ideal Data Structure', 'basics,python')
(69, 'Python Booleans: Leveraging the Values of Truth', 'intermediate')
(70, 'Django View Authorization: Restricting Access', 'django,intermediate,web-dev')
(71, 'Navigating Namespaces and Scope in Python', 'basics,python')
(72, 'Dictionaries and Arrays: Selecting the Ideal Data Structure', 'basics,python')
(73, 'Creating PyQt Layouts for GUI Applications', 'gui,intermediate')
(74, 'Python Modulo: Using the % Operator', 'basics,python')
(75, 'Plot With Pandas: Python Data Visualization Basics', 'data-science,intermediate')
(76, 'Evaluate Expressions Dynamically With Python eval()', 'intermediate,python')
(77, 'Introduction to Sorting Algorithms in Python', 'intermediate,python')
(78, 'Managing Python Dependencies', 'best-practices,intermediate')
(79, 'Building HTTP APIs With Django REST Framework', 'advanced,api,django,web-dev')
(80, 'Django Admin Customization', 'advanced,django,web-dev')
(81, 'Serializing Objects With the Python pickle Module', 'intermediate,python')
(82, 'Python Turtle for Beginners', 'basics,python')
(83, 'Speed Up Python With Concurrency', 'advanced,best-practices')
(84, 'How Python Manages Memory', 'intermediate,python')
(85, 'Formatting Python Strings', 'basics,python')
(86, 'Regular Expressions and Building Regexes in Python', 'basics,python')
(87, 'Handling Missing Keys With the Python defaultdict Type', 'basics,python')
(88, 'Simulating Real-World Processes in Python With SimPy', 'data-science,intermediate,tools')
(89, 'Creating a Binary Search in Python', 'intermediate,python')
(90, 'Getting Started With MicroPython', 'intermediate,python')
(91, 'Web Scraping With Beautiful Soup and Python', 'data-science,intermediate,tools,web-scraping')
(92, 'Cool New Features in Python 3.9', 'intermediate,python')
(93, 'Using Google Login With Flask', 'flask,intermediate,web-dev')
(94, 'Working With Linked Lists in Python', 'intermediate,python')
(95, 'Command Line Interfaces in Python', 'best-practices,intermediate,tools')
(96, 'Exploring HTTPS and Cryptography in Python', 'intermediate,web-dev')
(97, 'Editing Excel Spreadsheets in Python With openpyxl', 'intermediate')
(98, 'Django Redirects', 'django,intermediate,web-dev')
(99, 'Office Hours Archive', 'community')
(100, 'Identify Invalid Python Syntax', 'basics,python')
(101, 'Practical Recipes for Working With Files in Python', 'basics,python')
(102, "Python's None: Null in Python", 'basics,python')
(103, "Mastering Python's Built-in time Module", 'intermediate')
(104, 'Grow Your Python Portfolio With 13 Intermediate Project Ideas', 'gui,intermediate,projects,web-dev')
(105, 'Pointers and Objects in Python', 'intermediate,python')
(106, 'Unicode in Python: Working With Character Encodings', 'advanced,best-practices,python')
(107, 'Creating a Discord Bot in Python', 'api,intermediate,projects')
(108, 'Python Generators 101', 'intermediate,python')
(109, 'Getting the Most Out of a Python Traceback', 'basics,python')
(110, "Parallel Iteration With Python's zip() Function", 'basics,python')
(111, "A Beginner's Guide to Pip", 'basics,tools')
(112, 'Convert a Python String to int', 'basics,python')
(113, 'Improve Your Tests With the Python Mock Object Library', 'intermediate,testing')
(114, 'The Python print() Function: Go Beyond the Basics', 'basics,python')
(115, 'Structuring a Python Application', 'basics,best-practices,python')
(116, 'Python Coding Interviews: Tips & Best Practices', 'best-practices')
(117, 'Inheritance and Composition: A Python OOP Guide', 'best-practices,intermediate,python')
(118, 'Arduino With Python: How to Get Started', 'intermediate,python')
(119, 'Comparing Python Objects the Right Way: "is" vs "=="', 'best-practices,intermediate,python')
(120, "Using NumPy's np.arange() Effectively", 'data-science,intermediate')
(121, 'Make a 2D Side-Scroller Game With PyGame', 'gamedev,intermediate,projects')
(122, 'Defining Main Functions in Python', 'best-practices,intermediate')
(123, 'How to Implement a Python Stack', 'basics,python')
(124, 'How to Work With a PDF in Python', 'intermediate')
(125, 'Finding the Perfect Python Code Editor', 'basics,tools')
(126, 'Playing and Recording Sound in Python', 'basics,python')
(127, 'Sets in Python', 'basics,python')
(128, 'Python Modules and Packages: An Introduction', 'basics,python')
(129, 'Basic Data Types in Python', 'basics,python')
(130, 'Supercharge Your Classes With Python super()', 'best-practices,intermediate,python')
(131, 'Python args and kwargs: Demystified', 'intermediate,python')
(132, 'Sorting Data With Python', 'basics,python')
(133, 'Python Dictionary Iteration: Advanced Tips & Tricks', 'intermediate,python')
(134, 'Documenting Python Code: A Complete Guide', 'best-practices,intermediate,python')
(135, 'Variables in Python', 'basics,python')
(136, 'Python, Boto3, and AWS S3: Demystified', 'devops,intermediate')
(137, 'Python KeyError Exceptions and How to Handle Them', 'basics,python')
(138, 'Threading in Python', 'best-practices,intermediate')
(139, 'Thinking Recursively in Python', 'intermediate,python')
(140, 'Cool New Features in Python 3.8', 'intermediate,python')
(141, 'Python Type Checking', 'best-practices,intermediate')
(142, 'Python Plotting With Matplotlib', 'basics,data-science')
(143, 'The Python range() Function', 'basics,python')
(144, 'Get Started With Django: Build a Portfolio App', 'basics,django,projects,web-dev')
(145, 'Strings and Character Data in Python', 'basics,python')
(146, 'Thonny: The Beginner-Friendly Python Editor', 'basics,tools')
(147, 'Python Debugging With pdb', 'intermediate,python,tools')
(148, 'Absolute vs Relative Imports in Python', 'best-practices,intermediate,python')
(149, 'Lists and Tuples in Python', 'basics,python')
(150, 'How to Use Python Lambda Functions', 'best-practices,intermediate,python')
(151, 'Python Histogram Plotting: NumPy, Matplotlib, Pandas & Seaborn', 'basics,data-science')
(152, 'Traditional Face Detection With Python', 'data-science,intermediate,machine-learning')
(153, '11 Beginner Tips for Learning Python', 'basics,python')
(154, 'Dictionaries in Python', 'basics,python')
(155, 'Logging in Python', 'intermediate,tools')
(156, 'How to Write Pythonic Loops', 'basics,best-practices,python')
(157, 'Reading and Writing Files in Python', 'intermediate,python')
(158, 'Functional Programming in Python', 'advanced,python')
(159, 'Generating Random Data in Python', 'data-science,intermediate,python')
(160, 'How to Publish Your Own Python Package to PyPI', 'best-practices,intermediate,tools')
(161, 'OOP Method Types in Python: @classmethod vs @staticmethod vs Instance Methods', 'intermediate,python')
(162, 'Introduction to Git and GitHub for Python Developers', 'intermediate,tools')
(163, 'Continuous Integration With Python', 'best-practices,devops,intermediate,testing')
(164, 'Interactive Data Visualization in Python With Bokeh', 'data-science,intermediate')
(165, 'Installing Python on Windows, macOS, and Linux', 'basics,python')
(166, 'Writing Cleaner Python Code With PyLint', 'intermediate,python')
(167, 'Python Context Managers and the "with" Statement', 'intermediate,python')
(168, 'Make a Location-Based Web App With Django and GeoDjango', 'django,intermediate,web-dev')
(169, 'Conditional Statements in Python (if/elif/else)', 'basics,python')
(170, 'Sending Emails With Python', 'intermediate,web-dev')
(171, 'Immutability in Python', 'intermediate,python')
(172, 'Hands-On Python 3 Concurrency With the asyncio Module', 'advanced,python')
(173, 'Python String Formatting Tips & Best Practices', 'basics,best-practices,python')
(174, 'Running Python Scripts', 'basics,python')
(175, 'Python Development in Visual Studio Code (Setup Guide)', 'intermediate,tools')
(176, 'Idiomatic Pandas: Tricks & Features You May Not Know', 'data-science,intermediate')
(177, 'Working With JSON Data in Python', 'intermediate,python')
(178, 'Django Migrations 101', 'intermediate,web-dev')
(179, 'Documenting Python Projects With Sphinx and Read The Docs', 'best-practices,intermediate')
(180, 'Intro to Object-Oriented Programming (OOP) in Python', 'intermediate,python')
(181, 'Python Decorators 101', 'intermediate,python')
(182, 'Writing Comments in Python', 'basics,best-practices,python')
(183, 'Making HTTP Requests With Python', 'intermediate,web-dev')
(184, 'Introduction to Python Exceptions', 'basics,python')
(185, 'Writing Beautiful Pythonic Code With PEP 8', 'best-practices,intermediate,python')
(186, "Python 3's f-Strings: An Improved String Formatting Syntax", 'basics,python')
(187, 'Idiomatic Python 101', 'basics,best-practices,python')
(188, 'Pythonic OOP String Conversion: __repr__ vs __str__', 'intermediate,python')
(189, 'Test-Driven Development With PyTest', 'intermediate,python,testing')
(190, 'Pandas DataFrames 101', 'basics,data-science')
(191, 'Emulating switch/case Statements in Python', 'intermediate,python')
(192, 'Migrating Applications From Python 2 to Python 3', 'advanced,python')
(193, '@staticmethod vs @classmethod in Python', 'intermediate,python')
(194, 'Splitting, Concatenating, and Joining Strings in Python', 'basics,python')
(195, 'Mastering While Loops', 'basics,python')
(196, 'Using List Comprehensions Effectively', 'intermediate,python')
(197, 'Reading and Writing CSV Files', 'data-science,intermediate,python')
(198, 'Using Jupyter Notebooks', 'intermediate,tools')
(199, 'Python Imports 101', 'basics,python')
(200, 'For Loops in Python (Definite Iteration)', 'basics,python')
(201, 'Working With Python Virtual Environments', 'basics,tools')
(202, 'Welcome to Real Python!', 'basics,community')