Oleg Khomenko
3 min readDec 12, 2022

--

Learn Python by creating pet projects

🚀 Top 9 pet projects with Python and Airtable API to improve your software engineering skills

One of the best ways to learn something new in software engineering is to create a pet project with new technologies. In this article, I will propose seven ideas for pet projects to learn Python and use Airtable as a simple database for backend storage

Airtable is a good choice for pet projects because it is easy to use and provides much flexibility in data organization and manipulation. It has a simple, spreadsheet-like interface that makes it easy to enter and manage data. It also offers advanced features like formulas, validation rules, and data linking that can help you organize and analyze your data in powerful ways. Additionally, Airtable integrates with many other tools and services to connect your pet project easily.

Overall, Airtable is a versatile and user-friendly platform that can help you quickly build and manage a wide range of pet projects.

Python is a great language for creating something practical and useful every day.

Use these 9Ideas to create pet projects using Python & Airtable API

Simple

  1. Create a simple to-do list app that uses Airtable as the backend data storage. Users can add, edit, and delete tasks from the app, and the changes will be synced with their Airtable database in real-time.
  2. Build a simple budget tracking tool that allows users to enter their income and expenses into an Airtable database, and then use Python to generate useful reports and visualizations of their spending habits.
  3. Develop a simple chatbot that uses Airtable as its knowledge base. The chatbot could be integrated with a messaging platform like Discord or Slack, and users could ask it questions that it would answer by looking up the relevant information in the Airtable database.
    IFTTT has done well on integration. Why can’t you do the same?
  4. Create a simple quiz/educational game that uses Airtable to track player progress and high scores. You could then use Python to create a leaderboard that shows the top players. The leaderboard may be stored as an Airtable page and shared on the Internet
    Enjoy learning.
  5. Build a web scraper that collects data on real estate listings from multiple websites and stores it in an Airtable database. This could be used to track changes in the real estate market over time or to compare prices and features of different properties.
    Do I need to tell you why real estate market analytics is a big thing?
  6. Create a scraper that collects data on the latest news articles from a particular website or group of websites and stores it in an Airtable database. This could be used to create a personalized news feed or to track changes in the coverage of a particular topic.
    Enjoy your new highly personalized news feed with statistics
  7. Develop a scraper that collects data on job listings from various job search websites and stores it in an Airtable database. This could be used to track changes in the job market or to compile a database of job opportunities in a particular field or location.
    This project will help you find a new job
  8. Create a scraper that collects data on the latest posts from social media platforms like Twitter or Instagram and stores it in an Airtable database. This could be used to track a particular hashtag's popularity or monitor a particular user's activity.
    This project will help to create useful landing pages about trends in social media
  9. Build a scraper that collects data on online retailers’ latest products and prices and stores it in an Airtable database. This could be used to track changes in the prices of specific products or to compare prices across different retailers.
    You will never miss a sale again

--

--