Path: csiph.com!fu-berlin.de!uni-berlin.de!not-for-mail From: Pete Dowdell Newsgroups: comp.lang.python Subject: Re: Extracting and summing student scores from a JSON file using Python 2.7.10 Date: Tue, 10 Nov 2015 09:38:15 +0700 Lines: 17 Message-ID: References: <1d1610e5-d401-48f2-b5ee-3af91b9e485f@googlegroups.com> Mime-Version: 1.0 Content-Type: text/plain; charset=windows-1252; format=flowed Content-Transfer-Encoding: 7bit X-Trace: news.uni-berlin.de 305cILpnBQaBCU7bj9YVsARO48ap86bWHo/2be58hEVQ== Return-Path: X-Original-To: python-list@python.org Delivered-To: python-list@mail.python.org X-Spam-Status: OK 0.011 X-Spam-Evidence: '*H*': 0.98; '*S*': 0.00; 'subject:Python': 0.05; 'json': 0.05; 'subject:file': 0.07; 'int)': 0.09; 'subject:using': 0.09; 'subject: \n ': 0.15; 'received:io': 0.16; 'received:psf.io': 0.16; 'subject:JSON': 0.16; 'subject:student': 0.16; 'url:json': 0.16; 'urllib': 0.16; 'wrote:': 0.16; 'import': 0.24; 'header:In-Reply-To:1': 0.24; 'header:User-Agent:1': 0.26; 'skip:j 20': 0.33; 'list': 0.34; 'received:google.com': 0.35; 'skip:i 20': 0.36; 'received:209.85': 0.36; 'data.': 0.36; 'to:addr:python-list': 0.36; 'subject:: ': 0.37; 'received:209': 0.38; 'received:209.85.220': 0.38; 'subject:from': 0.39; 'received:192': 0.39; 'to:addr:python.org': 0.40; 'skip:u 10': 0.61; 'charset:windows-1252': 0.62; 'from:addr:contact': 0.66; 'now:': 0.72; 'analysis': 0.72; 'scores': 0.91 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=stridebird_com.20150623.gappssmtp.com; s=20150623; h=from:subject:to:references:message-id:date:user-agent:mime-version :in-reply-to:content-type:content-transfer-encoding; bh=JHYH7LQYWEUdsxT6kGch+WHt5XsIr/Zg8IbHi8PsiII=; b=XSelx5B2Z7pV/ApdiMy7nifRA2FDgSkMiSi+ZfzvoSum2sWoUW/eN0BICZBnVOwM9S EVOU0+XONTPSJJXhAtCRZEv+qfe+pgVlNekJU970i2iqGPNoTosLEE4wEgWv3qjCSqDO foty/t1Ur18V//cfA0PRipM5YFNvSZXqZvAOMpC9Hq0Q6M3ySPc6C2/4rV06E6TuV7nM e5kAcDbFBO7iCnsOZ1VF4DGSu9ebvHTDbSFbbcG2iAbbFfF/uKtlFb5iP0ti/7/kL9SQ wR2rkVOTLNjz5aib6zPzuI85ZvbXkBV7FTvklInau/zlPPFGxZcAbbKCM7nRT7f16gQB gZuw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:from:subject:to:references:message-id:date :user-agent:mime-version:in-reply-to:content-type :content-transfer-encoding; bh=JHYH7LQYWEUdsxT6kGch+WHt5XsIr/Zg8IbHi8PsiII=; b=Wc9FlRRI3+l+UsYovc6FVVC2iQ1FXdgxfD1NtXB1sSO8LJrQPT7halRuQzxVHR6NI1 NCUfFm6XzEJbwN2/rlRHQf8qdMjnvU7xtq/Fj2ZHfRkBrXU36grrsQDAd9Ac7ifsjSJL vdEmEMS4a/aK3V9432+9UmNWipCi7vuqn7riElElazufkuqDXBCi2pjwW3+PQOXKg8nn nlMpQ0mbdEp/4t6khWkz0CKu33A7GaJiOpAgPoZens14wvcaUaTNpprk5j0S8jOuHfi5 sSDSKmxLD3qbA5WnOA4hXNDmfldobGYWmcueq6FZ6e4YMMW9emSZA6vGm/Jdd0OqMF5e IrcA== X-Gm-Message-State: ALoCoQkU+nvbJcDiYEJiAR8VAYPZt4DLTT+Q82qz9ABzY77h2fzQv6f1p079OIEcs2S7Jds3zV8Q X-Received: by 10.69.4.5 with SMTP id ca5mr1795052pbd.149.1447123103437; Mon, 09 Nov 2015 18:38:23 -0800 (PST) X-Google-Original-From: Pete Dowdell User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:38.0) Gecko/20100101 Thunderbird/38.3.0 In-Reply-To: X-Mailman-Approved-At: Tue, 10 Nov 2015 03:51:47 -0500 X-BeenThere: python-list@python.org X-Mailman-Version: 2.1.20+ Precedence: list List-Id: General discussion list for the Python programming language List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Xref: csiph.com comp.lang.python:98581 On 10/11/15 08:12, Bernie Lazlo wrote: > > > import json > > >import urllib > > >url ="http://www.wickson.net/geography_assignment.json" > > >response = urllib.urlopen(url) > > >data = json.loads(response.read()) All good up to data. Now: # make a list of scores scores = [d['score'] for d in data['comments'] if isinstance(d['score'], int) ] # analysis total_scores = sum(scores) average_score= total_scores/float(len(scores)) min_score, max_score = min(scores), max(scores) pd