search

dspinellis / alexandria3k

Local relational access to openly-available publication data sets
GNU General Public License v3.0
79 stars 14 forks source link

Add USPTO documentation #25

Closed AggelosMargkas closed 9 months ago

AggelosMargkas commented 10 months ago

Add my first example of results of data that run through the whole USPTO data.

Add the sql query into the uspto examples file. This SQL query is designed to extract information about the applicant population by country and year, focusing on the top 5 countries in terms of patent counts for the year 2022.

Add the graph representing the evolution of the population and show it on the README.

AggelosMargkas commented 10 months ago

Nice! I like the clear SQL code. Please also add the Python script that generates the chart.

Added that, should I add the csv data file as well?

dspinellis commented 10 months ago

Great! The CSV data is a generated file. We add the chart (which is also generated) so that it can appear in the README file. I'll ensure that the example can run automatically as part of integration testing and get back to you, if needed.

AggelosMargkas commented 9 months ago

So nice to see this contribution! I suggested a few changes.

Hello👋 and apologies for my late reply. I updated the changes and I believe they are ready to be seen. I changed the image format accordingly.

I have this error on the CI log for the installation of the rdbunit.

Run git clone --depth=1 https://github.com/dspinellis/rdbunit.git
Cloning into 'rdbunit'...
make: *** No rule to make target 'install'.  Stop.
Error: Process completed with exit code 2.

Any idea how to resolve this?