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