π 2024-05-23 β Session: Developed News Database with Google Tools
π 20:45β21:45
π·οΈ Labels: Google Cloud, Bigquery, News Database, Data Collection, Automation
π Project: Media
β Priority: MEDIUM
Session Goal
The primary aim of this session was to develop a comprehensive plan for creating a news database using Google tools, specifically Google News RSS and Google BigQuery.
Key Activities
- Discussed the options for replacing or removing the catalytic converter in a Peugeot 207, including legal and cost considerations.
- Explored a scientific approach to human rights issues, inspired by NΓ©stor Kirchner, emphasizing evidence-based analysis and international solidarity.
- Outlined a detailed project plan for a news database using Google Cloud tools, focusing on data collection, storage, and analysis.
- Provided a modular project structure for news data collection and analysis, with directories for data, scripts, notebooks, configuration, and tests.
- Detailed the setup of an exploratory data analysis notebook for Google News data, including initial configuration and data storage in BigQuery.
- Offered guidance on resolving import issues with Google BigQuery libraries in Python notebooks.
- Provided a step-by-step guide for setting up a project on Google Cloud Platform, enabling necessary APIs, creating service credentials, and configuring the BigQuery client.
Achievements
- Established a clear framework and execution plan for creating a news database using Google Cloud tools.
- Developed a modular structure for organizing the project and conducting exploratory data analysis.
- Resolved technical issues related to library imports and Google Cloud configuration.
Pending Tasks
- Implement the outlined plan for the news database, focusing on automation and AI integration for data collection and analysis.