Rename duplicate records in R -


i'd rename duplicate categories in column "product" (data$product) based on order of occurrence. below data frame:

data <- data.frame(product=c("1123tr","5467yr","15-f020wm","15-f020wm","15-f020wm","15-k153cl","17-f222nr","17-f222nr"),                platform=c("caribian","flare","tease","brill","kittl","moui","mouner","fourt"),                value = c(200,500,550,456,678,765,34,33))

below table - how data.frame "data" looks like:

   product    platform    value    1123tr     caribian    200    5467yr     flare       500 15-f020wm     tease       550 15-f020wm     brill       456 15-f020wm     kittl       678 15-k153cl     moui        765 17-f222nr     mouner       34 17-f222nr     fourt        33

and below desired output:

    product        platform    value     1123tr         caribian    200     5467yr         flare       500  15-f020wm(d1)     tease       550  15-f020wm(d2)     brill       456  15-f020wm(d3)     kittl       678  15-k153cl         moui        765  17-f222nr(d1)     mouner       34  17-f222nr(d2)     fourt        33

could give me hint or advice on how please?

this close make.unique of akrun.

ave sort of thing:

> ave(as.character(data$product), data$product, fun=function(x) if (length(x)>1) paste0(x[1], '(', seq_along(x), ')') else x[1]) [1] "1123tr"       "5467yr"       "15-f020wm(1)" "15-f020wm(2)" "15-f020wm(3)" "15-k153cl"    "17-f222nr(1)" "17-f222nr(2)"

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 - .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

Website Login Issue developed in magento -

i have website developed using magento . able login. right now, login failed. infact operations interacts user table failing. need know issue. how figure out? first clear try clear log file second make sure have not upgraded magento and 3rd make sure db accessible in magento -harry p
Read more