I have the following table:
| company_name | country | ticker | SIC | gender |
| BP PLC | GB | BP | 291 | M |
| BP PLC | GB | BP | 291 | M |
| BP PLC | GB | BP | 291 | M |
| BP PLC | GB | BP | 291 | M |
| BP PLC | GB | BP | 291 | M |
| BP PLC | GB | BP | 291 | F |
| BP PLC | GB | BP | 291 | F |
| ROYAL DUTCH SHELL PLC | NO | RDSB | 131 | M |
| ROYAL DUTCH SHELL PLC | NO | RDSB | 131 | F |
| ROYAL DUTCH SHELL PLC | NO | RDSB | 131 | F |
| ROYAL DUTCH SHELL PLC | NO | RDSB | 131 | F |
| FERGUSON PLC | GB | FERG | 507 | M |
| FERGUSON PLC | GB | FERG | 507 | M |
and I would like to get the following table:
| company_name | country | ticker | SIC | gender | male | female |
| BP PLC | GB | BP | 291 | M | 5 | 2 |
| BP PLC | GB | BP | 291 | M | 5 | 2 |
| BP PLC | GB | BP | 291 | M | 5 | 2 |
| BP PLC | GB | BP | 291 | M | 5 | 2 |
| BP PLC | GB | BP | 291 | M | 5 | 2 |
| BP PLC | GB | BP | 291 | F | 5 | 2 |
| BP PLC | GB | BP | 291 | F | 5 | 2 |
| ROYAL DUTCH SHELL PLC | NO | RDSB | 131 | M | 1 | 3 |
| ROYAL DUTCH SHELL PLC | NO | RDSB | 131 | F | 1 | 3 |
| ROYAL DUTCH SHELL PLC | NO | RDSB | 131 | F | 1 | 3 |
| ROYAL DUTCH SHELL PLC | NO | RDSB | 131 | F | 1 | 3 |
| FERGUSON PLC | GB | FERG | 507 | M | 2 | 0 |
| FERGUSON PLC | GB | FERG | 507 | M | 2 | 0 |
Thanks very much for your help
0 Response to How can I count the rows with specific description of a variable per firm and put 0 otherwise?
Post a Comment