How to load/use PATSTAT data in R?

Here you can post your opinions, ask questions and share experiences on the PATSTAT product line. Please always indicate the PATSTAT edition (e.g. 2015 Autumn Edition) and the database (e.g. PATSTAT Online, MySQL, MS SQL Server, ...) you are using.
Post Reply

Posts: 1
Joined: Fri Dec 11, 2020 10:39 am

How to load/use PATSTAT data in R?

Post by MrQuicky » Fri Dec 11, 2020 10:41 am


Was hoping to find some help on how to load PATSTAT data into R? I understand that it requires loading into a database like MySQL but I have no experience with that so I am quite lost at the instructions.

I have the files downloaded for the Autumn 2019 version.

Thanks alot :)

Posts: 261
Joined: Thu Feb 22, 2007 5:33 pm

Re: How to load/use PATSTAT data in R?

Post by EPO / PATSTAT Support » Mon Dec 14, 2020 11:21 am

Hello MrQuicky,
I can not help you with R,
but at this link you will find sample scripts for loading PATSTAT on a MySQL platform.

patstat-2019b-mysql-upload-scripts-8627 ... 590#p24590
PATSTAT Support Team
EPO - Vienna
patstat @

Post Reply