def getData_oeko():
"""retrieve data from MySQL database."""
ObjData = MSdb("materials")
oekobau = ObjData.getDataFrame("oeko", Col=",".join(OEKOBAU_COLS))
ObjData.close()
oekobau["name"] = oekobau["name"].apply(change_str)
return(oekobau)
def getData_masea():
"""retrieve data from MySQL database."""
ObjData = MSdb("materials")
masea = ObjData.getDataFrame("masea", Col=",".join(MASEA_COLS))
ObjData.close()
extra_col = ['n.a', 'n.a', 'n.a', np.nan, np.nan, np.nan, np.nan]
a = pd.DataFrame({"L": extra_col}).T
a.columns = masea.columns
masea = masea.append(a)
return(masea)
def main():
from root.MySQL.dbData import MSdb
ObjData = MSdb("materials")
masea_cols = ["name", "family", "subfamily",
"DenV", "ConducV", "HeatV", "DiffV"]
masea = ObjData.getDataFrame("masea", Col=",".join(masea_cols))
ObjData.close()
masea_single = [("Conductivity", "ConducV")]
masea_multiple = {"Material": masea_cols[0:3]}
found_data = masea.loc[getMaterialIndex(
217, masea, w=10, single=masea_single, multiple=masea_multiple)]
# masea.ix[getMaterialIndex(
# 1, masea, single=masea_single, multiple=masea_multiple)]
print(found_data)