Return count(*) Importing Pledges and Backers Querying Categories MATCH (n:Category) RETURN n LIMIT 25 We can now run a bunch of queries to see which categories exist, how many there are, and to get a visual. All values are strings, so if we want to convert them we need to do that manually. Which gives us object/hash/dict/map representations of each row with the headers as key and the row data as values. We can look at the first few rows of the data: load csv with headers from ImportĪfter creating our blank AuraDB Free database, and opening Neo4j Browser we can get going. for finance and security reasons - but we kept it in the project for simplicity. We could extract the pledge information into a separate node - e.g. We extract the subcategory and category and the country as separate nodes. That helps us to visualize the state of a project quickly and also sub-select the relevant projects easily. We could model the state just as a property like in the CSV, but as there are only a few relevant states and it’s an important attribute of a project to distinguish them, we can also add labels to a project for: The data model has some interesting tidbits, especially around modeling the state. Google Spreadsheets didn’t like importing the full 400k rows, so we split the file using xsv split -c 10000 split kickstarter.csv into smaller chunks ( csvkit works too, or just head -10000 in any unix shell).Īs the long URL is a bit unwieldy, we created a bit.ly shortlink for our needs: Data Model Other tools and people can access just that data read-only, including our Neo4j instance. This time, we wanted to demonstrate how you can use Google Spreadsheets for that.Īfter uploading the 100k chunk of the file as a new sheet, you can choose “File → Publish to the Web” to publish a single sheet, e.g. ![]() To make it easier to import, I would usually upload the CSV file somewhere publicly to access it easily, like GitHub, Pastebin, or S3. State - Current condition the project is in (as of 2018–01–02) (Successful, Canceled, Failed, Live, Suspended).Pledged - Amount of money pledged by the crowd (USD).Goal - Amount of money the creator needs to complete the project (USD). ![]()
0 Comments
Leave a Reply. |