Quantcast

Got Homework?

Connect with other students for help. It's a free community.

  • across
    MIT Grad Student
    Online now
  • laura*
    Helped 1,000 students
    Online now
  • Hero
    College Math Guru
    Online now

Here's the question you clicked on:

55 members online
  • 0 replying
  • 0 viewing

paynito Group Title

Importing data from excel files via python. I have course syllabli in 4 excel files with 2 columns [date, tue 5/2/2012, fri 5/2/2012, tue 5/9/2012 .. . .] [chapter, 4.1-4.3, 4.4-4.5, 4.6 and ch. 4 test] . . . I want to convert these to weekly lesson plans (#begin pseduo code: converts excel files to weekly lesson plans for 2012-2013 school year; import calendar; open file1:math_4th_grade.csv; csv_to_dictionary(file1); for week40:Nov13-18: get file[1,2,3,4] date_in(week40) -> output to Latex pdf as lesson plan)) Is that going to be more trouble than importing into LibreOffice Base-run report

  • 2 years ago
  • 2 years ago

  • This Question is Closed
  1. paynito Group Title
    Best Response
    You've already chosen the best response.
    Medals 0

    http://www.doughellmann.com/PyMOTW/csv/ is the csv module for python, trying that instead of the excel-python API . . .put all4 syllabi into one file, but they are all different additionally since days have changed I want a way to change all Monday classes in column 4th_grade to Tuesdays, incrementing day+1 either in excel or in python would be fine.

    • 2 years ago
  2. paynito Group Title
    Best Response
    You've already chosen the best response.
    Medals 0

    This seems like what I'm looking for http://stackoverflow.com/questions/ 8085520/ generating-pdf-latex-with-python-script Take your LaTeX document above and "tokenize" the file by placing %(placeholder_name1)s tokens into the document. For example, where you want your class name to go, use %(course_name)s \textbf{\Large "%(homework_title)s" \\} \vspace{1cm} \textbf{\Large "%(course_name)s" \\} Then, from Python, you can load in that template and format it as: template = file('template.tex', 'r').read() page = template % {'course_name' : 'Computer Science 500', 'homework_title' : 'NP-Complete'} file('result.tex', 'w').write(page)

    • 2 years ago
    • Attachments:

See more questions >>>

Your question is ready. Sign up for free to start getting answers.

spraguer (Moderator)
5 → View Detailed Profile

is replying to Can someone tell me what button the professor is hitting...

23

  • Teamwork 19 Teammate
  • Problem Solving 19 Hero
  • You have blocked this person.
  • ✔ You're a fan Checking fan status...

Thanks for being so helpful in mathematics. If you are getting quality help, make sure you spread the word about OpenStudy.

This is the testimonial you wrote.
You haven't written a testimonial for Owlfred.