ruby - How do I remove duplicate rows in my CSV? -

-

i have csv has data this:

a.a.b. direct   http://www.aabdirect.com    348 willis ave  mineola ny  11501   (800) 382-1002  no email abeam consulting inc    http://abeam.com    245 park ave    new york    ny  10167   (212) 372-8783  no email abeam consulting inc    http://abeam.com    245 park ave    new york    ny  10167   (212) 372-8783  no email alvarez & marsal    http://www.alvarezandmarsal.com 600 madison ave new york    ny  10022   (212) 759-4433  no email alvarez & marsal    http://www.alvarezandmarsal.com 600 lexington ave ste 6 new york    ny  10022   (212) 759-4433  no email

the key thing here columns in both rows match (like abeam consulting inc), that's not case. websites match, or phone number or name match.

the key thing website. if 2 values have same website, want one.

how de-dupe list in non n+1 way?

preferably native ruby method .uniq or of sort.

just read strings (which i"ve simplified avoid need horizontal scrolling) array:

arr = [   "a.a.b. direct   http://www.aabdirect.com    (800) 382-1002",   "abeam consulting inc    http://abeam.com    (212) 372-8783",   "abeam consulting inc    http://abeam.com    (212) 372-8783",   "alvarez & marsal    http://www.alvarezandmarsal.com (212) 759-4433",   "alvarez & marsal    http://www.alvarezandmarsal.com 10022   (212) 759-4433" ]

and, suggest, use array#uniq, block:

arr.uniq { |line| line[/\shttp:\s+/] }   #=> ["a.a.b. direct   http://www.aabdirect.com    (800) 382-1002",   #    "abeam consulting inc    http://abeam.com    (212) 372-8783",   #    "alvarez & marsal    http://www.alvarezandmarsal.com (212) 759-4433"]

see array#uniq. regex /\shttp:\s+/ reads, "match whitespace followed string "http:", followed 1 or more characters other whitespaces (greedily)".


Comments

Post a Comment

Popular posts from this blog

php - How to display all orders for a single product showing the most recent first? Woocommerce -

-
i have password protected page on frontend. on page, want display full list of purchases associated single woocommerce product id. option 1: i've looked through woocommerce docs , , found: wc_cli_order , list_( $args, $assoc_args ) function lists orders. presumably, orders can filtered product id [--=] filter orders based on order property. line item fields (numeric array, started index zero): line_items.0.product_id option 2: i found article , based on customer id. i've modified code based on guesses meta_key , meta_value. $customer_orders = get_posts( array( 'numberposts' => -1, 'meta_key' => '_product', 'meta_value' => get_product_id(), 'post_type' => wc_get_order_types(), 'post_status' => array_keys( wc_get_order_statuses() ), ) ); how display orders single product showing recent order first? here solution put based on these articles: http://www.w...
Read more

asp.net - How to correctly use QUERY_STRING in ISAPI rewrite? -

-
i'm having difficult time , hope guys can help. using helicon isapi rewrite version 3.1.0.104 on our iis server. edit http.conf file , have tried , still fail. this trying do: redirect url: https://www.domain.com/switch-by-version?version=2.8.5.2594 to: https://test.domain.com/load/load.aspx?tver=2.8.5.2594 the version number @ end source url change, , need target url have same version number @ end of url example above shows. i tried following not work: rewritecond %{query_string} ^version=(\d\d?)\.(\d\d?)\.(\d\d?)\.(.*)$ [nc] rewriterule ^/switch-by-version(.*)$ https://test.domain.com/load/load.aspx?tver=%1 [r=307,nc,l] any appreciated! thanks. if it's running in equivalent context of .htaccess , rule shouldn't start / . here's simpler version: rewritecond %{query_string} ^version=(\d+\.\d+\.\d+(?:\..+)?)$ [nc] rewriterule ^switch-by-version/?$ https://test.domain.com/load/load.aspx?tver=%1 [r=307,nc,l]
Read more

angularjs - How restrict admin panel using in backend laravel and admin panel on angular? -

-
https://scotch.io/tutorials/token-based-authentication-for-angularjs-and-laravel-apps following tutorials, try write authentication restrict admin panel, didn't understood how can that. this admin panel, admin panel don't want show , request database unauthenticated users. my laravel-routes route::get('/admin',function(){ return view('index'); }); route::get('/api/v1/employees/{id?}', 'employees@index'); route::get('/api/v1/users/{id?}', 'employees@users'); route::post('/api/v1/employees', 'employees@store'); route::post('/api/v1/employees/{id}', 'employees@update'); route::delete('/api/v1/employees/{id}', 'employees@destroy'); route::group(['prefix' => 'api'], function() { route::resource('authenticate', 'authenticatecontroller', ['only' => ['index']]); route::post('authenticate', 'authentic...
Read more