美文网首页图数据库Neo4j
使用import csv文件方式创建知识图谱

使用import csv文件方式创建知识图谱

作者: 布口袋_天晴了 | 来源:发表于2018-09-19 15:10 被阅读255次

    1.查看是否有import文件夹

    2.在import文件夹里放入csv文件

    3.实用Cpyher语句,导入数据

    LOAD CSV WITH HEADERS FROM "file:///julian_person.csv" AS line MERGE (p:Person {id:line.p_id, name:line.name, introduction:line.introduction})

    LOAD CSV WITH HEADERS FROM "file:///julian_company.csv" AS line MERGE (c:BC_Company {id:line.c_id, name:line.name, tag:line.tag, introduction:line.introduction})

    LOAD CSV WITH HEADERS FROM "file:///julian_p_c_rel.csv" AS line

    match (from:Person{id:line.p_id}),(to:Company{id:line.c_id})

    merge (from)-[r:member{p_id:line.p_id,c_id:line.c_id}]->(to)

    关于乱码问题:

    load csv 中文编码乱码,  必须确保csv文件的编码格式:UTF8 无BOM格式

    再增加一些关系节点

    Cpyher语句,导入数据:

    LOAD CSV WITH HEADERS FROM "file:///chain_block_kg.csv" AS line MERGE (p:BC_Konwledge {id:line.id, name:line.name})

    LOAD CSV WITH HEADERS FROM "file:///kg_rel.csv" AS line

    match (from:BC_Knowledge{id:line.c_id}),(to:BC_Knowledge{id:line.id})

    merge (from)-[r:isInculdeOf]->(to)

    LOAD CSV WITH HEADERS FROM "file:///julian_c_kg_rel.csv" AS line

    match (from:BC_Company{id:line.c_id}),(to:BC_Knowledge{id:line.kg_id})

    merge (from)-[r:companyTagIs]->(to)

    LOAD CSV WITH HEADERS FROM "file:///tokenview_coin.csv" AS line MERGE (p:Coin {id:line.id, name:line.name, Alias:line.alia, introduction:line.summaryCn})

    参考文章:【1】基于电影知识图谱的智能问答系统(二) -- Neo4j导入CSV文件  实用,有数据可下载

    相关文章

      网友评论

        本文标题:使用import csv文件方式创建知识图谱

        本文链接:https://www.haomeiwen.com/subject/gwtinftx.html