search

EmmaRocheteau / TPC-LoS-prediction

This repository contains the code used for Temporal Pointwise Convolutional Networks for Length of Stay Prediction in the Intensive Care Unit (https://dl.acm.org/doi/10.1145/3450439.3451860).
https://dl.acm.org/doi/10.1145/3450439.3451860
MIT License
76 stars 25 forks source link

File "pandas\_libs\parsers.pyx", line 545, in pandas._libs.parsers.TextReader.__cinit__ pandas.errors.EmptyDataError: No columns to parse from file #13

Closed SewoongLee closed 1 year ago

SewoongLee commented 1 year ago

There was an empty data error when running -m MIMIC_preprocessing.run_all_preprocessing

image

Is it ok that my flat_features.csv file is empty...? image

SewoongLee commented 1 year ago

FYI, manually selecting 'flat_features.sql' works fine. image

SewoongLee commented 1 year ago

It seems there is some problem in pre-processing time-series.py.

And I don't know why it is referencing eICU data even though it is MIMIC-IV pre-processing. image

SewoongLee commented 1 year ago

My psql version is 15.2, but it seems crosstab keyword is not working in flat_featrues.sql

image

SewoongLee commented 1 year ago

I installed crosstab in tablefunc. Now I am re-running this.

https://stackoverflow.com/questions/3002499/postgresql-crosstab-query

SewoongLee commented 1 year ago

In my case, I had to use $$ in query. https://stackoverflow.com/questions/59500585/what-is-wrong-in-my-crosstab-postgres-query

image