pandas Archives - Page 21 of 25

How to check whether a pandas DataFrame is empty?

How to check whether a pandas DataFrame is empty? In my case I want to print some message in terminal if the DataFrame ...

May 3, 2022
0 Comments

Selecting a row of pandas series/dataframe by integer index

I am curious as to why df[2] is not supported, while df.ix[2] and df[2:3] both work. In [26]: df.ix[2] Out...

May 2, 2022
0 Comments

How to delete rows from a pandas DataFrame based on a conditional expression [duplicate]

This question already has answers here: Deleting DataFrame row in Pandas based on column value (14 answers) Closed 1 year ago. I have ...

May 2, 2022
0 Comments

pandas create new column based on values from other columns / apply a function of multiple columns, row-wise

I want to apply my custom function (it uses an if-else ladder) to these six columns (ERI_Hispanic, ERI_AmerInd_AKNatv, ERI_Asian, ERI_Black_Afr.Amer, ERI_HI_PacIsl, ERI_White) in ...

May 2, 2022
0 Comments

Filter dataframe rows if value in column is in a set list of values [duplicate]

This question already has answers here: How to filter Pandas dataframe using ‘in’ and ‘not in’ like in SQL (11 answers) Use a ...

May 2, 2022
0 Comments

Python Pandas Error tokenizing data

I’m trying to use pandas to manipulate a .csv file but I get this error: pandas.parser.CParserError: Error tokenizing data. C error: Expected 2 ...

May 2, 2022
0 Comments

How to replace NaN values by Zeroes in a column of a Pandas Dataframe?

I have a Pandas Dataframe as below: itm Date Amount 67 420 2012-09-30 00:00:00 65211 68 421 2012-09-09 00:00:00 29424 69 421 2012-09-16 ...

April 30, 2022
0 Comments

How to apply a function to two columns of Pandas dataframe

Suppose I have a df which has columns of 'ID', 'col_1', 'col_2'. And I define a function : f = lambda x, y ...

April 30, 2022
0 Comments

How to get a value from a cell of a dataframe?

I have constructed a condition that extract exactly one row from my data frame: d2 = df[(df['l_ext']==l_ext) & (df['item']==item) & (df['wn']==wn) & (df...

April 30, 2022
0 Comments