Skip to main content

Utility to convert Excel tables to a sqlite database and access the data

Project description

SASA Database

I don't think this is usable by anyone lese but it's a dependency to sasa_stacker and I wanted to package it separately. An explanation to the whole project can be found here.

Usage

exl_to_sql.py -h:


exl_to_sql.py [-h] [-n SHEET_NUMBER] [-v] [-s] exl db

positional arguments:
  exl                   path to excel-file
  db                    path to sqlite3-db


optional arguments:
  -h, --help            show this help message and exit
  -n SHEET_NUMBER, --sheet-number SHEET_NUMBER
                        which excel-sheet to convert
  -v, --verbose         verbose output
  -s, --skip-existing   skipping rows already contained in the db

Writes the excel file exl into the sqlite database db. Every row in the Excel sheet represents one simulation run of metasurfaces. The problem is with our current setup they are saved as one big .mat file but the sasa_stacker needs to access them and their parameters individually. This script assigns each single metasurface an address and saves its parameters in the db separately. Examples for the formating of the excel sheet can be found in data/NN_smats.xlsx.

Crawler

The Crawler class allows access to the db and loads the simulation data. The main functions are:

find_smat

Crawler.find_smat(name, adress=None)

Loads the simulation data to name. If an adress is provided it only loads this single S-matrix.

Arguments

  • name: string, name of the simulation in the database
  • adress: list, for example [1,4,5,3] the adress can also be found in the database

find_smat_by_id

Crawler.find_smat_by_id(id)

Same as above but takes the simulation id

Arguments

  • id: int, simulation id found in the database

extract_params

Crawler.extract_params(id)

Queries meta_materials.db for all the parameters to the given ID.

Arguments

  • id: int, simulation id found in the database

Returns

  • param_dict: dict, contains the combined data from the simulations and geometry tables with coresponding names

Project details


Release history Release notifications

This version

0.1

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Files for sasa-db, version 0.1
Filename, size File type Python version Upload date Hashes
Filename, size sasa_db-0.1-py3-none-any.whl (11.2 kB) File type Wheel Python version py3 Upload date Hashes View
Filename, size sasa_db-0.1.tar.gz (112.5 kB) File type Source Python version None Upload date Hashes View

Supported by

Pingdom Pingdom Monitoring Google Google Object Storage and Download Analytics Sentry Sentry Error logging AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN DigiCert DigiCert EV certificate StatusPage StatusPage Status page