How do the top pharmaceutical companies compare in terms of research and development spending?

The top pharmaceutical companies, based on market capitalization, are as follows: Eli Lilly (LLY), Novo Nordisk (NVO), Johnson & Johnson (JNJ), Abbvie (ABBV), and Merck (MRK). Here's a comparison of their research and development (R&D) spending: |Ticker|Name|Date|R&D Expenses|code|market_code| |---|---|---|---|---|---| |JNJ.N|Johnson & Johnson|2023 Q4|4.538E9|JNJ|169| |NVO.N|Novo Nordisk|2023 Q4|1.5522051102E9|NVO|169| |MRK.N|Merck|2023 Q4|9.627E9|MRK|169| |LLY.N|Eli Lilly|2023 Q4|2.5627E9|LLY|169| |ABBV.N|Abbvie|2023 Q4|1.927E9|ABBV|169| |JNJ.N|Johnson & Johnson|2024 Q1|3.542E9|JNJ|169| |NVO.N|Novo Nordisk|2024 Q1|1.24522511802E9|NVO|169| |MRK.N|Merck|2024 Q1|3.992E9|MRK|169| |LLY.N|Eli Lilly|2024 Q1|2.5228E9|LLY|169| |ABBV.N|Abbvie|2024 Q1|1.939E9|ABBV|169|