r - All column names are in one cell -


this code. point find blank rows in 1 column, in case defined address.1, , replace corresponding row 1 of 2 other columns, defined here rf_ms_address1 , rf_ghq_address1:

withblanks <- read.csv("file.csv", stringsasfactors = false)  fun <- function(x, y, z) {   y[y == ""] <- z[y == ""] #substitute missings in y values z   x[x == ""] <- y[x == ""] #substitute missings in x values y   x #return }  noblanks <- within(withblanks, "address.1" <- fun("address.1", "rf_ms_address1", "rf_ghq_address1")) write.table(noblanks, "file.csv", sep = ",", col.names = true, row.names = false)

the resultant file has headers in single cell, separated period. example: "contactid.email.address.first.name.middle.name.etc." naturally want them in separate cells, right file unusable. doing wrong result?

this sample representation of first row:

contactid.email.address.first.name.middle.name.last.name.company.address.1.address.2.address.3.city.state.or.province.zip.or.postal.code.country.business.phone.mobile.phone.fax.title.salutation.ticker.symbol.language.salesperson.sfdccontactid.sfdclea ...     1 1 1 2393392 emailemail@email.net firstname  lastname 868 management company 1b, plaza place, 12 location road, city, city   city city city city  city city +111 11111111   principal  na   22222222222222   8/1/2013 0:30 5/29/2015 12:06 llll0909090909 contactid.email.address.first.name.middle.name.last.name.company.address.1.address.2.address.3.city.state.or.province.zip.or.postal.code.country.business.phone.mobile.phone.fax.title.salutation.ticker.symbol.language.salesperson.sfdccontactid.sfdclea ... 1 1 1 2393392 emailemail@email.net firstname  lastname 868 management company 1b, plaza place, 12 location road, city, city   city city city city  city city +111 11111111   principal  na   22222222222222   8/1/2013 0:30 5/29/2015 12:06 llll0909090909 0909090909opk 5/28/2015 22:20    na na na na 0 na na na na na  gud 565787   na na na na  na na na na  na  na na na na na na na na na na na na other  (specify in description box)            0 capital.net firstname lastname  567234 portfolio management  region 0 0   mgt d 4 d4 3/8/2014 2:09 na firstlastletters     false  cash na cash cash   na na na    na 10/11/2013 4:52  contact name 9584639474ucon 4/14/2014 3:57       9584639474ucon     9584639474ucon 9584639474ucon 9584639474ucon 9584639474ucon9584639474ucon contact name pos ition,  sales (356) 782-983 email@email.com 9584639474ucon 2- warm  0 242  0  6 attempts/no contact website rejected   9584639474ucon contact name 0  geo region  0        product 0  na  region 8/1/2013 0:17 1/11/2014 6:49  na email@email.com         na  na na na na na na           na na na na      na na na            na  9584639474ucon  5/25/2015 0:00 12/12/2014 0:00 5/25/2015 0:00   na  na  na address 1 address.1 5/28/2015 22:20    na na na na 0 na na na na na  gud 565787   na na na na  na na na na  na  na na na na na na na na na na na na other  (specify in description box)            0 capital.net firstname lastname  567234 portfolio management  region 0 0   mgt d 4 d4 3/8/2014 2:09 na firstlastletters     false  cash na cash cash   na na na    na 10/11/2013 4:52  contact name 9584639474ucon 4/14/2014 3:57       9584639474ucon     9584639474ucon 9584639474ucon 9584639474ucon 9584639474ucon9584639474ucon contact name pos ition,  sales (356) 782-983 email@email.com 9584639474ucon 2- warm  0 242  0  6 attempts/no contact website rejected   9584639474ucon contact name 0  geo region  0        product 0  na  region 8/1/2013 0:17 1/11/2014 6:49  na email@email.com         na  na na na na na na           na na na na      na na na            na  9584639474ucon  5/25/2015 0:00 12/12/2014 0:00 5/25/2015 0:00   na  na  na address 1 address.1


Comments

Post a Comment

Popular posts from this blog

Magento/PHP - Get phones on all members in a customer group -

i working on custom magento extension. working around adminhtml part , i've created custom form there. here form code: <?php class vivasindustries_smsnotification_block_adminhtml_sms_sendmass_edit_form extends mage_adminhtml_block_widget_form { public function _preparelayout() { $extensionpath = mage::getmoduledir('js', 'vivasindustries_smsnotification'); $head = $this->getlayout()->getblock('head'); $head->addjs('jquery.js'); $head->addjs('vivas.js'); return parent::_preparelayout(); } protected function _prepareform() { $form = new varien_data_form(array( 'id' => 'edit_form', 'action' => $this->geturl('*/*/save', array('id' => $this->getrequest()->get...
Read more

php - Bypass Geo Redirect for specific directories -

i'm trying bypass redirect specific url within site. wondering if might able help. the code below code use, original urls replaces example.com i'd able access http://example.com/admin without redirect occuring. is there way this, , there way using own ip? function country_geo_redirect() { $country = getenv('http_geoip_country_code'); if ($country == "us" ) { wp_redirect("http://usa.example.com/"); exit; } else if ($country == "gb" ) { wp_redirect("http://uk.example.com/"); exit; } } add_action('init', 'country_geo_redirect'); you can bypass redirection code if server found ip address. if ip address == <my ip address> ' nothing here else country_georedirect() end if
Read more

php - .htaccess mod_rewrite for dynamic url which has domain names -

i want convert url ex:( example.com/link.php?url=facebook.com ) ( example.com/facebook.com.php ) how can using .htaccess. or there other process make job easier ? i tried adding script .htaccess file options +followsymlinks rewriteengine on rewriterule url-(.*)\.htm$ link.php?url=$1 but converting url adding "url-" ( example.com/url-facebook.com.php ) i want remove "url-" , want make ( example.com/facebook.com.php ) rewriteengine on rewritecond %{the_request} ^get.*link\.php\?url\= [nc] rewritecond %{request_uri} !/system/.* [nc] rewriterule (.*?)link\.php\?url\=/*(.*) /$1$2 [r=301,ne,l] not sure how above work edit of used use remove index.php url
Read more