wdmtoolbox.wdmtoolbox.hydhrseqtowdm¶
- wdmtoolbox.wdmtoolbox.hydhrseqtowdm(wdmpath, dsn, input_ts=<_io.TextIOWrapper name='<stdin>' mode='r' encoding='utf-8'>, start_century=1900)¶
Write HYDHR sequential file to a DSN.
- Parameters:
wdmpath (str) – Path and WDM filename.
dsn (int) – The Data Set Number (DSN) for the time series in the WDM file. This number must be greater or equal to 1 and less than or equal to 32000. HSPF can only use for input or output DSNs of 1 to 9999, inclusive.
input_ts (str) –
[optional though required if using within Python, default is ‘-’ (stdin)]
Whether from a file or standard input, data requires a single line header of column names. The default header is the first line of the input, but this can be changed for CSV files using the ‘skiprows’ option.
Most common date formats can be used, but the closer to ISO 8601 date/time standard the better.
Comma-separated values (CSV) files or tab-separated values (TSV):
File separators will be automatically detected. Columns can be selected by name or index, where the index for data columns starts at 1.
Command line examples:
Keyword Example
Description
–input_ts=fn.csv
read all columns from ‘fn.csv’
–input_ts=fn.csv,2,1
read data columns 2 and 1 from ‘fn.csv’
–input_ts=fn.csv,2,skiprows=2
read data column 2 from ‘fn.csv’, skipping first 2 rows so header is read from third row
–input_ts=fn.xlsx,2,Sheet21
read all data from 2nd sheet all data from “Sheet21” of ‘fn.xlsx’
–input_ts=fn.hdf5,Table12,T2
read all data from table “Table12” then all data from table “T2” of ‘fn.hdf5’
–input_ts=fn.wdm,210,110
read DSNs 210, then 110 from ‘fn.wdm’
–input_ts=’-’
read all columns from standard input (stdin)
–input_ts=’-’ –columns=4,1
read column 4 and 1 from standard input (stdin)
If working with CSV or TSV files you can use redirection rather than use –input_ts=fname.csv. The following are identical:
From a file:
command subcmd –input_ts=fname.csv
From standard input (since ‘–input_ts=-’ is the default:
command subcmd < fname.csv
Can also combine commands by piping:
command subcmd < filein.csv | command subcmd1 > fileout.csv
Python library examples:
You must use the `input_ts=...` option where `input_ts` can be one of a [pandas DataFrame, pandas Series, dict, tuple, list, StringIO, or file name].
start_century – Since 2 digit years are used, need century, defaults to 1900.