David Spencer DecisionNerd

## neo4j.py
# download 3.5.8 or neo4j-enterprise-4.0.0-alpha09mr02-unix
!curl https://neo4j.com/artifact.php?name=neo4j-community-3.5.8-unix.tar.gz -o neo4j.tar.gz
# decompress and rename
!tar -xf neo4j.tar.gz  # or --strip-components=1
!mv neo4j-community-3.5.8 nj
# disable password, and start server
!sed -i '/#dbms.security.auth_enabled/s/^#//g' nj/conf/neo4j.conf
!nj/bin/neo4j start

## devicetype.groovy
/**
 *  Raspberry Pi - IP Camera
 *
 *  Copyright 2015 st.john.johnson@gmail.com
 *
 *  Licensed under the Apache License, Version 2.0 (the "License"); you may not use this file except
 *  in compliance with the License. You may obtain a copy of the License at:
 *
 *      http://www.apache.org/licenses/LICENSE-2.0
 *

## Desc_JSON_to_df.md

      
              2 files
            
          
              6 forks
            
          
              3 comments
            
          
              17 stars
            
          
                gluc
                / Desc_JSON_to_df.md
            
            
              Last active
              June 19, 2023 02:32
            
              
                Convert a complex JSON to an R data.frame
              
          
    This gist shows how to convert a nested JSON file to an R data.frame.
To do this, it uses jsonlite and data.tree.
The gist contains two examples: one is a bit simpler, the second one a bit more advanced.
Example 1

In the first example, we download all the repos from Hadley Wickham's Github account from https://api.github.com/users/hadley/repos . This JSON contains a nested owner object. The code shows how to convert that in a flat data.frame in three statements:

line 5: download
line 8: convert to data.tree


## dataframeFromJSON
## Example data.json
[{"event":"glop","params":{"name":"toto","value":"glop"}},
{"event":"glot","params":{"name":"toto","info":"gggg"}},
{"event":"gogo","params":"text"},
{"event":"gogo2"}
];

## Expected output
  event params.name params.value params.info params
1  glop        toto         glop        <NA>   <NA>

## index.html
<!DOCTYPE html>
<html>
  <head>
    <title>Leaflet</title>
    <link rel="stylesheet" href="http://cdn.leafletjs.com/leaflet-0.3.1/leaflet.css" />
    <script src="http://cdn.leafletjs.com/leaflet-0.3.1/leaflet.js"></script>
    <script src="http://maps.google.com/maps/api/js?v=3.2&sensor=false"></script>
    <script src="http://matchingnotes.com/javascripts/leaflet-google.js"></script>
  </head>
  <body>

## 00-logstash.conf
input {
  file {
    type => syslog
    path => "/var/log/messages"
  }
}

filter {
  grok {
    type => syslog
	# download 3.5.8 or neo4j-enterprise-4.0.0-alpha09mr02-unix
	!curl https://neo4j.com/artifact.php?name=neo4j-community-3.5.8-unix.tar.gz -o neo4j.tar.gz
	# decompress and rename
	!tar -xf neo4j.tar.gz # or --strip-components=1
	!mv neo4j-community-3.5.8 nj
	# disable password, and start server
	!sed -i '/#dbms.security.auth_enabled/s/^#//g' nj/conf/neo4j.conf
	!nj/bin/neo4j start
	/**
	* Raspberry Pi - IP Camera
	*
	* Copyright 2015 st.john.johnson@gmail.com
	*
	* Licensed under the Apache License, Version 2.0 (the "License"); you may not use this file except
	* in compliance with the License. You may obtain a copy of the License at:
	*
	* http://www.apache.org/licenses/LICENSE-2.0
	*
	## Example data.json
	[{"event":"glop","params":{"name":"toto","value":"glop"}},
	{"event":"glot","params":{"name":"toto","info":"gggg"}},
	{"event":"gogo","params":"text"},
	{"event":"gogo2"}
	];

	## Expected output
	event params.name params.value params.info params
	1 glop toto glop <NA> <NA>
	<!DOCTYPE html>
	<html>
	<head>
	<title>Leaflet</title>
	<link rel="stylesheet" href="http://cdn.leafletjs.com/leaflet-0.3.1/leaflet.css" />
	<script src="http://cdn.leafletjs.com/leaflet-0.3.1/leaflet.js"></script>
	<script src="http://maps.google.com/maps/api/js?v=3.2&sensor=false"></script>
	<script src="http://matchingnotes.com/javascripts/leaflet-google.js"></script>
	</head>
	<body>
	input {
	file {
	type => syslog
	path => "/var/log/messages"
	}
	}

	filter {
	grok {
	type => syslog