diff options
| author | Jules Laplace <julescarbon@gmail.com> | 2019-01-04 23:37:34 +0100 |
|---|---|---|
| committer | Jules Laplace <julescarbon@gmail.com> | 2019-01-04 23:37:34 +0100 |
| commit | 276c16e1055c23350abd3d9d071cfce9b4f1b27f (patch) | |
| tree | b85c3b3c8ff0f7bfb77323d3f77be0f88bb3086f /megapixels/app/models | |
| parent | e5b6ef658e936c32d9500ff7f781171d9785315a (diff) | |
rm rotation on homepage, add dataset list
Diffstat (limited to 'megapixels/app/models')
| -rw-r--r-- | megapixels/app/models/sql_factory.py | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/megapixels/app/models/sql_factory.py b/megapixels/app/models/sql_factory.py index b270afd2..a580f28e 100644 --- a/megapixels/app/models/sql_factory.py +++ b/megapixels/app/models/sql_factory.py @@ -61,7 +61,8 @@ def load_sql_dataset(path, replace=False, engine=None, base_model=None): print('loading dataset {}'.format(fn)) df = pd.read_csv(fn) # fix columns that are named "index", a sql reserved word - df.columns = table.__table__.columns.keys() + df.reindex_axis(sorted(df.columns), axis=1) + df.columns = sorted(table.__table__.columns).keys() df.to_sql(name=table.__tablename__, con=engine, if_exists='replace', index=False) return dataset |