I have the Patstat raw files, autumn 2015. Somehow I haven't been able to properly install the SQL database yet using the script provided (not in Oracle SQL and not in MySQL and not even with the help of SQL experts), but I think I can skip that step for the research that is left for me. The CSV should be pretty flat and straightforward, right? I would like to access the files directly using R.
The CSV-file is divided over several disks. How can I just create one big flat CVS file from the disks that I have?
Patstat and R
-
- Posts: 140
- Joined: Wed Jul 08, 2009 5:51 pm
- Contact:
Re: Patstat and R
What operating system are you on? Which tables are you using for your research? What error messages are you getting? Importing PATSTAT into MySQL should be rather easy...
There is no official installation script for MySQL, but Gianluca generally posts these on his website http://rawpatentdata.blogspot.nl/
I also have some MySQL import scripts, but those are for earlier versions of PATSTAT. I'm too poor to keep updating ;(
PATSTAT is a relational database, and creating a join out of all the csv files would just be big and messy.
There is no official installation script for MySQL, but Gianluca generally posts these on his website http://rawpatentdata.blogspot.nl/
I also have some MySQL import scripts, but those are for earlier versions of PATSTAT. I'm too poor to keep updating ;(
PATSTAT is a relational database, and creating a join out of all the csv files would just be big and messy.
________________________________________
Nico Doranov
Data Manager
Daigu Academic Services & Data Stewardship
http://www.daigu.nl/
Nico Doranov
Data Manager
Daigu Academic Services & Data Stewardship
http://www.daigu.nl/