+- Python Forum (https://python-forum.io)
+-- Forum: Python Coding (https://python-forum.io/forum-7.html)
+--- Forum: Data Science (https://python-forum.io/forum-44.html)
+--- Thread: Create a Table to a PNG file (/thread-37931.html)
Create a Table to a PNG file - amanajosh - Aug-11-2022
Hi
I am trying to create a table with the vaccine lot number and cardiovascular adverse events. I want to have a table where I have the values in descending order, with a limit of 15 in the table. The columns need to have VAX_MANU, VAX_LOT, and total number of cardiovascular adverse events per specific lot number.
VAX_MANU and VAX_LOT is part of the original dataset so I am trying to find the most documented lot number for any manufacturer (Pzifer, Moderna, Johnson & Johnson) and then creating a table that has VAX_MANU, VAX_LOT and the frequency
This is my code:
## Understand value_counts() covid_vaers_cardio['VAX_LOT'].value_counts() ## Create a count for all the Lot Numbers total_number = covid_vaers_cardio['VAX_LOT'].value_counts() ## Create a table covid_vaers_lot = covid_vaers_cardio[['VAX_MANU', 'VAX_LOT', 'total_number']] Error: KeyError: “[‘total_number’] not in index” Another attempt: ## Understand value_counts() covid_vaers_cardio['VAX_LOT'].value_counts() ## Create a count for all the Lot Numbers total_number = covid_vaers_cardio['VAX_LOT'].value_counts() ## Create a table covid_vaers_lot = covid_vaers_cardio['VAX_MANU'].merge(total_number, how='outer')
Error:AttributeError Traceback (most recent call last)
~\AppData\Local\Temp/ipykernel_18536/3237736396.py in
----> 1 covid_vaers_lot = covid_vaers_cardio[‘VAX_MANU’].merge(total_number, how=‘outer’)
~\anaconda3\lib\site-packages\pandas\core\generic.py in getattr(self, name)
5485 ):
5486 return self[name]
→ 5487 return object.getattribute(self, name)
5488
5489 def setattr(self, name: str, value) → None:
AttributeError: ‘Series’ object has no attribute ‘merge’