visum_to_pandas

python scripts to parse visum .net and .dmd file to pandas and store as .csv files (c) Rafal Kucharski, Politechnika Krakowska, Krakow, Poland

usage

open ptv_visum_to_pandas.py and go to main() where you can find the below pipeline:

### 0. Set your paths - your ver files and export paths NETPATH = “./test/MOMM_net.net” # .net file to parse into csv tables DMDPATH = “./test/MOMM_full_dmd.dmd” # .dmd file to parse into csv tables OUTPATH = “./test/data/” # save the .csv’s here VERPATH = “./test/test_matrices.ver”

### 1. Export .ver file to editable .net and .dmd export_net_dmd(path=VERPATH)

### 2. export network to csv parse(NETPATH, export_path=OUTPATH) # a) full export parse(NETPATH, export_path=OUTPATH, export_list=[“Links”, “Nodes”]) # b) just some tables

### 3. export demand files to csv parse(DMDPATH, export_path=OUTPATH)

### 4. Export matrices (export from .dmd is not very useful) matrices_export_via_com(VERPATH, export_path=OUTPATH) # a) full export matrices_export_via_com(VERPATH, export_path=OUTPATH, export_list=[101, 102]) # b) just some matrices

### 5. see if everything went fine and understand how to use it further with pandas test_read(“./test/data/Tripgeneration.csv”) test_read(“./test/data/Links.csv”) test_read(“./test/data/Mtx_10.csv”)

Third party

We link PTV Visum with pandas

test

run test.py to see if the links.csv is as we expect and if matrix entries.csv are the same. Use only for the original files.

contributors

https://github.com/PatrikHlobil

possible modifications

• pd.DataFrame(data, columns=cols).to_csv(OUTPATH+table_name+".csv") can be easily modified to be used directly in pandas (e.g. dict of DataFrames, or h5 store).
• pipeline can be smoother if this is called from within Visum, you shall add Visum.IO.SaveNet, Visum.IO.SaveDmd to prepare the files under good paths and then use them in parse done