Set value for particular cell in pandas DataFrame using index
I have created a Pandas DataFrame
dataframe
Filter dataframe rows if value in column is in a set list of values
I have a Python pandas DataFrame rpt: rpt <class 'pandas.core.frame.DataFrame'> MultiIndex: 47518 entries, ('000002', '20120331') to ('603366', '20091231') Data columns: STK_ID 47518 non-null values STK_Name 47518 non-null values RPT_Date 47518 non-null values sales 47518 non-null values I can filter the rows whose stock id is ‘600809’ like this: rpt[rpt[‘STK_ID’] == ‘600809’] <class 'pandas.core.frame.DataFrame'> MultiIndex: 25 … Read more
How can I use the apply() function for a single column?
I have a pandas data frame with two columns. I need to change the values of the first column without affecting the second one and get back the whole data frame with just first column values changed. How can I do that using apply in pandas?
How to test if a string contains one of the substrings in a list, in pandas?
Is there any function that would be the equivalent of a combination of df.isin() and df[col].str.contains()?
How to replace NaNs by preceding or next values in pandas DataFrame?
Suppose I have a DataFrame with some NaNs:
Performant cartesian product (CROSS JOIN) with pandas
The contents of this post were originally meant to be a part of
Pandas Merging 101,
but due to the nature and size of the content required to fully do
justice to this topic, it has been moved to its own QnA.
Convert a Pandas DataFrame to a dictionary
I have a DataFrame with four columns. I want to convert this DataFrame to a python dictionary. I want the elements of first column be keys and the elements of other columns in same row be values.
Add missing dates to pandas dataframe
My data can have multiple events on a given date or NO events on a date. I take these events, get a count by date and plot them. However, when I plot them, my two series don’t always match.
Annotate bars with values on Pandas bar plots
I was looking for a way to annotate my bars in a Pandas bar plot with the rounded numerical values from my DataFrame.
pandas get rows which are NOT in other dataframe
I’ve two pandas data frames that have some rows in common.