These are suggestions from a R practice, with handy functionalities i frequently use:<

Thanks for sharing! <a class="user-mention notranslate" data-hovercard-type="user" dat

I added a new utility function for renaming columns : <div class="snippet-clipboar

New selection helpers now staged for <a href="https://github.com/uwdata/arquero/pull/4

Add additional selection helpers. about arquero HOT 6 CLOSED

uwdata commented on August 24, 2024

Add additional selection helpers.

from arquero.

Comments (6)

jheer commented on August 24, 2024

Thanks! I've created a PR that adds more selection helpers (matches, startswith, endswith) for parity with dplyr.

As for more advanced renaming support, you can always add (and share!) your own utilities outside of the core Arquero library. For example:

function normalize_name(str) {
  // perform custom column name normalization
}

// create a mapping of original column names to normalized names
const nameMap = {};
table.columnNames.forEach(s => nameMap[name] = normalize_name(s));

// rename the columns
const newTable = table.select(nameMap);

from arquero.

ericemc3 commented on August 24, 2024

Thank you for the suggestion, so here is my share for normalizing table columns names:

function normalize_column_name(str, options = {lower:true}) {
    str = str.replace(/[%#$£()\'\"]/g, '')
             .replace( /[ /,+.*:\-\r\n@]/g, "_" ) 
             .replace(/_+/g, '_') 
             .normalize("NFD").replace(/[\u0300-\u036f]/g, "") //get rid of accents
   
  if (options.lower) 
    str = str.toLowerCase() ;
  
  return str ;
}

function normalize_table_names(tb, options = {lower:true}) {
  return tb.select( tb.columnNames().map(d => ({[d]: normalize_column_name(d, options)})) ) ;
}

from arquero.

jheer commented on August 24, 2024

Thanks for sharing! @ericemc3, do you mind if I later add this (or a minor revision thereof) to the Arquero Cookbook? If that's OK, let me know how you'd like me to acknowledge your contribution (by name, GitHub id, Observable id, or...?).

from arquero.

ericemc3 commented on August 24, 2024

My pleasure, you can of course reuse this as you want. I published them on https://observablehq.com/@ericmauviere/arquero-table-utils

from arquero.

ericemc3 commented on August 24, 2024

I added a new utility function for renaming columns :

function rename_columns(tb, upd) {
  let colsdef = tb.columnNames().map(d => ({[d]:d}) ).reduce((a,v) => Object.assign(a,v)) ;
  
  for (const k in upd) {
    if (colsdef.hasOwnProperty(k)) 
        colsdef[k] = upd[k] ; 
  }
  
  return tb.select(colsdef) ;
}

rename_columns(tb, {currentname1:'newname1', currentname2:'newname2'})

from arquero.

jheer commented on August 24, 2024

New selection helpers now staged for v1.2.0.

from arquero.

Recommend Projects