How to find number of specific column in csv using pandas?

Question

This is my csv file.

Iam uploading this data to db using python pandas.How to find the number of fee columns are there(fee_1,fee_2,fee_3)?. Because the start,end,fee columns are dynamic. I need to upload based on the number of fee columns.

If number of fee columns is 2 means i need to upload this,

"slot_fee":[{"start": i['Start_1'],"end": i['End_1'],"fee": i['Fee_1']},{"start": i['Start_2'],"end": i['End_2'],"fee": i['Fee_2']}]

If it is 3 means i need to upload this,and so on.

"slot_fee":[{"start": i['Start_1'],"end": i['End_1'],"fee": i['Fee_1']},{"start": i['Start_2'],"end": i['End_2'],"fee": i['Fee_2']},{"start": i['Start_3'],"end": i['End_3']]

Can anyone help me with the python pandas code for this?

You may want to look at formatting your question better for clarity: stackoverflow.com/editing-help#tables — ScottC
– ScottC, Commented Oct 4, 2022 at 8:22

grymlin · Accepted Answer · 2022-10-04 08:27:33Z

1

If I understand your question correctly this might help :

df.columns[df.columns.str.startswith('Fee_')]

it gives you the list of columns that start with Fee_, if you want the last one you can add

df.columns[df.columns.str.startswith('Fee_')][-1]

answered Oct 4, 2022 at 8:27

grymlin

5022 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

rovoda Over a year ago

It is giving only this output. Index([], dtype='object')

grymlin Over a year ago

can you upload an example of the dataframe i can reproduce ? @rovoda

rovoda Over a year ago

I have added the dataframe above. Need the number of fee columns.

Collectives™ on Stack Overflow

How to find number of specific column in csv using pandas?

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related