# EPO-Patent

**Repository Path**: xinihe/epo-patent

## Basic Information

- **Project Name**: EPO-Patent
- **Description**: No description available
- **Primary Language**: Unknown
- **License**: MIT
- **Default Branch**: main
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2024-12-02
- **Last Updated**: 2025-06-28

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# European Patent Data Project

This project involves accessing and utilizing patent data from the European Patent Office (EPO) stored in Tailong Finance School's SQL Server database. The goal is to facilitate research and analysis of patent information for educational and development purposes.

## Table of Contents

1. [Introduction](#introduction)
2. [Data Source](#data-source)
3. [Setup Instructions](#setup-instructions)
4. [Access Information](#access-information)
5. [Contributing](#contributing)
6. [License](#license)

## Introduction

The European Patent Data Project aims to provide easy access to comprehensive patent data for analysis and research. This data is crucial for understanding trends in innovation and technology development across various fields.

Reference: [DataCatalog](/RAG/DataCatalog_Global_v5.19.pdf)

#### Summary: [Brief Introduction of Table](/tables/intro.md) (for AI prompt)

#### Tables:

[TLS201_APPLN](/tables/TLS201/readme.md) — Patent Application Core Table

## Data Source

The data is sourced from the European Patent Office, which provides detailed procedural information on European patent applications as they progress through each stage of the granting process.

- **Coverage**: From 1782 onwards
- **Format**: CSV
- **Volume**: Backfile approx. 80 GB zipped

For more details, visit the [European Patent Register](https://www.epo.org/en/searching-for-patents/data).

## Setup Instructions

1. Clone this repository to your local machine.
2. Ensure you have Python 3.x installed.
3. Install required Python packages using:
   ```python
   pip install -r requirements.txt
   ```

## Access Information

To access the SQL Server database, you will need the following credentials:

New (faster) Server (updated on 21 May 2025):

* **Server Name**:  10.28.255.3
* **Username**:  stud_nihe
* **Password**: !econ_327
* **Database Name:** nihe_patent, EPO_Patent

## Example

on Mac ARM (M1/M2)

```python
pip install sqlalchemy pymssql pandas
```

```python
import pymssql
import pandas as pd  # Import pandas for data manipulation

# Establish a connection to the SQL Server database
conn = pymssql.connect(
    server='10.28.255.3',           # Server address
    user='ai_user',              # Username
    password='$read327',          # Password
    database='backup_epo_patent'          # Target database
)

# Define the SQL query to retrieve the first 10 rows
query = "SELECT TOP 10 * FROM tls206"

# Use pandas to execute the query and load the data into a DataFrame
df = pd.read_sql(query, conn)

# Close the database connection
conn.close()
```

On Windows

```python
import pandas as pd
from sqlalchemy import create_engine

# Database connection details
username = 'ai_user'
password = '$read327'
server = '10.28.255.3'
database = 'backup_epo_patent'
table_name = 'tls206'  # Target SQL table name
driver = 'ODBC Driver 17 for SQL Server'

# Database connection string
connection_string = f'mssql+pyodbc://{username}:{password}@{server}/{database}?driver=ODBC+Driver+17+for+SQL+Server'
engine = create_engine(connection_string)

query = f'select top 10 * from {table_name}'
df = pd.read_sql(query, engine)
```