py4sci

Table Of Contents

Previous topic

Site Specific Setup

Next topic

Version Info

This Page

Miscellaneous

Time

scan.util.seconds.parseSeconds(text)

Parse various time durations into seconds

Parameters:text – Text that contains a duration
Returns:Seconds

Convert text that contains “HH:MM:SS” into seconds

>>> parseSeconds("00:00:01")
1
>>> parseSeconds("120")
120.0
>>> parseSeconds("6.0")
6.0
>>> parseSeconds("13.4")
13.4
>>> parseSeconds("01:01:01")
3661
>>> parseSeconds("2:01")
121
>>> parseSeconds("02:01")
121
>>> parseSeconds("48000")
48000.0

Can also be called with number:

>>> parseSeconds(120)
120

Spreadsheets

scan.util.spreadsheet.readSpreadsheet(filename)

Read a spreadsheet file.

Reads the basic table of strings and numbers from a gnumeric file.

Parameters:filename – Name of file to read, either ‘.cvs’, ‘.tab’, ‘.xls’ or ‘.gnumeric’
Returns:[ [ row0cell0, row0cell1 ], [ row1cell0, row1cell1 ], ... ]

Example:

>>> table = readSpreadsheet('/path/to/file.csv')
>>> print table
scan.util.spreadsheet.writeSpreadsheet(filename, table)

Save table to file

Writes table as spreadsheet file.

Parameters:
  • filename – File path, must end in ”.csv” or ”.tab”
  • table – Table [ [ row0cell0, row0cell1 ], [ row1cell0, row1cell1 ], ... ]

Example:

>>> writeSpreadsheet('/path/to/file.csv', [ [ 'X', 'Y' ], [ 1, 2 ], [ 3, 4 ] ])