Python standard_load_from_data_list Examples

Example #1

    except Exception: 
        pd.DataFrame(meta,columns = ["key","value","notes"]).to_csv(metafile, encoding="utf8", float_format='%.3f',index=False)
       
    filelist.append(filestem)
    
pd.DataFrame(filelist).to_csv(config["gen_2_dir"] + "_" + config["prefix"] + ".csv", encoding="utf8", index=False, header=False)
us.log("%i series saved to %s" % (len(filelist), config["gen_2_dir"]))

# <markdowncell>

# Generation 3 - Load the Generation 2 data into the database.

# <codecell>

data_list = gen3_utils.get_gen2_data(config)
gen3_utils.standard_load_from_data_list(data_list)
data_list[0][1]

# <markdowncell>

# Here are the names of the series:

# <codecell>

filelist

# <markdowncell>

# Generation 4 - Build a portion of query string that can be used to access a graph of this data.

# <codecell>

Example #2

                                                        index=False)
    filelist.append(filestem)

pd.DataFrame(filelist).to_csv(config["gen_2_dir"] + "_" + config["prefix"] +
                              ".csv",
                              encoding="utf8",
                              index=False,
                              header=False)
us.log("%i series saved to %s" % (len(filelist), config["gen_2_dir"]))

# <markdowncell>

# Generation 3 - Load the Generation 2 data into the database.

# <codecell>

data_list = gen3_utils.get_gen2_data(config)
observation_fields = "series, description, value, locationid"
gen3_utils.standard_load_from_data_list(data_list, observation_fields)
data_list

# <markdowncell>

# Here are the names of the series:

# <codecell>

filelist

# <codecell>

Example #3

File: sidsrcm_water-desal.py Project: spikewilliams/statmart

 
    metafile = config["gen_2_dir"] + filestem + "_meta.csv"    
    pd.DataFrame(meta,columns = ["key","value"]).to_csv(metafile, encoding="utf8", float_format='%.3f',index=False)
    filelist.append(filestem)
    
pd.DataFrame(filelist).to_csv(config["gen_2_dir"] + "_" + config["prefix"] + ".csv", encoding="utf8", index=False, header=False)
us.log("%i series saved to %s" % (len(filelist), config["gen_2_dir"]))

# <markdowncell>

# Generation 3 - Load the Generation 2 data into the database.

# <codecell>

data_list = gen3_utils.get_gen2_data(config)
observation_fields = "series, description, value, locationid"
gen3_utils.standard_load_from_data_list(data_list, observation_fields)
data_list

# <markdowncell>

# Here are the names of the series:

# <codecell>

filelist

# <codecell>