docs/Api/nz_convert_df_to_dggs.md

In thespatiallabatLaurier/nzdggs: Manipulate and Run Analysis on Netezza Using IDEAS Model

nz_convert_df_to_dggs: dataframe to dggs

Description

Converts a dataframe with a DGGID/TID column and set of other columns (keys) to csv datasets to be able to import them into netezza. You can import csv files to the database using nz_import_dir_to_db function

Usage

nz_convert_df_to_dggs(DGGID, TID, df, SaveIn, convertKeys = "all")

Arguments

Argument |Description ------------- |---------------- DGGID | A dataframe column containing DGGIDs TID | An integer or dataframe column df | dataframe with the remaining keys. Remove DGGID/TID columns from it SaveIn | The directory path to store data there. It must exist convertKeys | Keys that are supposed to be converted. all means converting all the keys. NA means does not convert any keys.Use a vector of column names to only convert specific keys

Value

Examples

csv<-read.csv2("D:\\UserData\\Majid\\Downloads\\mpb-ev.csv",sep=",")
head(csv)
nz_convert_df_to_dggs(csv$DGGID,-1,csv,"E:\\home\\crobertson")\
#importing to the db
DSN <- nz_init("NZSQLF","SPATIAL_SCHEMA")
nz_import_dir_to_db(DSN,"/home/crobertson/import/","mbpev","varchar(100)")

thespatiallabatLaurier/nzdggs documentation built on Sept. 7, 2020, 4:33 p.m.