{ "cells": [ { "cell_type": "markdown", "id": "054d075f", "metadata": {}, "source": [ "hämta observation [93568641](https://www.inaturalist.org/observations/93568641)\n", "* this [Notebook](https://github.com/salgo60/spa2Commons/blob/main/Notebook/iNaturalistObservation.ipynb)\n", " * api [observations](https://www.inaturalist.org/observations.json)\n", " * [projects user kueda.json](http://www.inaturalist.org/projects/user/kueda.json)" ] }, { "cell_type": "code", "execution_count": 2, "id": "7418de3e", "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "Last run: 2021-09-06 11:18:04.669891\n" ] } ], "source": [ "from datetime import datetime\n", "start_time = datetime.now()\n", "print(\"Last run: \", start_time)" ] }, { "cell_type": "code", "execution_count": 4, "id": "a9b0d25d", "metadata": {}, "outputs": [], "source": [ "import urllib3, json\n", "import pandas as pd \n", "http = urllib3.PoolManager() \n", "\n", "obs = \"93568641\"\n", "url = \"http://www.inaturalist.org/observations/visbystar.json\"\n", "r = http.request('GET', url) \n", "data = json.loads(r.data.decode('utf-8')) \n" ] }, { "cell_type": "code", "execution_count": 6, "id": "406039db", "metadata": {}, "outputs": [], "source": [ "df = pd.DataFrame(data)" ] }, { "cell_type": "code", "execution_count": 7, "id": "14942e73", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
idobserved_ondescriptionlatitudelongitudemap_scaletimeframespecies_guessuser_idtaxon_id...iconic_taxon_namefaves_countcreated_at_utcupdated_at_utctime_observed_at_utcowners_identification_from_visiontaxoniconic_taxonuserphotos
0937036072021-09-0557.647223655718.2964022665NoneNonemurgröna215300855882.0...Plantae02021-09-05T12:06:22.739Z2021-09-05T12:47:26.627Z2021-09-05T11:06:19.000ZTrue{'id': 55882, 'name': 'Hedera helix', 'rank': ...{'id': 47126, 'name': 'Plantae', 'rank': 'king...{'login': 'visbystar', 'user_icon_url': 'https...[{'id': 155342556, 'user_id': 2153008, 'native...
1937035672021-09-0557.647420442418.2965675787NoneNone215300853438.0...Plantae02021-09-05T12:05:39.505Z2021-09-05T15:01:58.027Z2021-09-05T11:05:21.000ZNone{'id': 53438, 'name': 'Rosa', 'rank': 'genus',...{'id': 47126, 'name': 'Plantae', 'rank': 'king...{'login': 'visbystar', 'user_icon_url': 'https...[{'id': 155341708, 'user_id': 2153008, 'native...
2937035612021-09-0557.64739652118.2965240628NoneNoneFläder2153008765394.0...Plantae02021-09-05T12:05:29.392Z2021-09-05T16:04:42.007Z2021-09-05T11:05:05.000ZNone{'id': 765394, 'name': 'Sambucus nigra', 'rank...{'id': 47126, 'name': 'Plantae', 'rank': 'king...{'login': 'visbystar', 'user_icon_url': 'https...[{'id': 155341693, 'user_id': 2153008, 'native...
3937035222021-09-0557.647396787518.2965596824NoneNone215300848528.0...Plantae02021-09-05T12:05:10.797Z2021-09-05T15:02:44.674Z2021-09-05T11:04:49.000ZNone{'id': 48528, 'name': 'Symphoricarpos', 'rank'...{'id': 47126, 'name': 'Plantae', 'rank': 'king...{'login': 'visbystar', 'user_icon_url': 'https...[{'id': 155341645, 'user_id': 2153008, 'native...
4937035152021-09-0457.597369573818.3812708559NoneNoneoxbärssläktet215300853376.0...Plantae02021-09-05T12:04:59.504Z2021-09-05T16:05:38.763Z2021-09-04T10:45:13.000ZNone{'id': 53376, 'name': 'Cotoneaster', 'rank': '...{'id': 47126, 'name': 'Plantae', 'rank': 'king...{'login': 'visbystar', 'user_icon_url': 'https...[{'id': 155341627, 'user_id': 2153008, 'native...
5935700412021-09-0457.594706608818.377578007NoneNoneSlån215300855811.0...Plantae02021-09-04T11:26:32.446Z2021-09-05T12:44:16.969Z2021-09-04T10:26:28.000ZFalse{'id': 55811, 'name': 'Prunus spinosa', 'rank'...{'id': 47126, 'name': 'Plantae', 'rank': 'king...{'login': 'visbystar', 'user_icon_url': 'https...[{'id': 155102083, 'user_id': 2153008, 'native...
6935700032021-09-0457.594670883318.3778277204NoneNone2153008131622.0...Plantae02021-09-04T11:25:54.711Z2021-09-04T15:26:28.947Z2021-09-04T10:25:51.000ZNone{'id': 131622, 'name': 'Prunella grandiflora',...{'id': 47126, 'name': 'Plantae', 'rank': 'king...{'login': 'visbystar', 'user_icon_url': 'https...[{'id': 155102015, 'user_id': 2153008, 'native...
7935699132021-09-0457.594409117318.3779062817NoneNone215300854597.0...Fungi02021-09-04T11:24:00.896Z2021-09-05T17:19:24.975Z2021-09-04T10:23:44.000ZNone{'id': 54597, 'name': 'Lactarius', 'rank': 'ge...{'id': 47170, 'name': 'Fungi', 'rank': 'kingdo...{'login': 'visbystar', 'user_icon_url': 'https...[{'id': 155101833, 'user_id': 2153008, 'native...
8935686412021-09-0457.591371793818.3741269856NoneNonerönn215300856063.0...Plantae02021-09-04T11:02:19.222Z2021-09-06T08:35:15.828Z2021-09-04T10:02:15.000ZNone{'id': 56063, 'name': 'Sorbus aucuparia', 'ran...{'id': 47126, 'name': 'Plantae', 'rank': 'king...{'login': 'visbystar', 'user_icon_url': 'https...[{'id': 155101820, 'user_id': 2153008, 'native...
9935686122021-09-0457.591383997318.3742810416NoneNone215300850814.0...Fungi02021-09-04T11:01:42.519Z2021-09-05T17:20:56.308Z2021-09-04T10:01:38.000ZNone{'id': 50814, 'name': 'Agaricomycetes', 'rank'...{'id': 47170, 'name': 'Fungi', 'rank': 'kingdo...{'login': 'visbystar', 'user_icon_url': 'https...[{'id': 155099959, 'user_id': 2153008, 'native...
10935685952021-09-0457.591466735918.3743168644NoneNone215300848339.0...Fungi02021-09-04T11:01:27.835Z2021-09-05T17:21:12.736Z2021-09-04T10:01:23.000ZNone{'id': 48339, 'name': 'Russula', 'rank': 'genu...{'id': 47170, 'name': 'Fungi', 'rank': 'kingdo...{'login': 'visbystar', 'user_icon_url': 'https...[{'id': 155099938, 'user_id': 2153008, 'native...
11935670572021-09-0457.601568865518.3822946187NoneNoneGullris2153008118850.0...Plantae02021-09-04T10:43:16.071Z2021-09-05T12:45:38.395Z2021-09-04T09:43:11.000ZFalse{'id': 118850, 'name': 'Solidago virgaurea', '...{'id': 47126, 'name': 'Plantae', 'rank': 'king...{'login': 'visbystar', 'user_icon_url': 'https...[{'id': 155098378, 'user_id': 2153008, 'native...
12935669942021-09-0457.593811958318.3777858253NoneNone215300850814.0...Fungi02021-09-04T10:41:33.533Z2021-09-05T17:21:43.421Z2021-09-04T09:41:29.000ZNone{'id': 50814, 'name': 'Agaricomycetes', 'rank'...{'id': 47170, 'name': 'Fungi', 'rank': 'kingdo...{'login': 'visbystar', 'user_icon_url': 'https...[{'id': 155098247, 'user_id': 2153008, 'native...
13935669732021-09-0457.593715013418.3778809479NoneNone215300850814.0...Fungi02021-09-04T10:41:08.675Z2021-09-05T17:22:31.055Z2021-09-04T09:41:00.000ZNone{'id': 50814, 'name': 'Agaricomycetes', 'rank'...{'id': 47170, 'name': 'Fungi', 'rank': 'kingdo...{'login': 'visbystar', 'user_icon_url': 'https...[{'id': 155098207, 'user_id': 2153008, 'native...
14935668402021-09-0457.612978585318.3877867139NoneNoneRöda skogsmyror21530081254127.0...Insecta02021-09-04T10:38:08.271Z2021-09-05T12:44:33.804Z2021-09-04T09:38:03.000ZFalse{'id': 1254127, 'name': 'Formica rufa', 'rank'...{'id': 47158, 'name': 'Insecta', 'rank': 'clas...{'login': 'visbystar', 'user_icon_url': 'https...[{'id': 155098006, 'user_id': 2153008, 'native...
15935666912021-09-0457.594773496118.3769838516NoneNone215300854597.0...Fungi02021-09-04T10:35:55.921Z2021-09-05T15:18:44.575Z2021-09-04T09:35:48.000ZNone{'id': 54597, 'name': 'Lactarius', 'rank': 'ge...{'id': 47170, 'name': 'Fungi', 'rank': 'kingdo...{'login': 'visbystar', 'user_icon_url': 'https...[{'id': 155097879, 'user_id': 2153008, 'native...
16876873542021-07-1957.641777370718.2912194229NoneNonecikoria215300852913.0...Plantae02021-07-19T08:49:52.289Z2021-09-03T20:13:37.591Z2021-07-19T08:49:48.000ZNone{'id': 52913, 'name': 'Cichorium intybus', 'ra...{'id': 47126, 'name': 'Plantae', 'rank': 'king...{'login': 'visbystar', 'user_icon_url': 'https...[{'id': 144599404, 'user_id': 2153008, 'native...
17876834222021-07-1957.605458648818.2831946351NoneNonecikoria215300852913.0...Plantae02021-07-19T07:36:06.121Z2021-09-03T20:13:37.591Z2021-07-19T07:36:01.000ZNone{'id': 52913, 'name': 'Cichorium intybus', 'ra...{'id': 47126, 'name': 'Plantae', 'rank': 'king...{'login': 'visbystar', 'user_icon_url': 'https...[{'id': 144592107, 'user_id': 2153008, 'native...
18871944212021-07-1357.6362218.2912083333NoneNone215300847727.0...Plantae02021-07-15T21:36:24.307Z2021-09-03T20:13:37.591Z2021-07-13T15:34:48.000ZNone{'id': 47727, 'name': 'Acer', 'rank': 'genus',...{'id': 47126, 'name': 'Plantae', 'rank': 'king...{'login': 'visbystar', 'user_icon_url': 'https...[{'id': 143716593, 'user_id': 2153008, 'native...
19863861572021-07-1057.358008121718.4887930606NoneNone2153008NaN...None12021-07-10T10:49:20.666Z2021-09-03T20:13:37.591Z2021-07-10T10:49:14.000ZNoneNaNNaN{'login': 'visbystar', 'user_icon_url': 'https...[{'id': 142306550, 'user_id': 2153008, 'native...
20863850012021-07-1057.389769316618.5200162896NoneNone215300861454.0...Plantae02021-07-10T10:31:10.365Z2021-09-03T20:13:37.591Z2021-07-10T10:31:05.000ZNone{'id': 61454, 'name': 'Polygonatum odoratum', ...{'id': 47126, 'name': 'Plantae', 'rank': 'king...{'login': 'visbystar', 'user_icon_url': 'https...[{'id': 142303197, 'user_id': 2153008, 'native...
21840286072021-06-2257.6415004518.2901916717NoneNoneulltistel215300878259.0...Plantae02021-06-22T06:54:28.537Z2021-09-03T20:13:37.591Z2021-06-22T06:54:12.000ZNone{'id': 78259, 'name': 'Onopordum acanthium', '...{'id': 47126, 'name': 'Plantae', 'rank': 'king...{'login': 'visbystar', 'user_icon_url': 'https...[{'id': 138065293, 'user_id': 2153008, 'native...
22805087912021-05-2757.636817605618.2884973455NoneNoneaplar215300854500.0...Plantae02021-05-27T18:30:25.324Z2021-09-03T20:13:37.591Z2021-05-27T17:34:34.000ZNone{'id': 54500, 'name': 'Malus', 'rank': 'genus'...{'id': 47126, 'name': 'Plantae', 'rank': 'king...{'login': 'visbystar', 'user_icon_url': 'https...[{'id': 131961340, 'user_id': 2153008, 'native...
23802094972021-05-2557.643684567818.2947513454NoneNoneblåregn2153008127306.0...Plantae02021-05-25T06:50:16.809Z2021-09-03T20:13:37.591Z2021-05-25T06:50:11.000ZNone{'id': 127306, 'name': 'Wisteria sinensis', 'r...{'id': 47126, 'name': 'Plantae', 'rank': 'king...{'login': 'visbystar', 'user_icon_url': 'https...[{'id': 131446171, 'user_id': 2153008, 'native...
24802094512021-05-2557.643402031618.2956144935NoneNone215300847125.0...Plantae02021-05-25T06:48:39.397Z2021-09-03T20:13:37.591Z2021-05-25T06:48:34.000ZNone{'id': 47125, 'name': 'Angiospermae', 'rank': ...{'id': 47126, 'name': 'Plantae', 'rank': 'king...{'login': 'visbystar', 'user_icon_url': 'https...[{'id': 131446073, 'user_id': 2153008, 'native...
25785576752021-05-1357.641461059618.2945406973NoneNone215300855800.0...Plantae02021-05-13T10:27:58.026Z2021-09-03T20:13:37.591Z2021-05-13T10:27:54.000ZNone{'id': 55800, 'name': 'Tulipa', 'rank': 'genus...{'id': 47126, 'name': 'Plantae', 'rank': 'king...{'login': 'visbystar', 'user_icon_url': 'https...[{'id': 128581829, 'user_id': 2153008, 'native...
26785576022021-05-1357.641481761418.2935440072NoneNone2153008NaN...None02021-05-13T10:26:10.161Z2021-09-03T20:13:37.591Z2021-05-13T10:25:55.000ZNoneNaNNaN{'login': 'visbystar', 'user_icon_url': 'https...[{'id': 128581690, 'user_id': 2153008, 'native...
27785575622021-05-1357.641612777718.2941888475NoneNone215300847126.0...Plantae02021-05-13T10:25:19.864Z2021-09-03T20:13:37.591Z2021-05-13T10:25:16.000ZNone{'id': 47126, 'name': 'Plantae', 'rank': 'king...{'id': 47126, 'name': 'Plantae', 'rank': 'king...{'login': 'visbystar', 'user_icon_url': 'https...[{'id': 128581627, 'user_id': 2153008, 'native...
28785575182021-05-1357.641404777518.2937951824NoneNone215300849131.0...Plantae02021-05-13T10:24:35.068Z2021-09-03T20:13:37.591Z2021-05-13T10:24:23.000ZNone{'id': 49131, 'name': 'Myosotis', 'rank': 'gen...{'id': 47126, 'name': 'Plantae', 'rank': 'king...{'login': 'visbystar', 'user_icon_url': 'https...[{'id': 128581565, 'user_id': 2153008, 'native...
29565418852020-08-15None57.641593613718.2899189834NoneNoneThistles and Burdocks2153008632885.0...Plantae02020-08-15T18:24:20.962Z2021-09-03T20:13:37.591Z2020-08-15T18:24:00.000ZNone{'id': 632885, 'name': 'Carduinae', 'rank': 's...{'id': 47126, 'name': 'Plantae', 'rank': 'king...{'login': 'visbystar', 'user_icon_url': 'https...[{'id': 90112914, 'user_id': 2153008, 'native_...
\n", "

30 rows × 62 columns

\n", "
" ], "text/plain": [ " id observed_on description latitude longitude map_scale \\\n", "0 93703607 2021-09-05 57.6472236557 18.2964022665 None \n", "1 93703567 2021-09-05 57.6474204424 18.2965675787 None \n", "2 93703561 2021-09-05 57.647396521 18.2965240628 None \n", "3 93703522 2021-09-05 57.6473967875 18.2965596824 None \n", "4 93703515 2021-09-04 57.5973695738 18.3812708559 None \n", "5 93570041 2021-09-04 57.5947066088 18.377578007 None \n", "6 93570003 2021-09-04 57.5946708833 18.3778277204 None \n", "7 93569913 2021-09-04 57.5944091173 18.3779062817 None \n", "8 93568641 2021-09-04 57.5913717938 18.3741269856 None \n", "9 93568612 2021-09-04 57.5913839973 18.3742810416 None \n", "10 93568595 2021-09-04 57.5914667359 18.3743168644 None \n", "11 93567057 2021-09-04 57.6015688655 18.3822946187 None \n", "12 93566994 2021-09-04 57.5938119583 18.3777858253 None \n", "13 93566973 2021-09-04 57.5937150134 18.3778809479 None \n", "14 93566840 2021-09-04 57.6129785853 18.3877867139 None \n", "15 93566691 2021-09-04 57.5947734961 18.3769838516 None \n", "16 87687354 2021-07-19 57.6417773707 18.2912194229 None \n", "17 87683422 2021-07-19 57.6054586488 18.2831946351 None \n", "18 87194421 2021-07-13 57.63622 18.2912083333 None \n", "19 86386157 2021-07-10 57.3580081217 18.4887930606 None \n", "20 86385001 2021-07-10 57.3897693166 18.5200162896 None \n", "21 84028607 2021-06-22 57.64150045 18.2901916717 None \n", "22 80508791 2021-05-27 57.6368176056 18.2884973455 None \n", "23 80209497 2021-05-25 57.6436845678 18.2947513454 None \n", "24 80209451 2021-05-25 57.6434020316 18.2956144935 None \n", "25 78557675 2021-05-13 57.6414610596 18.2945406973 None \n", "26 78557602 2021-05-13 57.6414817614 18.2935440072 None \n", "27 78557562 2021-05-13 57.6416127777 18.2941888475 None \n", "28 78557518 2021-05-13 57.6414047775 18.2937951824 None \n", "29 56541885 2020-08-15 None 57.6415936137 18.2899189834 None \n", "\n", " timeframe species_guess user_id taxon_id ... \\\n", "0 None murgröna 2153008 55882.0 ... \n", "1 None 2153008 53438.0 ... \n", "2 None Fläder 2153008 765394.0 ... \n", "3 None 2153008 48528.0 ... \n", "4 None oxbärssläktet 2153008 53376.0 ... \n", "5 None Slån 2153008 55811.0 ... \n", "6 None 2153008 131622.0 ... \n", "7 None 2153008 54597.0 ... \n", "8 None rönn 2153008 56063.0 ... \n", "9 None 2153008 50814.0 ... \n", "10 None 2153008 48339.0 ... \n", "11 None Gullris 2153008 118850.0 ... \n", "12 None 2153008 50814.0 ... \n", "13 None 2153008 50814.0 ... \n", "14 None Röda skogsmyror 2153008 1254127.0 ... \n", "15 None 2153008 54597.0 ... \n", "16 None cikoria 2153008 52913.0 ... \n", "17 None cikoria 2153008 52913.0 ... \n", "18 None 2153008 47727.0 ... \n", "19 None 2153008 NaN ... \n", "20 None 2153008 61454.0 ... \n", "21 None ulltistel 2153008 78259.0 ... \n", "22 None aplar 2153008 54500.0 ... \n", "23 None blåregn 2153008 127306.0 ... \n", "24 None 2153008 47125.0 ... \n", "25 None 2153008 55800.0 ... \n", "26 None 2153008 NaN ... \n", "27 None 2153008 47126.0 ... \n", "28 None 2153008 49131.0 ... \n", "29 None Thistles and Burdocks 2153008 632885.0 ... \n", "\n", " iconic_taxon_name faves_count created_at_utc \\\n", "0 Plantae 0 2021-09-05T12:06:22.739Z \n", "1 Plantae 0 2021-09-05T12:05:39.505Z \n", "2 Plantae 0 2021-09-05T12:05:29.392Z \n", "3 Plantae 0 2021-09-05T12:05:10.797Z \n", "4 Plantae 0 2021-09-05T12:04:59.504Z \n", "5 Plantae 0 2021-09-04T11:26:32.446Z \n", "6 Plantae 0 2021-09-04T11:25:54.711Z \n", "7 Fungi 0 2021-09-04T11:24:00.896Z \n", "8 Plantae 0 2021-09-04T11:02:19.222Z \n", "9 Fungi 0 2021-09-04T11:01:42.519Z \n", "10 Fungi 0 2021-09-04T11:01:27.835Z \n", "11 Plantae 0 2021-09-04T10:43:16.071Z \n", "12 Fungi 0 2021-09-04T10:41:33.533Z \n", "13 Fungi 0 2021-09-04T10:41:08.675Z \n", "14 Insecta 0 2021-09-04T10:38:08.271Z \n", "15 Fungi 0 2021-09-04T10:35:55.921Z \n", "16 Plantae 0 2021-07-19T08:49:52.289Z \n", "17 Plantae 0 2021-07-19T07:36:06.121Z \n", "18 Plantae 0 2021-07-15T21:36:24.307Z \n", "19 None 1 2021-07-10T10:49:20.666Z \n", "20 Plantae 0 2021-07-10T10:31:10.365Z \n", "21 Plantae 0 2021-06-22T06:54:28.537Z \n", "22 Plantae 0 2021-05-27T18:30:25.324Z \n", "23 Plantae 0 2021-05-25T06:50:16.809Z \n", "24 Plantae 0 2021-05-25T06:48:39.397Z \n", "25 Plantae 0 2021-05-13T10:27:58.026Z \n", "26 None 0 2021-05-13T10:26:10.161Z \n", "27 Plantae 0 2021-05-13T10:25:19.864Z \n", "28 Plantae 0 2021-05-13T10:24:35.068Z \n", "29 Plantae 0 2020-08-15T18:24:20.962Z \n", "\n", " updated_at_utc time_observed_at_utc \\\n", "0 2021-09-05T12:47:26.627Z 2021-09-05T11:06:19.000Z \n", "1 2021-09-05T15:01:58.027Z 2021-09-05T11:05:21.000Z \n", "2 2021-09-05T16:04:42.007Z 2021-09-05T11:05:05.000Z \n", "3 2021-09-05T15:02:44.674Z 2021-09-05T11:04:49.000Z \n", "4 2021-09-05T16:05:38.763Z 2021-09-04T10:45:13.000Z \n", "5 2021-09-05T12:44:16.969Z 2021-09-04T10:26:28.000Z \n", "6 2021-09-04T15:26:28.947Z 2021-09-04T10:25:51.000Z \n", "7 2021-09-05T17:19:24.975Z 2021-09-04T10:23:44.000Z \n", "8 2021-09-06T08:35:15.828Z 2021-09-04T10:02:15.000Z \n", "9 2021-09-05T17:20:56.308Z 2021-09-04T10:01:38.000Z \n", "10 2021-09-05T17:21:12.736Z 2021-09-04T10:01:23.000Z \n", "11 2021-09-05T12:45:38.395Z 2021-09-04T09:43:11.000Z \n", "12 2021-09-05T17:21:43.421Z 2021-09-04T09:41:29.000Z \n", "13 2021-09-05T17:22:31.055Z 2021-09-04T09:41:00.000Z \n", "14 2021-09-05T12:44:33.804Z 2021-09-04T09:38:03.000Z \n", "15 2021-09-05T15:18:44.575Z 2021-09-04T09:35:48.000Z \n", "16 2021-09-03T20:13:37.591Z 2021-07-19T08:49:48.000Z \n", "17 2021-09-03T20:13:37.591Z 2021-07-19T07:36:01.000Z \n", "18 2021-09-03T20:13:37.591Z 2021-07-13T15:34:48.000Z \n", "19 2021-09-03T20:13:37.591Z 2021-07-10T10:49:14.000Z \n", "20 2021-09-03T20:13:37.591Z 2021-07-10T10:31:05.000Z \n", "21 2021-09-03T20:13:37.591Z 2021-06-22T06:54:12.000Z \n", "22 2021-09-03T20:13:37.591Z 2021-05-27T17:34:34.000Z \n", "23 2021-09-03T20:13:37.591Z 2021-05-25T06:50:11.000Z \n", "24 2021-09-03T20:13:37.591Z 2021-05-25T06:48:34.000Z \n", "25 2021-09-03T20:13:37.591Z 2021-05-13T10:27:54.000Z \n", "26 2021-09-03T20:13:37.591Z 2021-05-13T10:25:55.000Z \n", "27 2021-09-03T20:13:37.591Z 2021-05-13T10:25:16.000Z \n", "28 2021-09-03T20:13:37.591Z 2021-05-13T10:24:23.000Z \n", "29 2021-09-03T20:13:37.591Z 2020-08-15T18:24:00.000Z \n", "\n", " owners_identification_from_vision \\\n", "0 True \n", "1 None \n", "2 None \n", "3 None \n", "4 None \n", "5 False \n", "6 None \n", "7 None \n", "8 None \n", "9 None \n", "10 None \n", "11 False \n", "12 None \n", "13 None \n", "14 False \n", "15 None \n", "16 None \n", "17 None \n", "18 None \n", "19 None \n", "20 None \n", "21 None \n", "22 None \n", "23 None \n", "24 None \n", "25 None \n", "26 None \n", "27 None \n", "28 None \n", "29 None \n", "\n", " taxon \\\n", "0 {'id': 55882, 'name': 'Hedera helix', 'rank': ... \n", "1 {'id': 53438, 'name': 'Rosa', 'rank': 'genus',... \n", "2 {'id': 765394, 'name': 'Sambucus nigra', 'rank... \n", "3 {'id': 48528, 'name': 'Symphoricarpos', 'rank'... \n", "4 {'id': 53376, 'name': 'Cotoneaster', 'rank': '... \n", "5 {'id': 55811, 'name': 'Prunus spinosa', 'rank'... \n", "6 {'id': 131622, 'name': 'Prunella grandiflora',... \n", "7 {'id': 54597, 'name': 'Lactarius', 'rank': 'ge... \n", "8 {'id': 56063, 'name': 'Sorbus aucuparia', 'ran... \n", "9 {'id': 50814, 'name': 'Agaricomycetes', 'rank'... \n", "10 {'id': 48339, 'name': 'Russula', 'rank': 'genu... \n", "11 {'id': 118850, 'name': 'Solidago virgaurea', '... \n", "12 {'id': 50814, 'name': 'Agaricomycetes', 'rank'... \n", "13 {'id': 50814, 'name': 'Agaricomycetes', 'rank'... \n", "14 {'id': 1254127, 'name': 'Formica rufa', 'rank'... \n", "15 {'id': 54597, 'name': 'Lactarius', 'rank': 'ge... \n", "16 {'id': 52913, 'name': 'Cichorium intybus', 'ra... \n", "17 {'id': 52913, 'name': 'Cichorium intybus', 'ra... \n", "18 {'id': 47727, 'name': 'Acer', 'rank': 'genus',... \n", "19 NaN \n", "20 {'id': 61454, 'name': 'Polygonatum odoratum', ... \n", "21 {'id': 78259, 'name': 'Onopordum acanthium', '... \n", "22 {'id': 54500, 'name': 'Malus', 'rank': 'genus'... \n", "23 {'id': 127306, 'name': 'Wisteria sinensis', 'r... \n", "24 {'id': 47125, 'name': 'Angiospermae', 'rank': ... \n", "25 {'id': 55800, 'name': 'Tulipa', 'rank': 'genus... \n", "26 NaN \n", "27 {'id': 47126, 'name': 'Plantae', 'rank': 'king... \n", "28 {'id': 49131, 'name': 'Myosotis', 'rank': 'gen... \n", "29 {'id': 632885, 'name': 'Carduinae', 'rank': 's... \n", "\n", " iconic_taxon \\\n", "0 {'id': 47126, 'name': 'Plantae', 'rank': 'king... \n", "1 {'id': 47126, 'name': 'Plantae', 'rank': 'king... \n", "2 {'id': 47126, 'name': 'Plantae', 'rank': 'king... \n", "3 {'id': 47126, 'name': 'Plantae', 'rank': 'king... \n", "4 {'id': 47126, 'name': 'Plantae', 'rank': 'king... \n", "5 {'id': 47126, 'name': 'Plantae', 'rank': 'king... \n", "6 {'id': 47126, 'name': 'Plantae', 'rank': 'king... \n", "7 {'id': 47170, 'name': 'Fungi', 'rank': 'kingdo... \n", "8 {'id': 47126, 'name': 'Plantae', 'rank': 'king... \n", "9 {'id': 47170, 'name': 'Fungi', 'rank': 'kingdo... \n", "10 {'id': 47170, 'name': 'Fungi', 'rank': 'kingdo... \n", "11 {'id': 47126, 'name': 'Plantae', 'rank': 'king... \n", "12 {'id': 47170, 'name': 'Fungi', 'rank': 'kingdo... \n", "13 {'id': 47170, 'name': 'Fungi', 'rank': 'kingdo... \n", "14 {'id': 47158, 'name': 'Insecta', 'rank': 'clas... \n", "15 {'id': 47170, 'name': 'Fungi', 'rank': 'kingdo... \n", "16 {'id': 47126, 'name': 'Plantae', 'rank': 'king... \n", "17 {'id': 47126, 'name': 'Plantae', 'rank': 'king... \n", "18 {'id': 47126, 'name': 'Plantae', 'rank': 'king... \n", "19 NaN \n", "20 {'id': 47126, 'name': 'Plantae', 'rank': 'king... \n", "21 {'id': 47126, 'name': 'Plantae', 'rank': 'king... \n", "22 {'id': 47126, 'name': 'Plantae', 'rank': 'king... \n", "23 {'id': 47126, 'name': 'Plantae', 'rank': 'king... \n", "24 {'id': 47126, 'name': 'Plantae', 'rank': 'king... \n", "25 {'id': 47126, 'name': 'Plantae', 'rank': 'king... \n", "26 NaN \n", "27 {'id': 47126, 'name': 'Plantae', 'rank': 'king... \n", "28 {'id': 47126, 'name': 'Plantae', 'rank': 'king... \n", "29 {'id': 47126, 'name': 'Plantae', 'rank': 'king... \n", "\n", " user \\\n", "0 {'login': 'visbystar', 'user_icon_url': 'https... \n", "1 {'login': 'visbystar', 'user_icon_url': 'https... \n", "2 {'login': 'visbystar', 'user_icon_url': 'https... \n", "3 {'login': 'visbystar', 'user_icon_url': 'https... \n", "4 {'login': 'visbystar', 'user_icon_url': 'https... \n", "5 {'login': 'visbystar', 'user_icon_url': 'https... \n", "6 {'login': 'visbystar', 'user_icon_url': 'https... \n", "7 {'login': 'visbystar', 'user_icon_url': 'https... \n", "8 {'login': 'visbystar', 'user_icon_url': 'https... \n", "9 {'login': 'visbystar', 'user_icon_url': 'https... \n", "10 {'login': 'visbystar', 'user_icon_url': 'https... \n", "11 {'login': 'visbystar', 'user_icon_url': 'https... \n", "12 {'login': 'visbystar', 'user_icon_url': 'https... \n", "13 {'login': 'visbystar', 'user_icon_url': 'https... \n", "14 {'login': 'visbystar', 'user_icon_url': 'https... \n", "15 {'login': 'visbystar', 'user_icon_url': 'https... \n", "16 {'login': 'visbystar', 'user_icon_url': 'https... \n", "17 {'login': 'visbystar', 'user_icon_url': 'https... \n", "18 {'login': 'visbystar', 'user_icon_url': 'https... \n", "19 {'login': 'visbystar', 'user_icon_url': 'https... \n", "20 {'login': 'visbystar', 'user_icon_url': 'https... \n", "21 {'login': 'visbystar', 'user_icon_url': 'https... \n", "22 {'login': 'visbystar', 'user_icon_url': 'https... \n", "23 {'login': 'visbystar', 'user_icon_url': 'https... \n", "24 {'login': 'visbystar', 'user_icon_url': 'https... \n", "25 {'login': 'visbystar', 'user_icon_url': 'https... \n", "26 {'login': 'visbystar', 'user_icon_url': 'https... \n", "27 {'login': 'visbystar', 'user_icon_url': 'https... \n", "28 {'login': 'visbystar', 'user_icon_url': 'https... \n", "29 {'login': 'visbystar', 'user_icon_url': 'https... \n", "\n", " photos \n", "0 [{'id': 155342556, 'user_id': 2153008, 'native... \n", "1 [{'id': 155341708, 'user_id': 2153008, 'native... \n", "2 [{'id': 155341693, 'user_id': 2153008, 'native... \n", "3 [{'id': 155341645, 'user_id': 2153008, 'native... \n", "4 [{'id': 155341627, 'user_id': 2153008, 'native... \n", "5 [{'id': 155102083, 'user_id': 2153008, 'native... \n", "6 [{'id': 155102015, 'user_id': 2153008, 'native... \n", "7 [{'id': 155101833, 'user_id': 2153008, 'native... \n", "8 [{'id': 155101820, 'user_id': 2153008, 'native... \n", "9 [{'id': 155099959, 'user_id': 2153008, 'native... \n", "10 [{'id': 155099938, 'user_id': 2153008, 'native... \n", "11 [{'id': 155098378, 'user_id': 2153008, 'native... \n", "12 [{'id': 155098247, 'user_id': 2153008, 'native... \n", "13 [{'id': 155098207, 'user_id': 2153008, 'native... \n", "14 [{'id': 155098006, 'user_id': 2153008, 'native... \n", "15 [{'id': 155097879, 'user_id': 2153008, 'native... \n", "16 [{'id': 144599404, 'user_id': 2153008, 'native... \n", "17 [{'id': 144592107, 'user_id': 2153008, 'native... \n", "18 [{'id': 143716593, 'user_id': 2153008, 'native... \n", "19 [{'id': 142306550, 'user_id': 2153008, 'native... \n", "20 [{'id': 142303197, 'user_id': 2153008, 'native... \n", "21 [{'id': 138065293, 'user_id': 2153008, 'native... \n", "22 [{'id': 131961340, 'user_id': 2153008, 'native... \n", "23 [{'id': 131446171, 'user_id': 2153008, 'native... \n", "24 [{'id': 131446073, 'user_id': 2153008, 'native... \n", "25 [{'id': 128581829, 'user_id': 2153008, 'native... \n", "26 [{'id': 128581690, 'user_id': 2153008, 'native... \n", "27 [{'id': 128581627, 'user_id': 2153008, 'native... \n", "28 [{'id': 128581565, 'user_id': 2153008, 'native... \n", "29 [{'id': 90112914, 'user_id': 2153008, 'native_... \n", "\n", "[30 rows x 62 columns]" ] }, "execution_count": 7, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df" ] }, { "cell_type": "code", "execution_count": 8, "id": "a43c0fd4", "metadata": {}, "outputs": [], "source": [ "dfNorm = pd.json_normalize(data)" ] }, { "cell_type": "code", "execution_count": 9, "id": "1d8bbde6", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
idobserved_ondescriptionlatitudelongitudemap_scaletimeframespecies_guessuser_idtaxon_id...taxon.common_name.is_validtaxon.common_name.lexiconiconic_taxon.idiconic_taxon.nameiconic_taxon.rankiconic_taxon.rank_leveliconic_taxon.ancestryuser.loginuser.user_icon_urltaxon.common_name
0937036072021-09-0557.647223655718.2964022665NoneNonemurgröna215300855882.0...TrueEnglish47126.0Plantaekingdom70.048460visbystarhttps://static.inaturalist.org/attachments/use...NaN
1937035672021-09-0557.647420442418.2965675787NoneNone215300853438.0...TrueEnglish47126.0Plantaekingdom70.048460visbystarhttps://static.inaturalist.org/attachments/use...NaN
2937035612021-09-0557.64739652118.2965240628NoneNoneFläder2153008765394.0...TrueEnglish47126.0Plantaekingdom70.048460visbystarhttps://static.inaturalist.org/attachments/use...NaN
3937035222021-09-0557.647396787518.2965596824NoneNone215300848528.0...TrueEnglish47126.0Plantaekingdom70.048460visbystarhttps://static.inaturalist.org/attachments/use...NaN
4937035152021-09-0457.597369573818.3812708559NoneNoneoxbärssläktet215300853376.0...TrueEnglish47126.0Plantaekingdom70.048460visbystarhttps://static.inaturalist.org/attachments/use...NaN
5935700412021-09-0457.594706608818.377578007NoneNoneSlån215300855811.0...TrueEnglish47126.0Plantaekingdom70.048460visbystarhttps://static.inaturalist.org/attachments/use...NaN
6935700032021-09-0457.594670883318.3778277204NoneNone2153008131622.0...TrueEnglish47126.0Plantaekingdom70.048460visbystarhttps://static.inaturalist.org/attachments/use...NaN
7935699132021-09-0457.594409117318.3779062817NoneNone215300854597.0...TrueEnglish47170.0Fungikingdom70.048460visbystarhttps://static.inaturalist.org/attachments/use...NaN
8935686412021-09-0457.591371793818.3741269856NoneNonerönn215300856063.0...TrueEnglish47126.0Plantaekingdom70.048460visbystarhttps://static.inaturalist.org/attachments/use...NaN
9935686122021-09-0457.591383997318.3742810416NoneNone215300850814.0...NaNNaN47170.0Fungikingdom70.048460visbystarhttps://static.inaturalist.org/attachments/use...NaN
10935685952021-09-0457.591466735918.3743168644NoneNone215300848339.0...TrueEnglish47170.0Fungikingdom70.048460visbystarhttps://static.inaturalist.org/attachments/use...NaN
11935670572021-09-0457.601568865518.3822946187NoneNoneGullris2153008118850.0...TrueEnglish47126.0Plantaekingdom70.048460visbystarhttps://static.inaturalist.org/attachments/use...NaN
12935669942021-09-0457.593811958318.3777858253NoneNone215300850814.0...NaNNaN47170.0Fungikingdom70.048460visbystarhttps://static.inaturalist.org/attachments/use...NaN
13935669732021-09-0457.593715013418.3778809479NoneNone215300850814.0...NaNNaN47170.0Fungikingdom70.048460visbystarhttps://static.inaturalist.org/attachments/use...NaN
14935668402021-09-0457.612978585318.3877867139NoneNoneRöda skogsmyror21530081254127.0...TrueEnglish47158.0Insectaclass50.048460/1/47120/372739visbystarhttps://static.inaturalist.org/attachments/use...NaN
15935666912021-09-0457.594773496118.3769838516NoneNone215300854597.0...TrueEnglish47170.0Fungikingdom70.048460visbystarhttps://static.inaturalist.org/attachments/use...NaN
16876873542021-07-1957.641777370718.2912194229NoneNonecikoria215300852913.0...TrueEnglish47126.0Plantaekingdom70.048460visbystarhttps://static.inaturalist.org/attachments/use...NaN
17876834222021-07-1957.605458648818.2831946351NoneNonecikoria215300852913.0...TrueEnglish47126.0Plantaekingdom70.048460visbystarhttps://static.inaturalist.org/attachments/use...NaN
18871944212021-07-1357.6362218.2912083333NoneNone215300847727.0...TrueEnglish47126.0Plantaekingdom70.048460visbystarhttps://static.inaturalist.org/attachments/use...NaN
19863861572021-07-1057.358008121718.4887930606NoneNone2153008NaN...NaNNaNNaNNaNNaNNaNNaNvisbystarhttps://static.inaturalist.org/attachments/use...NaN
20863850012021-07-1057.389769316618.5200162896NoneNone215300861454.0...TrueEnglish47126.0Plantaekingdom70.048460visbystarhttps://static.inaturalist.org/attachments/use...NaN
21840286072021-06-2257.6415004518.2901916717NoneNoneulltistel215300878259.0...TrueEnglish47126.0Plantaekingdom70.048460visbystarhttps://static.inaturalist.org/attachments/use...NaN
22805087912021-05-2757.636817605618.2884973455NoneNoneaplar215300854500.0...TrueEnglish47126.0Plantaekingdom70.048460visbystarhttps://static.inaturalist.org/attachments/use...NaN
23802094972021-05-2557.643684567818.2947513454NoneNoneblåregn2153008127306.0...TrueEnglish47126.0Plantaekingdom70.048460visbystarhttps://static.inaturalist.org/attachments/use...NaN
24802094512021-05-2557.643402031618.2956144935NoneNone215300847125.0...TrueEnglish47126.0Plantaekingdom70.048460visbystarhttps://static.inaturalist.org/attachments/use...NaN
25785576752021-05-1357.641461059618.2945406973NoneNone215300855800.0...TrueEnglish47126.0Plantaekingdom70.048460visbystarhttps://static.inaturalist.org/attachments/use...NaN
26785576022021-05-1357.641481761418.2935440072NoneNone2153008NaN...NaNNaNNaNNaNNaNNaNNaNvisbystarhttps://static.inaturalist.org/attachments/use...NaN
27785575622021-05-1357.641612777718.2941888475NoneNone215300847126.0...TrueEnglish47126.0Plantaekingdom70.048460visbystarhttps://static.inaturalist.org/attachments/use...NaN
28785575182021-05-1357.641404777518.2937951824NoneNone215300849131.0...TrueEnglish47126.0Plantaekingdom70.048460visbystarhttps://static.inaturalist.org/attachments/use...NaN
29565418852020-08-15None57.641593613718.2899189834NoneNoneThistles and Burdocks2153008632885.0...TrueEnglish47126.0Plantaekingdom70.048460visbystarhttps://static.inaturalist.org/attachments/use...NaN
\n", "

30 rows × 75 columns

\n", "
" ], "text/plain": [ " id observed_on description latitude longitude map_scale \\\n", "0 93703607 2021-09-05 57.6472236557 18.2964022665 None \n", "1 93703567 2021-09-05 57.6474204424 18.2965675787 None \n", "2 93703561 2021-09-05 57.647396521 18.2965240628 None \n", "3 93703522 2021-09-05 57.6473967875 18.2965596824 None \n", "4 93703515 2021-09-04 57.5973695738 18.3812708559 None \n", "5 93570041 2021-09-04 57.5947066088 18.377578007 None \n", "6 93570003 2021-09-04 57.5946708833 18.3778277204 None \n", "7 93569913 2021-09-04 57.5944091173 18.3779062817 None \n", "8 93568641 2021-09-04 57.5913717938 18.3741269856 None \n", "9 93568612 2021-09-04 57.5913839973 18.3742810416 None \n", "10 93568595 2021-09-04 57.5914667359 18.3743168644 None \n", "11 93567057 2021-09-04 57.6015688655 18.3822946187 None \n", "12 93566994 2021-09-04 57.5938119583 18.3777858253 None \n", "13 93566973 2021-09-04 57.5937150134 18.3778809479 None \n", "14 93566840 2021-09-04 57.6129785853 18.3877867139 None \n", "15 93566691 2021-09-04 57.5947734961 18.3769838516 None \n", "16 87687354 2021-07-19 57.6417773707 18.2912194229 None \n", "17 87683422 2021-07-19 57.6054586488 18.2831946351 None \n", "18 87194421 2021-07-13 57.63622 18.2912083333 None \n", "19 86386157 2021-07-10 57.3580081217 18.4887930606 None \n", "20 86385001 2021-07-10 57.3897693166 18.5200162896 None \n", "21 84028607 2021-06-22 57.64150045 18.2901916717 None \n", "22 80508791 2021-05-27 57.6368176056 18.2884973455 None \n", "23 80209497 2021-05-25 57.6436845678 18.2947513454 None \n", "24 80209451 2021-05-25 57.6434020316 18.2956144935 None \n", "25 78557675 2021-05-13 57.6414610596 18.2945406973 None \n", "26 78557602 2021-05-13 57.6414817614 18.2935440072 None \n", "27 78557562 2021-05-13 57.6416127777 18.2941888475 None \n", "28 78557518 2021-05-13 57.6414047775 18.2937951824 None \n", "29 56541885 2020-08-15 None 57.6415936137 18.2899189834 None \n", "\n", " timeframe species_guess user_id taxon_id ... \\\n", "0 None murgröna 2153008 55882.0 ... \n", "1 None 2153008 53438.0 ... \n", "2 None Fläder 2153008 765394.0 ... \n", "3 None 2153008 48528.0 ... \n", "4 None oxbärssläktet 2153008 53376.0 ... \n", "5 None Slån 2153008 55811.0 ... \n", "6 None 2153008 131622.0 ... \n", "7 None 2153008 54597.0 ... \n", "8 None rönn 2153008 56063.0 ... \n", "9 None 2153008 50814.0 ... \n", "10 None 2153008 48339.0 ... \n", "11 None Gullris 2153008 118850.0 ... \n", "12 None 2153008 50814.0 ... \n", "13 None 2153008 50814.0 ... \n", "14 None Röda skogsmyror 2153008 1254127.0 ... \n", "15 None 2153008 54597.0 ... \n", "16 None cikoria 2153008 52913.0 ... \n", "17 None cikoria 2153008 52913.0 ... \n", "18 None 2153008 47727.0 ... \n", "19 None 2153008 NaN ... \n", "20 None 2153008 61454.0 ... \n", "21 None ulltistel 2153008 78259.0 ... \n", "22 None aplar 2153008 54500.0 ... \n", "23 None blåregn 2153008 127306.0 ... \n", "24 None 2153008 47125.0 ... \n", "25 None 2153008 55800.0 ... \n", "26 None 2153008 NaN ... \n", "27 None 2153008 47126.0 ... \n", "28 None 2153008 49131.0 ... \n", "29 None Thistles and Burdocks 2153008 632885.0 ... \n", "\n", " taxon.common_name.is_valid taxon.common_name.lexicon iconic_taxon.id \\\n", "0 True English 47126.0 \n", "1 True English 47126.0 \n", "2 True English 47126.0 \n", "3 True English 47126.0 \n", "4 True English 47126.0 \n", "5 True English 47126.0 \n", "6 True English 47126.0 \n", "7 True English 47170.0 \n", "8 True English 47126.0 \n", "9 NaN NaN 47170.0 \n", "10 True English 47170.0 \n", "11 True English 47126.0 \n", "12 NaN NaN 47170.0 \n", "13 NaN NaN 47170.0 \n", "14 True English 47158.0 \n", "15 True English 47170.0 \n", "16 True English 47126.0 \n", "17 True English 47126.0 \n", "18 True English 47126.0 \n", "19 NaN NaN NaN \n", "20 True English 47126.0 \n", "21 True English 47126.0 \n", "22 True English 47126.0 \n", "23 True English 47126.0 \n", "24 True English 47126.0 \n", "25 True English 47126.0 \n", "26 NaN NaN NaN \n", "27 True English 47126.0 \n", "28 True English 47126.0 \n", "29 True English 47126.0 \n", "\n", " iconic_taxon.name iconic_taxon.rank iconic_taxon.rank_level \\\n", "0 Plantae kingdom 70.0 \n", "1 Plantae kingdom 70.0 \n", "2 Plantae kingdom 70.0 \n", "3 Plantae kingdom 70.0 \n", "4 Plantae kingdom 70.0 \n", "5 Plantae kingdom 70.0 \n", "6 Plantae kingdom 70.0 \n", "7 Fungi kingdom 70.0 \n", "8 Plantae kingdom 70.0 \n", "9 Fungi kingdom 70.0 \n", "10 Fungi kingdom 70.0 \n", "11 Plantae kingdom 70.0 \n", "12 Fungi kingdom 70.0 \n", "13 Fungi kingdom 70.0 \n", "14 Insecta class 50.0 \n", "15 Fungi kingdom 70.0 \n", "16 Plantae kingdom 70.0 \n", "17 Plantae kingdom 70.0 \n", "18 Plantae kingdom 70.0 \n", "19 NaN NaN NaN \n", "20 Plantae kingdom 70.0 \n", "21 Plantae kingdom 70.0 \n", "22 Plantae kingdom 70.0 \n", "23 Plantae kingdom 70.0 \n", "24 Plantae kingdom 70.0 \n", "25 Plantae kingdom 70.0 \n", "26 NaN NaN NaN \n", "27 Plantae kingdom 70.0 \n", "28 Plantae kingdom 70.0 \n", "29 Plantae kingdom 70.0 \n", "\n", " iconic_taxon.ancestry user.login \\\n", "0 48460 visbystar \n", "1 48460 visbystar \n", "2 48460 visbystar \n", "3 48460 visbystar \n", "4 48460 visbystar \n", "5 48460 visbystar \n", "6 48460 visbystar \n", "7 48460 visbystar \n", "8 48460 visbystar \n", "9 48460 visbystar \n", "10 48460 visbystar \n", "11 48460 visbystar \n", "12 48460 visbystar \n", "13 48460 visbystar \n", "14 48460/1/47120/372739 visbystar \n", "15 48460 visbystar \n", "16 48460 visbystar \n", "17 48460 visbystar \n", "18 48460 visbystar \n", "19 NaN visbystar \n", "20 48460 visbystar \n", "21 48460 visbystar \n", "22 48460 visbystar \n", "23 48460 visbystar \n", "24 48460 visbystar \n", "25 48460 visbystar \n", "26 NaN visbystar \n", "27 48460 visbystar \n", "28 48460 visbystar \n", "29 48460 visbystar \n", "\n", " user.user_icon_url taxon.common_name \n", "0 https://static.inaturalist.org/attachments/use... NaN \n", "1 https://static.inaturalist.org/attachments/use... NaN \n", "2 https://static.inaturalist.org/attachments/use... NaN \n", "3 https://static.inaturalist.org/attachments/use... NaN \n", "4 https://static.inaturalist.org/attachments/use... NaN \n", "5 https://static.inaturalist.org/attachments/use... NaN \n", "6 https://static.inaturalist.org/attachments/use... NaN \n", "7 https://static.inaturalist.org/attachments/use... NaN \n", "8 https://static.inaturalist.org/attachments/use... NaN \n", "9 https://static.inaturalist.org/attachments/use... NaN \n", "10 https://static.inaturalist.org/attachments/use... NaN \n", "11 https://static.inaturalist.org/attachments/use... NaN \n", "12 https://static.inaturalist.org/attachments/use... NaN \n", "13 https://static.inaturalist.org/attachments/use... NaN \n", "14 https://static.inaturalist.org/attachments/use... NaN \n", "15 https://static.inaturalist.org/attachments/use... NaN \n", "16 https://static.inaturalist.org/attachments/use... NaN \n", "17 https://static.inaturalist.org/attachments/use... NaN \n", "18 https://static.inaturalist.org/attachments/use... NaN \n", "19 https://static.inaturalist.org/attachments/use... NaN \n", "20 https://static.inaturalist.org/attachments/use... NaN \n", "21 https://static.inaturalist.org/attachments/use... NaN \n", "22 https://static.inaturalist.org/attachments/use... NaN \n", "23 https://static.inaturalist.org/attachments/use... NaN \n", "24 https://static.inaturalist.org/attachments/use... NaN \n", "25 https://static.inaturalist.org/attachments/use... NaN \n", "26 https://static.inaturalist.org/attachments/use... NaN \n", "27 https://static.inaturalist.org/attachments/use... NaN \n", "28 https://static.inaturalist.org/attachments/use... NaN \n", "29 https://static.inaturalist.org/attachments/use... NaN \n", "\n", "[30 rows x 75 columns]" ] }, "execution_count": 9, "metadata": {}, "output_type": "execute_result" } ], "source": [ "dfNorm" ] }, { "cell_type": "code", "execution_count": null, "id": "ed4b7969", "metadata": {}, "outputs": [], "source": [] } ], "metadata": { "kernelspec": { "display_name": "Python 3", "language": "python", "name": "python3" }, "language_info": { "codemirror_mode": { "name": "ipython", "version": 3 }, "file_extension": ".py", "mimetype": "text/x-python", "name": "python", "nbconvert_exporter": "python", "pygments_lexer": "ipython3", "version": "3.9.4" } }, "nbformat": 4, "nbformat_minor": 5 }