Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.python > #70332 > unrolled thread

Tutorials for Reorganizing Spreadsheet Data

Back to article view | Back to comp.lang.python

Contents

  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

#70332 — Tutorials for Reorganizing Spreadsheet Data

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?

Thanks!

  Joe

[toc] | [next] | [standalone]

#70333

[Multipart message — attachments visible in raw view] — view raw

On Apr 16, 2014 9:55 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?
>

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

[toc] | [prev] | [next] | [standalone]

#70334

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

[toc] | [prev] | [next] | [standalone]

#70939

On Wednesday, April 16, 2014 9:50:25 PM UTC+8, joseph...@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?
> 
> 
> 
> Thanks!
> 
> 
> 
>   Joe

Check the source code here:
http://manns.github.io/pyspread/  and 
http://www.python-excel.org/ .

[toc] | [prev] | [standalone]

Back to top | Article view | comp.lang.python

csiph-web