📅 2023-02-10 — Session: Developed Python tools for language translation
🕒 14:40–16:15
🏷️ Labels: Python, Language Translation, Web Scraping, Game Development
📂 Project: Dev
⭐ Priority: MEDIUM
Session Goal
The session aimed to explore and develop Python-based tools for language translation and data processing.
Key Activities
- Implemented string similarity calculations using the FuzzyWuzzy library in Python to compare two columns in a DataFrame.
- Developed a Python script using BeautifulSoup to scrape a webpage for the 1000 most common Portuguese words and their English translations, storing the results in a pandas DataFrame.
- Explored the use of the Google Translate API for translating text from Portuguese to Spanish in Google Sheets, considering both Python and Google Apps Script for implementation.
- Created a sample Python code for a language translation game, prompting users to translate Portuguese words into Spanish using a DataFrame.
- Developed an interactive Python game that challenges users to translate words between Portuguese and Spanish, providing feedback and allowing two attempts per word.
Achievements
- Successfully implemented string similarity calculations and web scraping scripts.
- Developed a functional interactive language translation game in Python.
Pending Tasks
- Further exploration and integration of the Google Translate API with Google Sheets for automated translations.