Path: csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!eu.feeder.erje.net!xlned.com!feeder5.xlned.com!newsfeed.xs4all.nl!newsfeed3a.news.xs4all.nl!xs4all!newsgate.cistron.nl!newsgate.news.xs4all.nl!post.news.xs4all.nl!not-for-mail Return-Path: X-Original-To: python-list@python.org Delivered-To: python-list@mail.python.org X-Spam-Status: OK 0.045 X-Spam-Evidence: '*H*': 0.91; '*S*': 0.00; 'python,': 0.02; '16,': 0.03; "they've": 0.09; 'cc:addr:python-list': 0.11; 'python': 0.11; 'begin?': 0.16; 'bouncing': 0.16; 'spreadsheet.': 0.16; 'xlrd': 0.16; 'student': 0.16; 'wrote:': 0.18; 'obviously': 0.18; 'email addr:gmail.com>': 0.22; 'cc:addr:python.org': 0.22; 'question': 0.24; 'cc:2**0': 0.24; 'cc:no real name:2**0': 0.24; "i've": 0.25; '>': 0.26; 'tutorials': 0.26; 'excel': 0.26; 'header:In-Reply-To:1': 0.27; 'am,': 0.29; 'joe': 0.30; 'message- id:@mail.gmail.com': 0.30; "i'm": 0.30; 'url:mailman': 0.30; 'ball': 0.31; 'cells': 0.31; 'changed.': 0.31; 'anyone': 0.31; 'thanks!': 0.32; 'url:python': 0.33; "i'd": 0.34; 'something': 0.35; 'but': 0.35; 'received:google.com': 0.35; 'animation': 0.36; 'url:listinfo': 0.36; "i'll": 0.36; 'possible': 0.36; 'url:org': 0.36; 'files': 0.38; 'enough': 0.39; 'url:mail': 0.40; 'how': 0.40; 'read': 0.60; 'easy': 0.60; 'back': 0.62; 'high': 0.63; 'school': 0.64; 'different': 0.65; 'to:addr:gmail.com': 0.65; 'details': 0.65; 'air': 0.66; 'answer.': 0.68; 'physics': 0.68; 'prompt': 0.68; 'paper': 0.75; 'played': 0.84; 'spreadsheet': 0.84; 'responses': 0.93 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type; bh=X/Hp166SUky+7ct1nMrlQoDFWHe8R4EwIY8QGzPOTvI=; b=0JOzsVqWCXlBox88VDke2HDHxLv13jkIuxZ81/8AFpq1Y/xaUDInh7kApUVJsM7KAY Hj/MO/Ev7nOjcHwPLb7g2PlLTKkdgOPwPHNj+FVdTiUlXTm6rZoY0/FPdzYS53b2fW/7 YmqHWE294OfUQidIjNeCDxg7uLsOxhWCpKQrHTNXMCmo7ZPeOsgS1FpzjJ793mb8E0wk wzAVe5kKEYji9a3PpSc1w4wCfA8nB/TiMmrQftXE+8i6eUJce8DKVfbGUTu+jB94Q5bR nsGgWZEoWuA05FGHLpuAGgTewZn5OW3GHKUkznUgmY8yhEGAnYFGIZrc9ZBFzAWS1HV1 hrfw== MIME-Version: 1.0 X-Received: by 10.220.69.72 with SMTP id y8mr2295936vci.21.1397657353489; Wed, 16 Apr 2014 07:09:13 -0700 (PDT) In-Reply-To: <4c4b4c31-2a49-4ba1-93b4-16573116acff@googlegroups.com> References: <4c4b4c31-2a49-4ba1-93b4-16573116acff@googlegroups.com> Date: Wed, 16 Apr 2014 10:09:13 -0400 Subject: Re: Tutorials for Reorganizing Spreadsheet Data From: Joel Goldstick To: josephlkremer@gmail.com Content-Type: multipart/alternative; boundary=047d7b3a92501293e304f72976d6 Cc: python-list@python.org X-BeenThere: python-list@python.org X-Mailman-Version: 2.1.15 Precedence: list List-Id: General discussion list for the Python programming language List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Newsgroups: comp.lang.python Message-ID: Lines: 64 NNTP-Posting-Host: 2001:888:2000:d::a6 X-Trace: 1397657361 news.xs4all.nl 2971 [2001:888:2000:d::a6]:33485 X-Complaints-To: abuse@xs4all.nl Xref: csiph.com comp.lang.python:70333 --047d7b3a92501293e304f72976d6 Content-Type: text/plain; charset=UTF-8 On Apr 16, 2014 9:55 AM, wrote: > > Hello, I'm a high school physics teacher and while I've played with Python enough to make a rock paper scissors program or animation of a bouncing ball (with air resistance!), I've never used it to work with data from a spreadsheet. > > I have a large spreadsheet with a number of different student responses to a weekly prompt in various cells depending on which question they chose to answer. I'd like to organize these responses into something that make it easy for students to look back through their responses over time, and see how they've changed. > > This is obviously possible in Python, but I don't know where to begin learning the details of what I'll need to know to build it. Can anyone give me a specific recommendation of tutorials where I might begin? > The package xlrd will read your Excel files > Thanks! > > Joe > -- > https://mail.python.org/mailman/listinfo/python-list --047d7b3a92501293e304f72976d6 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable


On Apr 16, 2014 9:55 AM, <jos= ephlkremer@gmail.com> wrote:
>
> Hello, I'm a high school physics teacher and while I've played= with Python enough to make a rock paper scissors program or animation of a= bouncing ball (with air resistance!), I've never used it to work with = data from a spreadsheet.
>
> I have a large spreadsheet with a number of different student response= s to a weekly prompt in various cells depending on which question they chos= e to answer. I'd like to organize these responses into something that m= ake it easy for students to look back through their responses over time, an= d see how they've changed.
>
> This is obviously possible in Python, but I don't know where to be= gin learning the details of what I'll need to know to build it. Can any= one give me a specific recommendation of tutorials where I might begin?
>

The package xlrd will read your Excel files
> Thanks!
>
> =C2=A0 Joe
> --
> https= ://mail.python.org/mailman/listinfo/python-list

--047d7b3a92501293e304f72976d6--