Is What I Am Trying to Achieve not Python permissable?

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’

This article explained what went wrong. Am I correct in saying that what I’m doing here isn’t permitted on Python? If so, what other ways can I have a small table of VAX_MANU, VAX_LOT, frequency of specific lot number?

Hi @MfonobongAmana

Please provide some dummy data and a sample of what you wish your final output should be like. It isn’t clear from your question.

Thanks.

Rucha this is the closest I can find

http://howbadismybatch.info/pfizer.html

You will see how there’s the lot number and the ADRs, the first 2 columns.

What I am looking to do is to just have a specific manufacturer, say Pzifer, the most prevalent lot number with a limit of 15, and the total number of suffered from select cardiovascular events as a result of the lot number

Hi @MfonobongAmana

Sorry. I still can’t understand your question. :frowning:

The current table already has data sorted in descending order by the “ADRs” column. Are you trying to replicate the same table with a different dataset or the table itself is the source of data?

im trying to get a png file of the table so same table type with a different dataset

I just moved on from using Python and just used Google Sheets to get what I wanted