Re: Tutorials for Reorganizing Spreadsheet Data

Path	csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!news.mixmin.net!rt.uk.eu.org!newsfeed.xs4all.nl!newsfeed4a.news.xs4all.nl!xs4all!newsgate.cistron.nl!newsgate.news.xs4all.nl!post.news.xs4all.nl!not-for-mail
Return-Path	<python-python-list@m.gmane.org>
X-Original-To	python-list@python.org
Delivered-To	python-list@mail.python.org
X-Spam-Status	OK 0.016
X-Spam-Evidence	'H': 0.97; 'S': 0.00; 'python,': 0.02; 'output': 0.05; 'received:80.91': 0.09; 'received:80.91.229': 0.09; 'received:gmane.org': 0.09; 'received:list': 0.09; "they've": 0.09; 'python': 0.11; 'jan': 0.12; 'begin?': 0.16; 'bouncing': 0.16; 'csv': 0.16; 'latter,': 0.16; 'program?': 0.16; 'received:80.91.229.3': 0.16; 'received:plane.gmane.org': 0.16; 'reedy': 0.16; 'spreadsheet.': 0.16; 'student': 0.16; 'wrote:': 0.18; 'obviously': 0.18; 'file,': 0.19; 'header:User-Agent:1': 0.23; 'question': 0.24; "i've": 0.25; 'tutorials': 0.26; 'header:X -Complaints-To:1': 0.27; 'header:In-Reply-To:1': 0.27; 'am,': 0.29; "i'm": 0.30; "skip:' 10": 0.31; 'ball': 0.31; 'cells': 0.31; 'changed.': 0.31; 'anyone': 0.31; 'file': 0.32; "i'd": 0.34; 'something': 0.35; 'but': 0.35; 'animation': 0.36; 'module.': 0.36; "i'll": 0.36; 'possible': 0.36; 'should': 0.36; 'to:addr :python-list': 0.38; 'to:addr:python.org': 0.39; 'enough': 0.39; 'received:org': 0.40; 'how': 0.40; 'read': 0.60; 'easy': 0.60; 'received:173': 0.61; 'back': 0.62; 'email addr:gmail.com': 0.63; 'high': 0.63; 'school': 0.64; 'different': 0.65; 'details': 0.65; 'air': 0.66; 'answer.': 0.68; 'physics': 0.68; 'prompt': 0.68; 'paper': 0.75; 'played': 0.84; 'received:fios.verizon.net': 0.84; 'spreadsheet': 0.84; 'sheets': 0.91; 'responses': 0.93
X-Injected-Via-Gmane	http://gmane.org/
To	python-list@python.org
From	Terry Reedy <tjreedy@udel.edu>
Subject	Re: Tutorials for Reorganizing Spreadsheet Data
Date	Wed, 16 Apr 2014 10:16:34 -0400
References	<4c4b4c31-2a49-4ba1-93b4-16573116acff@googlegroups.com>
Mime-Version	1.0
Content-Type	text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding	7bit
X-Gmane-NNTP-Posting-Host	pool-173-75-254-207.phlapa.fios.verizon.net
User-Agent	Mozilla/5.0 (Windows NT 6.1; WOW64; rv:24.0) Gecko/20100101 Thunderbird/24.4.0
In-Reply-To	<4c4b4c31-2a49-4ba1-93b4-16573116acff@googlegroups.com>
X-BeenThere	python-list@python.org
X-Mailman-Version	2.1.15
Precedence	list
List-Id	General discussion list for the Python programming language <python-list.python.org>
List-Unsubscribe	<https://mail.python.org/mailman/options/python-list>, <mailto:python-list-request@python.org?subject=unsubscribe>
List-Archive	<http://mail.python.org/pipermail/python-list/>
List-Post	<mailto:python-list@python.org>
List-Help	<mailto:python-list-request@python.org?subject=help>
List-Subscribe	<https://mail.python.org/mailman/listinfo/python-list>, <mailto:python-list-request@python.org?subject=subscribe>
Newsgroups	comp.lang.python
Message-ID	<mailman.9323.1397657832.18130.python-list@python.org> (permalink)
Lines	17
NNTP-Posting-Host	2001:888:2000:d::a6
X-Trace	1397657832 news.xs4all.nl 2838 [2001:888:2000:d::a6]:36801
X-Complaints-To	abuse@xs4all.nl
Xref	csiph.com comp.lang.python:70334

Show key headers only | View raw

On 4/16/2014 9:50 AM, josephlkremer@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 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?

Is your spreadsheet actually on sheets (paper) or in a program? If the 
latter, you should be about to output the data as a 'comma-separated 
variable' (csv) file and read it in python with the csv module. If you 
want to work with the data directly in the spreadsheet file, the details 
depend on the OS and program.


-- 
Terry Jan Reedy

Thread

Tutorials for Reorganizing Spreadsheet Data josephlkremer@gmail.com - 2014-04-16 06:50 -0700
  Re: Tutorials for Reorganizing Spreadsheet Data Joel Goldstick <joel.goldstick@gmail.com> - 2014-04-16 10:09 -0400
  Re: Tutorials for Reorganizing Spreadsheet Data Terry Reedy <tjreedy@udel.edu> - 2014-04-16 10:16 -0400
  Re: Tutorials for Reorganizing Spreadsheet Data CHIN Dihedral <dihedral88888@gmail.com> - 2014-05-05 16:08 -0700

csiph-web