def main(): scrapedascii = scraping_allascii() output = toSQLfrompreprocessed(NISTPhysicalConstant,scrapedascii[3], scrapedascii[5]) session.add_all( output ) session.commit() headers, convdata, convdata2 = make_conv_lst() output2 = toSQLfrompreprocessed(NISTConversionFactor, headers, convdata2) session.add_all( output2 ) session.commit() session.close() return output, output2
def main(): scrapedascii = scraping_allascii() tbl = liteprocess( scrapedascii[4] ) output = toSQLitefrompreprocessed(NISTPhysicalConstantLite,scrapedascii[3], tbl) session.add_all(output) session.commit() headers, convdata, convdata2 = make_conv_lst() output2 = toSQLitefrompreprocessed(NISTConversionFactorLite, headers, liteprocessconvfact(convdata2)) session.add_all( output2 ) session.commit() session.close() return output, output2
def main(): scrapedascii = scraping_allascii() tbl = liteprocess(scrapedascii[4]) output = toSQLitefrompreprocessed(NISTPhysicalConstantLite, scrapedascii[3], tbl) session.add_all(output) session.commit() headers, convdata, convdata2 = make_conv_lst() output2 = toSQLitefrompreprocessed(NISTConversionFactorLite, headers, liteprocessconvfact(convdata2)) session.add_all(output2) session.commit() session.close() return output, output2
import Tconv from Tconv import FCconv, KCconv, T_C, T_K, T_F import pandas as pd import numpy as np from scrape_BS import scraping_allascii # cf. http://stackoverflow.com/questions/7165749/open-file-in-a-relative-location-in-python print os.path.dirname(__file__) _Physique_dir = os.path.dirname(__file__) _RAWDAT_DIR = "rawdata/" print os.path.join(_Physique_dir,_RAWDAT_DIR) lines,title,src,header,rawtbl,tbl=scraping_allascii( os.path.join(_Physique_dir,_RAWDAT_DIR)+"allascii.txt") FundConst = pd.DataFrame(tbl,columns=header) conv = pd.read_pickle( os.path.join(_Physique_dir,_RAWDAT_DIR)+"DF_conv" ) plnfacts = pd.read_pickle( os.path.join(_Physique_dir,_RAWDAT_DIR)+"DF_plnfacts" )
############################################################################ import re import decimal from decimal import Decimal, InvalidOperation import pandas as pd import numpy as np from scrape_BS import scraping_allascii, make_conv_lst, make_NASAPLNFACTS, make_Braeunig_ATMOS ################################### #### Preprocessing for Pandas ### From a list ################################### lines,title,src,header,rawtbl,tbl=scraping_allascii() FundConst = pd.DataFrame(tbl,columns=header) ######################### #### Examples of usage ######################### # FundConst.columns ## Index([u'Quantity', u'Value', u'Uncertainty', u'Unit'], dtype='object') # ks = FundConst[ FundConst["Quantity"].str.contains("Boltzmann") ] ## look at what you want and see the index; it happens to be 49 in this example. # ks.loc[49,:] # ks.loc[49,:].Quantity ## 'Boltzmann constant' # ks.loc[49,:].Value ## Decimal('1.38064852E-23')