This project analyzes data collected from the Google Trends public dataset using Google BigQuery. The analysis is performed using OpenAI API, and the results are presented in an interactive map created with JSVectorMap.
extract-dataset-bq.r
: The script that collects the data from Google BigQuery.classification.r
: The script that performs the data classification with OpenAI.analysis.r
: Performs the aggregation and visualization of the data./out
: Directory containing the output CSV file generated by the R scripts./utils
: Scripts containing common functionalities./reports
: The reports generated by the scripts./site
: App to display the interactive map using JSVectorMap. [IN PROGRESS]
- R
- Google Cloud account and project
- OpenAI API Key
- Web browser
- Clone the repository to your local machine.
- Ensure you have the necessary prerequisites installed.
- Setup the .Renviron variables with your values.
- Execute the following files, in order:
extract-dataset-bq.r
classification.r
analysis.r
- Checkout the CSV outputs in the
/out
directory. - Checkout the reports at
/reports
. - Open
maps/index.html
in a web browser to view the interactive map. [IN PROGRESS]
This project is licensed under the MIT License.