我正在使用以下 .csv 檔案進行 Neo4j 匯入。有202個球拍。racketX 下方的數字是用戶對該球拍的評分。
我想創建用戶之間的關系以及他們對每個球拍的評分。這是我目前的方法：
LOAD CSV WITH HEADERS FROM 'http://spreding.online/racket-recommendation-system/data/formattedFiles/formattedUsers.csv' AS row
WITH row
WHERE row.username IS NOT NULL
MERGE (u:User {
username: row.username,
height_m: toInteger(row.height),
weight_kg: toInteger(row.weight)
})
WITH row, u, range(3, 204) as indexes
MATCH (r:Racket)
UNWIND r as racket
UNWIND indexes as i
MERGE (u)-[:RATES {rating:toInteger(row[i])}]->(racket)
我收到“無法訪問地圖”錯誤。你能幫助我嗎？
uj5u.com熱心網友回復：
我會將負載分解為多個步驟。
加載用戶。
LOAD CSV WITH HEADERS FROM 'http://spreding.online/racket-recommendation-system/data/formattedFiles/formattedUsers.csv' AS row
WITH row
WHERE row.username IS NOT NULL
MERGE (u:User {
username: row.username,
height_m: toInteger(row.height),
weight_kg: toInteger(row.weight)
})
裝入球拍。
UNWIND RANGE(1,202) as idx
CREATE (:Racket {racketNumber:"racket" idx})
加載關系。
LOAD CSV WITH HEADERS FROM 'http://spreding.online/racket-recommendation-system/data/formattedFiles/formattedUsers.csv' AS row
UNWIND RANGE (1,202) as idx
MATCH (u:User {username:row.username})
MATCH (r:Racket {racketNumber:"racket" idx})
MERGE (u)-[:RATES {rating:toInteger(row["racket" idx])}]->(r)
轉載請註明出處，本文鏈接：https://www.uj5u.com/qiye/372808.html
上一篇：圖表的下拉選單