In [32]:
import json
from pprint import pprint
import pandas as pd
In [33]:
json_resp = None
with open("pocket_data_response.json") as f:
json_resp = json.load(f)
In [34]:
pprint(json_resp['list'])
{u'1210838131': {u'authors': {u'46599448': {u'author_id': u'46599448',
u'item_id': u'1210838131',
u'name': u'Juraj Somorovsky',
u'url': u'https://www.nds.rub.de/chair/people/jsomorovsky/'},
u'46599449': {u'author_id': u'46599449',
u'item_id': u'1210838131',
u'name': u'Emilia K\xe4sper',
u'url': u'http://research.google.com/pubs/author58129.html'}},
u'excerpt': u'DROWN is a serious vulnerability that affects HTTPS and other services that rely on SSL and TLS, some of the essential cryptographic protocols for Internet security.',
u'favorite': u'0',
u'given_title': u'DROWN Attack',
u'given_url': u'https://drownattack.com/',
u'has_image': u'1',
u'has_video': u'0',
u'image': {u'height': u'0',
u'item_id': u'1210838131',
u'src': u'https://drownattack.com/media/img/DROWN_diagram1.jpg',
u'width': u'0'},
u'images': {u'1': {u'caption': u'',
u'credit': u'',
u'height': u'0',
u'image_id': u'1',
u'item_id': u'1210838131',
u'src': u'https://drownattack.com/media/img/DROWN_diagram1.jpg',
u'width': u'0'},
u'2': {u'caption': u'',
u'credit': u'',
u'height': u'0',
u'image_id': u'2',
u'item_id': u'1210838131',
u'src': u'https://drownattack.com/media/img/DROWN_diagram.jpg',
u'width': u'0'}},
u'is_article': u'0',
u'is_index': u'1',
u'item_id': u'1210838131',
u'resolved_id': u'1210838131',
u'resolved_title': u'The DROWN Attack',
u'resolved_url': u'http://drownattack.com',
u'sort_id': 4,
u'status': u'0',
u'tags': {u'devops': {u'item_id': u'1210838131',
u'tag': u'devops'}},
u'time_added': u'1457642774',
u'time_favorited': u'0',
u'time_read': u'0',
u'time_updated': u'1457642778',
u'word_count': u'2827'},
u'1213240057': {u'authors': {u'2358182': {u'author_id': u'2358182',
u'item_id': u'1213240057',
u'name': u'Tom Fishburne',
u'url': u''}},
u'excerpt': u'After a year and half, we\u2019d finally admitted to ourselves that the mobile travel app we were working on was never going to take off.\xa0Luckily, we still had three committed founders and over $100K left in the bank.',
u'favorite': u'0',
u'given_title': u'',
u'given_url': u'http://blog.userinterviews.co/2016/02/18/how-the-lean-startup-took-us-from-failure-to-50-paying-clients/?utm_campaign=Submission&utm_medium=Community&utm_source=GrowthHackers.com',
u'has_image': u'1',
u'has_video': u'0',
u'image': {u'height': u'360',
u'item_id': u'1213240057',
u'src': u'http://blog.userinterviews.co/wp-content/uploads/2016/02/chart-1-v3.png',
u'width': u'640'},
u'images': {u'1': {u'caption': u'',
u'credit': u'',
u'height': u'360',
u'image_id': u'1',
u'item_id': u'1213240057',
u'src': u'http://blog.userinterviews.co/wp-content/uploads/2016/02/chart-1-v3.png',
u'width': u'640'},
u'2': {u'caption': u'',
u'credit': u'',
u'height': u'247',
u'image_id': u'2',
u'item_id': u'1213240057',
u'src': u'http://blog.userinterviews.co/wp-content/uploads/2016/02/chart-2-2.png',
u'width': u'640'},
u'3': {u'caption': u'',
u'credit': u'',
u'height': u'353',
u'image_id': u'3',
u'item_id': u'1213240057',
u'src': u'http://blog.userinterviews.co/wp-content/uploads/2016/02/assumptions-1.png',
u'width': u'640'},
u'4': {u'caption': u'',
u'credit': u'',
u'height': u'400',
u'image_id': u'4',
u'item_id': u'1213240057',
u'src': u'http://blog.userinterviews.co/wp-content/uploads/2016/02/assumptions-2-1.png',
u'width': u'640'},
u'5': {u'caption': u'',
u'credit': u'',
u'height': u'587',
u'image_id': u'5',
u'item_id': u'1213240057',
u'src': u'http://blog.userinterviews.co/wp-content/uploads/2016/02/google-form-v2.png',
u'width': u'640'}},
u'is_article': u'1',
u'is_index': u'0',
u'item_id': u'1213240057',
u'resolved_id': u'1213240057',
u'resolved_title': u'How \u2018Lean Startup\u2019 Took Us From Failure to 50 Paying Clients',
u'resolved_url': u'http://blog.userinterviews.co/2016/02/18/how-the-lean-startup-took-us-from-failure-to-50-paying-clients/?utm_campaign=Submission&utm_medium=Community&utm_source=GrowthHackers.com',
u'sort_id': 8,
u'status': u'0',
u'time_added': u'1457328821',
u'time_favorited': u'0',
u'time_read': u'0',
u'time_updated': u'1457328821',
u'word_count': u'1326'},
u'1216069057': {u'excerpt': u'Writing your own TCP/IP stack may seem like a daunting task. Indeed, TCP has accumulated many specifications over its lifetime of more than thirty years.',
u'favorite': u'0',
u'given_title': u'',
u'given_url': u'http://www.saminiir.com/lets-code-tcp-ip-stack-1-ethernet-arp',
u'has_image': u'0',
u'has_video': u'0',
u'is_article': u'1',
u'is_index': u'0',
u'item_id': u'1216069057',
u'resolved_id': u'1216069057',
u'resolved_title': u"Let's code a TCP/IP stack, 1: Ethernet & ARP",
u'resolved_url': u'http://www.saminiir.com/lets-code-tcp-ip-stack-1-ethernet-arp',
u'sort_id': 9,
u'status': u'0',
u'time_added': u'1457323305',
u'time_favorited': u'0',
u'time_read': u'0',
u'time_updated': u'1457323305',
u'word_count': u'1451'},
u'1220830305': {u'excerpt': u"Hey! I'm James, and I fiddle with code and infrastructure in my spare time. You can find my projects on GitHub, including: Maybe you'll bump into me getting overexcited about the possibilities of apparently banal pieces of software or technology at the next FOSDEM, or the next CfgMgmtCamp.",
u'favorite': u'0',
u'given_title': u'Geek // James Belchamber // Contractor. Consultant. Geek.',
u'given_url': u'http://james.belchamber.com/pages/geek.html',
u'has_image': u'0',
u'has_video': u'0',
u'is_article': u'1',
u'is_index': u'0',
u'item_id': u'1220830305',
u'resolved_id': u'1220830305',
u'resolved_title': u'Geek // James Belchamber // Contractor. Consultant. Geek.',
u'resolved_url': u'http://james.belchamber.com/pages/geek.html',
u'sort_id': 5,
u'status': u'0',
u'tags': {u'consulting': {u'item_id': u'1220830305',
u'tag': u'consulting'}},
u'time_added': u'1457642757',
u'time_favorited': u'0',
u'time_read': u'0',
u'time_updated': u'1460150160',
u'word_count': u'75'},
u'1233355174': {u'excerpt': u'Bingo Card Creator was my first business. I started it in 2006 as something between a hobby and a dare. It makes bingo cards for elementary schoolteachers. Originally it was a Java Swing app. Since 2009 it\u2019s been almost exclusively a SaaS app running on Rails.',
u'favorite': u'0',
u'given_title': u'',
u'given_url': u'https://training.kalzumeus.com/newsletters/archive/selling_software_business',
u'has_image': u'0',
u'has_video': u'0',
u'is_article': u'1',
u'is_index': u'0',
u'item_id': u'1233355174',
u'resolved_id': u'1233355174',
u'resolved_title': u'What I Learned Selling Bingo Card Creator',
u'resolved_url': u'https://training.kalzumeus.com/newsletters/archive/selling_software_business',
u'sort_id': 0,
u'status': u'0',
u'time_added': u'1458793976',
u'time_favorited': u'0',
u'time_read': u'0',
u'time_updated': u'1462220037',
u'word_count': u'4007'},
u'139521435': {u'authors': {u'2035474': {u'author_id': u'2035474',
u'item_id': u'139521435',
u'name': u'Nick Craver',
u'url': u'http://nickcraver.com/blog/about/'}},
u'excerpt': u'A question we often get asked at Stack Exchange is why stackoverflow.com and all our other domains aren\u2019t served over SSL.\xa0 It\u2019s a user request we see at least a few times a month asking to ensure their security and privacy.',
u'favorite': u'0',
u'given_title': u'Nick Craver - Software Imagineering',
u'given_url': u'http://nickcraver.com/blog/',
u'has_image': u'1',
u'has_video': u'0',
u'image': {u'height': u'0',
u'item_id': u'139521435',
u'src': u'http://nickcraver.com/blog/wp-content/uploads/2013/04/nginx-layout.png',
u'width': u'100'},
u'images': {u'1': {u'caption': u'',
u'credit': u'',
u'height': u'0',
u'image_id': u'1',
u'item_id': u'139521435',
u'src': u'http://nickcraver.com/blog/wp-content/uploads/2013/04/nginx-layout.png',
u'width': u'100'}},
u'is_article': u'1',
u'is_index': u'1',
u'item_id': u'139521435',
u'resolved_id': u'139521435',
u'resolved_title': u'Nick Craver',
u'resolved_url': u'http://nickcraver.com/blog',
u'sort_id': 3,
u'status': u'0',
u'tags': {u'devops': {u'item_id': u'139521435',
u'tag': u'devops'}},
u'time_added': u'1457642797',
u'time_favorited': u'0',
u'time_read': u'0',
u'time_updated': u'1457642806',
u'word_count': u'1503'},
u'29224026': {u'excerpt': u'People are interesting. We know so little about ourselves compared to what we\u2019d like to think we know. We\u2019re all subtly different even though we\u2019re, on a whole, overwhelmingly predictable.',
u'favorite': u'0',
u'given_title': u'Alex Sexton',
u'given_url': u'https://alexsexton.com/',
u'has_image': u'1',
u'has_video': u'0',
u'image': {u'height': u'0',
u'item_id': u'29224026',
u'src': u'https://alexsexton.com/images/prod_cycle/focuswave.png',
u'width': u'0'},
u'images': {u'1': {u'caption': u'',
u'credit': u'',
u'height': u'0',
u'image_id': u'1',
u'item_id': u'29224026',
u'src': u'https://alexsexton.com/images/prod_cycle/focuswave.png',
u'width': u'0'},
u'2': {u'caption': u'',
u'credit': u'',
u'height': u'0',
u'image_id': u'2',
u'item_id': u'29224026',
u'src': u'https://alexsexton.com/images/prod_cycle/cake.jpg',
u'width': u'0'},
u'3': {u'caption': u'',
u'credit': u'',
u'height': u'0',
u'image_id': u'3',
u'item_id': u'29224026',
u'src': u'https://alexsexton.com/images/prod_cycle/wavearea.jpg',
u'width': u'0'}},
u'is_article': u'0',
u'is_index': u'1',
u'item_id': u'29224026',
u'resolved_id': u'29224026',
u'resolved_title': u'Alex Sexton',
u'resolved_url': u'http://alexsexton.com',
u'sort_id': 6,
u'status': u'0',
u'tags': {u'js': {u'item_id': u'29224026', u'tag': u'js'}},
u'time_added': u'1457642744',
u'time_favorited': u'0',
u'time_read': u'0',
u'time_updated': u'1457642751',
u'word_count': u'2217'},
u'534817761': {u'excerpt': u'For the past few weeks, I have been working on integrating Docker and Jenkins in order to improve the continuous integration workflow of a project I work on. The first step is to install Jenkins on the CI server. You could either install it manually or run it from a Docker image.',
u'favorite': u'0',
u'given_title': u'Integrating Docker with Jenkins for continuous deployment of a Ruby on Rail',
u'given_url': u'http://www.powpark.com/blog/programming/2014/01/29/integrating-docker-with-jenkins-for-ruby-on-rails-app',
u'has_image': u'0',
u'has_video': u'0',
u'is_article': u'1',
u'is_index': u'0',
u'item_id': u'534817761',
u'resolved_id': u'534817761',
u'resolved_title': u'Integrating Docker with Jenkins for continuous deployment of a Ruby on Rails application',
u'resolved_url': u'http://www.powpark.com/blog/programming/2014/01/29/integrating-docker-with-jenkins-for-ruby-on-rails-app',
u'sort_id': 2,
u'status': u'0',
u'tags': {u'docker': {u'item_id': u'534817761',
u'tag': u'docker'}},
u'time_added': u'1458383433',
u'time_favorited': u'0',
u'time_read': u'0',
u'time_updated': u'1458383438',
u'word_count': u'926'},
u'879874745': {u'authors': {u'46989754': {u'author_id': u'46989754',
u'item_id': u'879874745',
u'name': u'Colin Eberhardt',
u'url': u'https://www.raywenderlich.com/u/colineberhardt'}},
u'excerpt': u'People have been using JavaScript and HTML5 to create iOS applications using the PhoneGap wrapper for a number of years, so is React Native really such a big deal? The key point with React Native is that it aims to primarily bring the power of the React programming model to mobile app development.',
u'favorite': u'0',
u'given_title': u'React Native Tutorial: Building Apps with JavaScript',
u'given_url': u'https://www.raywenderlich.com/99473/introducing-react-native-building-apps-javascript',
u'has_image': u'1',
u'has_video': u'0',
u'image': {u'height': u'250',
u'item_id': u'879874745',
u'src': u'http://www.raywenderlich.com/wp-content/uploads/2015/03/logo-250x250.png',
u'width': u'250'},
u'images': {u'1': {u'caption': u'React Native: Build native iOS applications with JavaScript.',
u'credit': u'',
u'height': u'250',
u'image_id': u'1',
u'item_id': u'879874745',
u'src': u'http://www.raywenderlich.com/wp-content/uploads/2015/03/logo-250x250.png',
u'width': u'250'},
u'10': {u'caption': u'',
u'credit': u'',
u'height': u'459',
u'image_id': u'10',
u'item_id': u'879874745',
u'src': u'http://www.raywenderlich.com/wp-content/uploads/2015/03/AddingHouseImage.png',
u'width': u'700'},
u'11': {u'caption': u'',
u'credit': u'',
u'height': u'500',
u'image_id': u'11',
u'item_id': u'879874745',
u'src': u'http://www.raywenderlich.com/wp-content/uploads/2015/03/react-searchpagehouse.png',
u'width': u'281'},
u'12': {u'caption': u'',
u'credit': u'',
u'height': u'73',
u'image_id': u'12',
u'item_id': u'879874745',
u'src': u'http://www.raywenderlich.com/wp-content/uploads/2015/03/react-renderconsole.png',
u'width': u'235'},
u'13': {u'caption': u'',
u'credit': u'',
u'height': u'169',
u'image_id': u'13',
u'item_id': u'879874745',
u'src': u'http://www.raywenderlich.com/wp-content/uploads/2015/03/SearchAcitivityIndicator.png',
u'width': u'700'},
u'14': {u'caption': u'',
u'credit': u'',
u'height': u'500',
u'image_id': u'14',
u'item_id': u'879874745',
u'src': u'http://www.raywenderlich.com/wp-content/uploads/2015/03/react-narnia.png',
u'width': u'281'},
u'15': {u'caption': u'',
u'credit': u'',
u'height': u'500',
u'image_id': u'15',
u'item_id': u'879874745',
u'src': u'http://www.raywenderlich.com/wp-content/uploads/2015/03/react-searchresults1.png',
u'width': u'281'},
u'16': {u'caption': u'',
u'credit': u'',
u'height': u'500',
u'image_id': u'16',
u'item_id': u'879874745',
u'src': u'http://www.raywenderlich.com/wp-content/uploads/2015/03/react-searchresults2.png',
u'width': u'281'},
u'17': {u'caption': u'',
u'credit': u'',
u'height': u'500',
u'image_id': u'17',
u'item_id': u'879874745',
u'src': u'http://www.raywenderlich.com/wp-content/uploads/2015/03/react-property.png',
u'width': u'281'},
u'18': {u'caption': u'',
u'credit': u'',
u'height': u'162',
u'image_id': u'18',
u'item_id': u'879874745',
u'src': u'http://www.raywenderlich.com/wp-content/uploads/2015/03/Screen-Shot-2015-03-20-at-21.49.06.png',
u'width': u'480'},
u'19': {u'caption': u'',
u'credit': u'',
u'height': u'500',
u'image_id': u'19',
u'item_id': u'879874745',
u'src': u'http://www.raywenderlich.com/wp-content/uploads/2015/03/WhitleyBaySearch.png',
u'width': u'647'},
u'2': {u'caption': u'',
u'credit': u'',
u'height': u'360',
u'image_id': u'2',
u'item_id': u'879874745',
u'src': u'http://www.raywenderlich.com/wp-content/uploads/2015/03/PropertyFinder.png',
u'width': u'700'},
u'3': {u'caption': u'',
u'credit': u'',
u'height': u'500',
u'image_id': u'3',
u'item_id': u'879874745',
u'src': u'http://www.raywenderlich.com/wp-content/uploads/2015/03/ReactNative-Starter.png',
u'width': u'281'},
u'4': {u'caption': u'',
u'credit': u'',
u'height': u'500',
u'image_id': u'4',
u'item_id': u'879874745',
u'src': u'http://www.raywenderlich.com/wp-content/uploads/2015/03/react-helloworld.png',
u'width': u'281'},
u'5': {u'caption': u'',
u'credit': u'',
u'height': u'227',
u'image_id': u'5',
u'item_id': u'879874745',
u'src': u'http://www.raywenderlich.com/wp-content/uploads/2015/03/ViewDebugging.png',
u'width': u'480'},
u'6': {u'caption': u'',
u'credit': u'',
u'height': u'500',
u'image_id': u'6',
u'item_id': u'879874745',
u'src': u'http://www.raywenderlich.com/wp-content/uploads/2015/03/react-helloworldagain.png',
u'width': u'281'},
u'7': {u'caption': u'',
u'credit': u'',
u'height': u'500',
u'image_id': u'7',
u'item_id': u'879874745',
u'src': u'http://www.raywenderlich.com/wp-content/uploads/2015/03/react-searchstarter.png',
u'width': u'281'},
u'8': {u'caption': u'',
u'credit': u'',
u'height': u'471',
u'image_id': u'8',
u'item_id': u'879874745',
u'src': u'http://www.raywenderlich.com/wp-content/uploads/2015/03/FlexStack.png',
u'width': u'634'},
u'9': {u'caption': u'',
u'credit': u'',
u'height': u'500',
u'image_id': u'9',
u'item_id': u'879874745',
u'src': u'http://www.raywenderlich.com/wp-content/uploads/2015/03/react-searchpageinput.png',
u'width': u'281'}},
u'is_article': u'1',
u'is_index': u'0',
u'item_id': u'879874745',
u'resolved_id': u'879874745',
u'resolved_title': u'React Native Tutorial: Building Apps with JavaScript',
u'resolved_url': u'https://www.raywenderlich.com/99473/introducing-react-native-building-apps-javascript',
u'sort_id': 7,
u'status': u'0',
u'tags': {u'reactjs': {u'item_id': u'879874745',
u'tag': u'reactjs'}},
u'time_added': u'1457629530',
u'time_favorited': u'0',
u'time_read': u'0',
u'time_updated': u'1457629535',
u'word_count': u'5991'},
u'950082829': {u'excerpt': u"Docker has hit the systems scene with great fanfare. It's a very exciting advancement for systems, but there are some key misunderstandings around it. My discussion of Docker is nearly entirely limited to multi-host setups of mission-critical systems (web services primarily).",
u'favorite': u'0',
u'given_title': u'Docker Misconceptions',
u'given_url': u'https://valdhaus.co/writings/docker-misconceptions/',
u'has_image': u'0',
u'has_video': u'0',
u'is_article': u'1',
u'is_index': u'0',
u'item_id': u'950082829',
u'resolved_id': u'950082829',
u'resolved_title': u'Docker Misconceptions',
u'resolved_url': u'https://valdhaus.co/writings/docker-misconceptions/',
u'sort_id': 1,
u'status': u'0',
u'tags': {u'docker': {u'item_id': u'950082829',
u'tag': u'docker'}},
u'time_added': u'1458383446',
u'time_favorited': u'0',
u'time_read': u'0',
u'time_updated': u'1458383451',
u'word_count': u'2722'}}
In [35]:
l = []
for k,v in json_resp['list'].items():
pprint(v)
l.append(v)
{u'authors': {u'2035474': {u'author_id': u'2035474',
u'item_id': u'139521435',
u'name': u'Nick Craver',
u'url': u'http://nickcraver.com/blog/about/'}},
u'excerpt': u'A question we often get asked at Stack Exchange is why stackoverflow.com and all our other domains aren\u2019t served over SSL.\xa0 It\u2019s a user request we see at least a few times a month asking to ensure their security and privacy.',
u'favorite': u'0',
u'given_title': u'Nick Craver - Software Imagineering',
u'given_url': u'http://nickcraver.com/blog/',
u'has_image': u'1',
u'has_video': u'0',
u'image': {u'height': u'0',
u'item_id': u'139521435',
u'src': u'http://nickcraver.com/blog/wp-content/uploads/2013/04/nginx-layout.png',
u'width': u'100'},
u'images': {u'1': {u'caption': u'',
u'credit': u'',
u'height': u'0',
u'image_id': u'1',
u'item_id': u'139521435',
u'src': u'http://nickcraver.com/blog/wp-content/uploads/2013/04/nginx-layout.png',
u'width': u'100'}},
u'is_article': u'1',
u'is_index': u'1',
u'item_id': u'139521435',
u'resolved_id': u'139521435',
u'resolved_title': u'Nick Craver',
u'resolved_url': u'http://nickcraver.com/blog',
u'sort_id': 3,
u'status': u'0',
u'tags': {u'devops': {u'item_id': u'139521435', u'tag': u'devops'}},
u'time_added': u'1457642797',
u'time_favorited': u'0',
u'time_read': u'0',
u'time_updated': u'1457642806',
u'word_count': u'1503'}
{u'excerpt': u'Writing your own TCP/IP stack may seem like a daunting task. Indeed, TCP has accumulated many specifications over its lifetime of more than thirty years.',
u'favorite': u'0',
u'given_title': u'',
u'given_url': u'http://www.saminiir.com/lets-code-tcp-ip-stack-1-ethernet-arp',
u'has_image': u'0',
u'has_video': u'0',
u'is_article': u'1',
u'is_index': u'0',
u'item_id': u'1216069057',
u'resolved_id': u'1216069057',
u'resolved_title': u"Let's code a TCP/IP stack, 1: Ethernet & ARP",
u'resolved_url': u'http://www.saminiir.com/lets-code-tcp-ip-stack-1-ethernet-arp',
u'sort_id': 9,
u'status': u'0',
u'time_added': u'1457323305',
u'time_favorited': u'0',
u'time_read': u'0',
u'time_updated': u'1457323305',
u'word_count': u'1451'}
{u'authors': {u'2358182': {u'author_id': u'2358182',
u'item_id': u'1213240057',
u'name': u'Tom Fishburne',
u'url': u''}},
u'excerpt': u'After a year and half, we\u2019d finally admitted to ourselves that the mobile travel app we were working on was never going to take off.\xa0Luckily, we still had three committed founders and over $100K left in the bank.',
u'favorite': u'0',
u'given_title': u'',
u'given_url': u'http://blog.userinterviews.co/2016/02/18/how-the-lean-startup-took-us-from-failure-to-50-paying-clients/?utm_campaign=Submission&utm_medium=Community&utm_source=GrowthHackers.com',
u'has_image': u'1',
u'has_video': u'0',
u'image': {u'height': u'360',
u'item_id': u'1213240057',
u'src': u'http://blog.userinterviews.co/wp-content/uploads/2016/02/chart-1-v3.png',
u'width': u'640'},
u'images': {u'1': {u'caption': u'',
u'credit': u'',
u'height': u'360',
u'image_id': u'1',
u'item_id': u'1213240057',
u'src': u'http://blog.userinterviews.co/wp-content/uploads/2016/02/chart-1-v3.png',
u'width': u'640'},
u'2': {u'caption': u'',
u'credit': u'',
u'height': u'247',
u'image_id': u'2',
u'item_id': u'1213240057',
u'src': u'http://blog.userinterviews.co/wp-content/uploads/2016/02/chart-2-2.png',
u'width': u'640'},
u'3': {u'caption': u'',
u'credit': u'',
u'height': u'353',
u'image_id': u'3',
u'item_id': u'1213240057',
u'src': u'http://blog.userinterviews.co/wp-content/uploads/2016/02/assumptions-1.png',
u'width': u'640'},
u'4': {u'caption': u'',
u'credit': u'',
u'height': u'400',
u'image_id': u'4',
u'item_id': u'1213240057',
u'src': u'http://blog.userinterviews.co/wp-content/uploads/2016/02/assumptions-2-1.png',
u'width': u'640'},
u'5': {u'caption': u'',
u'credit': u'',
u'height': u'587',
u'image_id': u'5',
u'item_id': u'1213240057',
u'src': u'http://blog.userinterviews.co/wp-content/uploads/2016/02/google-form-v2.png',
u'width': u'640'}},
u'is_article': u'1',
u'is_index': u'0',
u'item_id': u'1213240057',
u'resolved_id': u'1213240057',
u'resolved_title': u'How \u2018Lean Startup\u2019 Took Us From Failure to 50 Paying Clients',
u'resolved_url': u'http://blog.userinterviews.co/2016/02/18/how-the-lean-startup-took-us-from-failure-to-50-paying-clients/?utm_campaign=Submission&utm_medium=Community&utm_source=GrowthHackers.com',
u'sort_id': 8,
u'status': u'0',
u'time_added': u'1457328821',
u'time_favorited': u'0',
u'time_read': u'0',
u'time_updated': u'1457328821',
u'word_count': u'1326'}
{u'excerpt': u'Bingo Card Creator was my first business. I started it in 2006 as something between a hobby and a dare. It makes bingo cards for elementary schoolteachers. Originally it was a Java Swing app. Since 2009 it\u2019s been almost exclusively a SaaS app running on Rails.',
u'favorite': u'0',
u'given_title': u'',
u'given_url': u'https://training.kalzumeus.com/newsletters/archive/selling_software_business',
u'has_image': u'0',
u'has_video': u'0',
u'is_article': u'1',
u'is_index': u'0',
u'item_id': u'1233355174',
u'resolved_id': u'1233355174',
u'resolved_title': u'What I Learned Selling Bingo Card Creator',
u'resolved_url': u'https://training.kalzumeus.com/newsletters/archive/selling_software_business',
u'sort_id': 0,
u'status': u'0',
u'time_added': u'1458793976',
u'time_favorited': u'0',
u'time_read': u'0',
u'time_updated': u'1462220037',
u'word_count': u'4007'}
{u'excerpt': u"Hey! I'm James, and I fiddle with code and infrastructure in my spare time. You can find my projects on GitHub, including: Maybe you'll bump into me getting overexcited about the possibilities of apparently banal pieces of software or technology at the next FOSDEM, or the next CfgMgmtCamp.",
u'favorite': u'0',
u'given_title': u'Geek // James Belchamber // Contractor. Consultant. Geek.',
u'given_url': u'http://james.belchamber.com/pages/geek.html',
u'has_image': u'0',
u'has_video': u'0',
u'is_article': u'1',
u'is_index': u'0',
u'item_id': u'1220830305',
u'resolved_id': u'1220830305',
u'resolved_title': u'Geek // James Belchamber // Contractor. Consultant. Geek.',
u'resolved_url': u'http://james.belchamber.com/pages/geek.html',
u'sort_id': 5,
u'status': u'0',
u'tags': {u'consulting': {u'item_id': u'1220830305', u'tag': u'consulting'}},
u'time_added': u'1457642757',
u'time_favorited': u'0',
u'time_read': u'0',
u'time_updated': u'1460150160',
u'word_count': u'75'}
{u'excerpt': u'For the past few weeks, I have been working on integrating Docker and Jenkins in order to improve the continuous integration workflow of a project I work on. The first step is to install Jenkins on the CI server. You could either install it manually or run it from a Docker image.',
u'favorite': u'0',
u'given_title': u'Integrating Docker with Jenkins for continuous deployment of a Ruby on Rail',
u'given_url': u'http://www.powpark.com/blog/programming/2014/01/29/integrating-docker-with-jenkins-for-ruby-on-rails-app',
u'has_image': u'0',
u'has_video': u'0',
u'is_article': u'1',
u'is_index': u'0',
u'item_id': u'534817761',
u'resolved_id': u'534817761',
u'resolved_title': u'Integrating Docker with Jenkins for continuous deployment of a Ruby on Rails application',
u'resolved_url': u'http://www.powpark.com/blog/programming/2014/01/29/integrating-docker-with-jenkins-for-ruby-on-rails-app',
u'sort_id': 2,
u'status': u'0',
u'tags': {u'docker': {u'item_id': u'534817761', u'tag': u'docker'}},
u'time_added': u'1458383433',
u'time_favorited': u'0',
u'time_read': u'0',
u'time_updated': u'1458383438',
u'word_count': u'926'}
{u'excerpt': u'People are interesting. We know so little about ourselves compared to what we\u2019d like to think we know. We\u2019re all subtly different even though we\u2019re, on a whole, overwhelmingly predictable.',
u'favorite': u'0',
u'given_title': u'Alex Sexton',
u'given_url': u'https://alexsexton.com/',
u'has_image': u'1',
u'has_video': u'0',
u'image': {u'height': u'0',
u'item_id': u'29224026',
u'src': u'https://alexsexton.com/images/prod_cycle/focuswave.png',
u'width': u'0'},
u'images': {u'1': {u'caption': u'',
u'credit': u'',
u'height': u'0',
u'image_id': u'1',
u'item_id': u'29224026',
u'src': u'https://alexsexton.com/images/prod_cycle/focuswave.png',
u'width': u'0'},
u'2': {u'caption': u'',
u'credit': u'',
u'height': u'0',
u'image_id': u'2',
u'item_id': u'29224026',
u'src': u'https://alexsexton.com/images/prod_cycle/cake.jpg',
u'width': u'0'},
u'3': {u'caption': u'',
u'credit': u'',
u'height': u'0',
u'image_id': u'3',
u'item_id': u'29224026',
u'src': u'https://alexsexton.com/images/prod_cycle/wavearea.jpg',
u'width': u'0'}},
u'is_article': u'0',
u'is_index': u'1',
u'item_id': u'29224026',
u'resolved_id': u'29224026',
u'resolved_title': u'Alex Sexton',
u'resolved_url': u'http://alexsexton.com',
u'sort_id': 6,
u'status': u'0',
u'tags': {u'js': {u'item_id': u'29224026', u'tag': u'js'}},
u'time_added': u'1457642744',
u'time_favorited': u'0',
u'time_read': u'0',
u'time_updated': u'1457642751',
u'word_count': u'2217'}
{u'authors': {u'46989754': {u'author_id': u'46989754',
u'item_id': u'879874745',
u'name': u'Colin Eberhardt',
u'url': u'https://www.raywenderlich.com/u/colineberhardt'}},
u'excerpt': u'People have been using JavaScript and HTML5 to create iOS applications using the PhoneGap wrapper for a number of years, so is React Native really such a big deal? The key point with React Native is that it aims to primarily bring the power of the React programming model to mobile app development.',
u'favorite': u'0',
u'given_title': u'React Native Tutorial: Building Apps with JavaScript',
u'given_url': u'https://www.raywenderlich.com/99473/introducing-react-native-building-apps-javascript',
u'has_image': u'1',
u'has_video': u'0',
u'image': {u'height': u'250',
u'item_id': u'879874745',
u'src': u'http://www.raywenderlich.com/wp-content/uploads/2015/03/logo-250x250.png',
u'width': u'250'},
u'images': {u'1': {u'caption': u'React Native: Build native iOS applications with JavaScript.',
u'credit': u'',
u'height': u'250',
u'image_id': u'1',
u'item_id': u'879874745',
u'src': u'http://www.raywenderlich.com/wp-content/uploads/2015/03/logo-250x250.png',
u'width': u'250'},
u'10': {u'caption': u'',
u'credit': u'',
u'height': u'459',
u'image_id': u'10',
u'item_id': u'879874745',
u'src': u'http://www.raywenderlich.com/wp-content/uploads/2015/03/AddingHouseImage.png',
u'width': u'700'},
u'11': {u'caption': u'',
u'credit': u'',
u'height': u'500',
u'image_id': u'11',
u'item_id': u'879874745',
u'src': u'http://www.raywenderlich.com/wp-content/uploads/2015/03/react-searchpagehouse.png',
u'width': u'281'},
u'12': {u'caption': u'',
u'credit': u'',
u'height': u'73',
u'image_id': u'12',
u'item_id': u'879874745',
u'src': u'http://www.raywenderlich.com/wp-content/uploads/2015/03/react-renderconsole.png',
u'width': u'235'},
u'13': {u'caption': u'',
u'credit': u'',
u'height': u'169',
u'image_id': u'13',
u'item_id': u'879874745',
u'src': u'http://www.raywenderlich.com/wp-content/uploads/2015/03/SearchAcitivityIndicator.png',
u'width': u'700'},
u'14': {u'caption': u'',
u'credit': u'',
u'height': u'500',
u'image_id': u'14',
u'item_id': u'879874745',
u'src': u'http://www.raywenderlich.com/wp-content/uploads/2015/03/react-narnia.png',
u'width': u'281'},
u'15': {u'caption': u'',
u'credit': u'',
u'height': u'500',
u'image_id': u'15',
u'item_id': u'879874745',
u'src': u'http://www.raywenderlich.com/wp-content/uploads/2015/03/react-searchresults1.png',
u'width': u'281'},
u'16': {u'caption': u'',
u'credit': u'',
u'height': u'500',
u'image_id': u'16',
u'item_id': u'879874745',
u'src': u'http://www.raywenderlich.com/wp-content/uploads/2015/03/react-searchresults2.png',
u'width': u'281'},
u'17': {u'caption': u'',
u'credit': u'',
u'height': u'500',
u'image_id': u'17',
u'item_id': u'879874745',
u'src': u'http://www.raywenderlich.com/wp-content/uploads/2015/03/react-property.png',
u'width': u'281'},
u'18': {u'caption': u'',
u'credit': u'',
u'height': u'162',
u'image_id': u'18',
u'item_id': u'879874745',
u'src': u'http://www.raywenderlich.com/wp-content/uploads/2015/03/Screen-Shot-2015-03-20-at-21.49.06.png',
u'width': u'480'},
u'19': {u'caption': u'',
u'credit': u'',
u'height': u'500',
u'image_id': u'19',
u'item_id': u'879874745',
u'src': u'http://www.raywenderlich.com/wp-content/uploads/2015/03/WhitleyBaySearch.png',
u'width': u'647'},
u'2': {u'caption': u'',
u'credit': u'',
u'height': u'360',
u'image_id': u'2',
u'item_id': u'879874745',
u'src': u'http://www.raywenderlich.com/wp-content/uploads/2015/03/PropertyFinder.png',
u'width': u'700'},
u'3': {u'caption': u'',
u'credit': u'',
u'height': u'500',
u'image_id': u'3',
u'item_id': u'879874745',
u'src': u'http://www.raywenderlich.com/wp-content/uploads/2015/03/ReactNative-Starter.png',
u'width': u'281'},
u'4': {u'caption': u'',
u'credit': u'',
u'height': u'500',
u'image_id': u'4',
u'item_id': u'879874745',
u'src': u'http://www.raywenderlich.com/wp-content/uploads/2015/03/react-helloworld.png',
u'width': u'281'},
u'5': {u'caption': u'',
u'credit': u'',
u'height': u'227',
u'image_id': u'5',
u'item_id': u'879874745',
u'src': u'http://www.raywenderlich.com/wp-content/uploads/2015/03/ViewDebugging.png',
u'width': u'480'},
u'6': {u'caption': u'',
u'credit': u'',
u'height': u'500',
u'image_id': u'6',
u'item_id': u'879874745',
u'src': u'http://www.raywenderlich.com/wp-content/uploads/2015/03/react-helloworldagain.png',
u'width': u'281'},
u'7': {u'caption': u'',
u'credit': u'',
u'height': u'500',
u'image_id': u'7',
u'item_id': u'879874745',
u'src': u'http://www.raywenderlich.com/wp-content/uploads/2015/03/react-searchstarter.png',
u'width': u'281'},
u'8': {u'caption': u'',
u'credit': u'',
u'height': u'471',
u'image_id': u'8',
u'item_id': u'879874745',
u'src': u'http://www.raywenderlich.com/wp-content/uploads/2015/03/FlexStack.png',
u'width': u'634'},
u'9': {u'caption': u'',
u'credit': u'',
u'height': u'500',
u'image_id': u'9',
u'item_id': u'879874745',
u'src': u'http://www.raywenderlich.com/wp-content/uploads/2015/03/react-searchpageinput.png',
u'width': u'281'}},
u'is_article': u'1',
u'is_index': u'0',
u'item_id': u'879874745',
u'resolved_id': u'879874745',
u'resolved_title': u'React Native Tutorial: Building Apps with JavaScript',
u'resolved_url': u'https://www.raywenderlich.com/99473/introducing-react-native-building-apps-javascript',
u'sort_id': 7,
u'status': u'0',
u'tags': {u'reactjs': {u'item_id': u'879874745', u'tag': u'reactjs'}},
u'time_added': u'1457629530',
u'time_favorited': u'0',
u'time_read': u'0',
u'time_updated': u'1457629535',
u'word_count': u'5991'}
{u'excerpt': u"Docker has hit the systems scene with great fanfare. It's a very exciting advancement for systems, but there are some key misunderstandings around it. My discussion of Docker is nearly entirely limited to multi-host setups of mission-critical systems (web services primarily).",
u'favorite': u'0',
u'given_title': u'Docker Misconceptions',
u'given_url': u'https://valdhaus.co/writings/docker-misconceptions/',
u'has_image': u'0',
u'has_video': u'0',
u'is_article': u'1',
u'is_index': u'0',
u'item_id': u'950082829',
u'resolved_id': u'950082829',
u'resolved_title': u'Docker Misconceptions',
u'resolved_url': u'https://valdhaus.co/writings/docker-misconceptions/',
u'sort_id': 1,
u'status': u'0',
u'tags': {u'docker': {u'item_id': u'950082829', u'tag': u'docker'}},
u'time_added': u'1458383446',
u'time_favorited': u'0',
u'time_read': u'0',
u'time_updated': u'1458383451',
u'word_count': u'2722'}
{u'authors': {u'46599448': {u'author_id': u'46599448',
u'item_id': u'1210838131',
u'name': u'Juraj Somorovsky',
u'url': u'https://www.nds.rub.de/chair/people/jsomorovsky/'},
u'46599449': {u'author_id': u'46599449',
u'item_id': u'1210838131',
u'name': u'Emilia K\xe4sper',
u'url': u'http://research.google.com/pubs/author58129.html'}},
u'excerpt': u'DROWN is a serious vulnerability that affects HTTPS and other services that rely on SSL and TLS, some of the essential cryptographic protocols for Internet security.',
u'favorite': u'0',
u'given_title': u'DROWN Attack',
u'given_url': u'https://drownattack.com/',
u'has_image': u'1',
u'has_video': u'0',
u'image': {u'height': u'0',
u'item_id': u'1210838131',
u'src': u'https://drownattack.com/media/img/DROWN_diagram1.jpg',
u'width': u'0'},
u'images': {u'1': {u'caption': u'',
u'credit': u'',
u'height': u'0',
u'image_id': u'1',
u'item_id': u'1210838131',
u'src': u'https://drownattack.com/media/img/DROWN_diagram1.jpg',
u'width': u'0'},
u'2': {u'caption': u'',
u'credit': u'',
u'height': u'0',
u'image_id': u'2',
u'item_id': u'1210838131',
u'src': u'https://drownattack.com/media/img/DROWN_diagram.jpg',
u'width': u'0'}},
u'is_article': u'0',
u'is_index': u'1',
u'item_id': u'1210838131',
u'resolved_id': u'1210838131',
u'resolved_title': u'The DROWN Attack',
u'resolved_url': u'http://drownattack.com',
u'sort_id': 4,
u'status': u'0',
u'tags': {u'devops': {u'item_id': u'1210838131', u'tag': u'devops'}},
u'time_added': u'1457642774',
u'time_favorited': u'0',
u'time_read': u'0',
u'time_updated': u'1457642778',
u'word_count': u'2827'}
In [36]:
len(l)
Out[36]:
10
In [39]:
df = pd.DataFrame.from_records(l, columns=["authors","word_count", "time_updated", "time_read", "time_favorited",
"time_added","sort_id","resolved_title", "resolved_url",
"given_url","given_tile","favorite", "status"])
In [40]:
df.head()
Out[40]:
authors
word_count
time_updated
time_read
time_favorited
time_added
sort_id
resolved_title
resolved_url
given_url
given_tile
favorite
status
0
{u'2035474': {u'item_id': u'139521435', u'url'...
1503
1457642806
0
0
1457642797
3
Nick Craver
http://nickcraver.com/blog
http://nickcraver.com/blog/
NaN
0
0
1
NaN
1451
1457323305
0
0
1457323305
9
Let's code a TCP/IP stack, 1: Ethernet & ARP
http://www.saminiir.com/lets-code-tcp-ip-stack...
http://www.saminiir.com/lets-code-tcp-ip-stack...
NaN
0
0
2
{u'2358182': {u'item_id': u'1213240057', u'url...
1326
1457328821
0
0
1457328821
8
How ‘Lean Startup’ Took Us From Failure to 50 ...
http://blog.userinterviews.co/2016/02/18/how-t...
http://blog.userinterviews.co/2016/02/18/how-t...
NaN
0
0
3
NaN
4007
1462220037
0
0
1458793976
0
What I Learned Selling Bingo Card Creator
https://training.kalzumeus.com/newsletters/arc...
https://training.kalzumeus.com/newsletters/arc...
NaN
0
0
4
NaN
75
1460150160
0
0
1457642757
5
Geek // James Belchamber // Contractor. Consul...
http://james.belchamber.com/pages/geek.html
http://james.belchamber.com/pages/geek.html
NaN
0
0
In [ ]:
Content source: nehiljain/rhime
Similar notebooks: