google refine - How to save only specific JSON elements in a new OpenRefine column -

- 

{     "business_id": "sq0j7bgstazkvqlf5anqyq",     "full_address": "214 e main st\ncarnegie\ncarnegie, pa 15106",     "hours": {},     "open": true,     ** "categories": ["chinese", "restaurants"] ** ,     "city": "carnegie",     "review_count": 9,     "name": "don don chinese restaurant",     "neighborhoods": ["carnegie"],     "longitude": -80.0849615,     "state": "pa",     "stars": 2.5,     "latitude": 40.4083473,     "attributes": {         "take-out": true,         "alcohol": "none",         "noise level": "quiet",         "parking": {             "garage": false,             "street": false,             "validated": false,             "lot": false,             "valet": false         },         "delivery": true,         "has tv": true,         "outdoor seating": false,         "attire": "casual",         "waiter service": false,         "accepts credit cards": true,         "good kids": true,         "good groups": false,         "price range": 1     },     "type": "business" }

value.parsejson()['categories'] create new column called 'categories' in openrefine, possible filter , keep 'chinese' value , remove other values?

in example above, grel expression:

value.parsejson()['categories']

results in array containing 2 values:

["chinese", "restaurants"]

you can manipulate grel expressions act on arrays. example, select first value in array use:

value.parsejson()['categories'][0]

which select first entry in array (increase number in square brackets @ end of expression select other entries in array)

if want filter on specific value in array use 'filter' expression:

filter(value.parsejson()['categories'],v,v=="chinese")

this result in new array word "chinese" in (in above example). store in new column, need convert array string:

filter(value.parsejson()['categories'],v,v=="chinese").join("")

to avoid issues case-sensitivity, , possibility of 'chinese' appearing more once in 'categories' array, i'd convert values lowercase first , de-duplicate array before converting string - end with:

filter(foreach(value.parsejson()["categories"],v,v.tolowercase()),w,w=="chinese").uniques().join("")

Comments

Post a Comment

Popular posts from this blog

Django REST Framework perform_create: You cannot call `.save()` after accessing `serializer.data` -

-
i have following viewset: class artistprofileviewset(viewsets.modelviewset): queryset = artistprofile.objects.all() serializer_class = artistprofileserializer def perform_create(self, serializer): if serializer.is_valid(): serializer.save() with following serializers: class simpleartisttrackserializer(serializers.hyperlinkedmodelserializer): class meta: model = artisttrack fields = (...my fields...) class artistprofileserializer(serializers.hyperlinkedmodelserializer): owners = userserializer(many=true, required=false) tracks = simpleartisttrackserializer(many=true, required=false) class meta: model = artistprofile fields = (...my fields...) i getting following error: assertionerror: cannot call `.save()` after accessing `serializer.data`.if need access data before committing database inspect 'serializer.validated_data' instead. i don't see editing serializer.data object. th...
Read more

Why does Go error when trying to marshal this JSON? -

-
i'm trying rather simple example of trying decode json file structs using golang. however, when attempting error that json: cannot unmarshal object go value of type []main.track which don't understand. here's code in question, , json can found here . package main import ( "encoding/json" "fmt" "net/http" "os" ) // tracks group of track types type tracks struct { tracks []track } // track represents singular track type track struct { name string url string artist artist } // artist represents single artist type artist struct { name string mbid string url string } func main() { url := "http://ws.audioscrobbler.com/2.0/?method=geo.gettoptracks&api_key=c1572082105bd40d247836b5c1819623&format=json&country=netherlands" response, err := http.get(url) if err != nil { fmt.printf("%s\n", err) os.exit(1) } de...
Read more