jQuery How to count the no of rows in table by distinct column value

Question

How can I count the distinct table rows by table column?

Example:

<table>
   <thead> 
      <tr>
        <th>NAME</th>
        <th>TECHNOLOGY</th>
     </tr>
   </thead>
   <tbody>  
     <tr>
        <td>john</td>
        <td>jQuery</td>
    </tr>
    <tr>
       <td>mark</td>
       <td>css</td>
    </tr>
    <tr>
       <td>blah</td>
       <td>css</td>
    </tr>
    <tr>
       <td>abc</td>
       <td>css</td>
    </tr>
    <tr>
       <td>xyz</td>
       <td>jQuery</td>
    </tr>
  </tbody>
</table>

I want Out put:

css : 3
jQuery : 2

here I don't know what technology is come in that cell but, I need to get the no of rows by the technology

Thanks in advance

Check out this question: stackoverflow.com/questions/15411966/… I think that it could help you :) — Victor
– Victor, Commented Jan 20, 2014 at 16:50

Tomalak · Accepted Answer · 2014-01-20 16:50:50Z

7

var byTechnology = {};

$("table tbody td:nth-child(2)").each(function () {
    var tech = $.trim( $(this).text() );

    if ( !(byTechnology.hasOwnProperty(tech)) ) {
        byTechnology[tech] = 0;
    }

    byTechnology[tech]++;
});

console.log(byTechnology);
// {
//     css: 3,
//     jQuery: 2
// }

answered Jan 20, 2014 at 16:50

Tomalak

339k68 gold badges547 silver badges635 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Binita Mehta · Accepted Answer · 2014-01-20 17:11:44Z

Call function below on load. Check this jsFiddle out - http://jsfiddle.net/pqzKa/2/

function count()
{

var map = {};

$("tbody tr td:nth-child(2)").each(function(i, val){
              var key = $(val).text();
               if (key in map)                   
                   map[key]=map[key] + 1;                                    
               else
                   map[key] = 1;                           
              });

var result='';
for(var key in map)
{
 result += key + ':' + map[key] + '\n';   
}
alert(result);
}

The function builds a hashmap called map. It then iterates over the second cell of each tr in tbody and checks to see if it is present in the map. If not, it adds it to the hashmap with a count of 1. If yes, it increments the count by 1. I hope this helps.

sidarcy · Accepted Answer · 2014-01-20 17:21:44Z

1

Another route might be to write a more generic function for counting people who use certain technologies.

Assuming your using jQuery and your table has an id 'tech' you could do something like this

counter = function(textMatch){
    count=0;
    //loop through all <tr> s
    $('#tech').find('tbody tr').each(function( index ) {
        //if second <td> contains matching text update counter
        if($($(this).find('td')[1]).text() == textMatch){
            count++
        }
    });
    return count;
}

console.log('Number of people using CSS is ' + counter('css'));
console.log('Number of people using CSS is ' + counter('jQuery'));

//and so on

answered Jan 20, 2014 at 17:21

sidarcy

3,0082 gold badges39 silver badges37 bronze badges

Collectives™ on Stack Overflow

jQuery How to count the no of rows in table by distinct column value

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related