How to keep index when using pandas merge
I would like to merge two DataFrames, and keep the index from the first frame as the index on the merged dataset. However, … Read more
pandas
How to change the datetime format in Pandas
My dataframe has a DOB column (example format 1/1/2016) which by default gets converted to Pandas dtype ‘object’. Converting this to date format … Read more
How do I find numeric columns in Pandas?
Let’s say df is a pandas DataFrame. I would like to find all columns of numeric type. Something like: isNumeric = is_numeric(df) 12 … Read more
Format y axis as percent
I have an existing plot that was created with pandas like this: df[‘myvar’].plot(kind=’bar’) The y axis is format as float and I want … Read more
How to read a .xlsx file using the pandas Library in iPython?
I want to read a .xlsx file using the Pandas Library of python and port the data to a postgreSQL table. All I … Read more
Check if a value exists in pandas dataframe index
I am sure there is an obvious way to do this but cant think of anything slick right now. Basically instead of raising … Read more
Pandas join issue: columns overlap but no suffix specified
I have the following data frames: print(df_a) mukey DI PI 0 100000 35 14 1 1000005 44 14 2 1000006 44 14 3 … Read more
getting the index of a row in a pandas apply function
I am trying to access the index of a row in a function applied across an entire DataFrame in Pandas. I have something … Read more
what is the most efficient way of counting occurrences in pandas?
I have a large (about 12M rows) DataFrame df with say: df.columns = [‘word’,’documents’,’frequency’] So the following ran in a timely fashion: word_grouping … Read more
extract column value based on another column pandas dataframe
I am kind of getting stuck on extracting value of one variable conditioning on another variable. For example, the following dataframe: A B … Read more