Top "Pandas" questions

How to count the NaN values in a column in pandas DataFrame

I want to find the number of NaN in each column of my data so that I can drop a …

python pandas dataframe

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 …

python csv pandas

Select by partial string from a pandas DataFrame

I have a DataFrame with 4 columns of which 2 contain string values. I was wondering if there was a way to …

python string pandas dataframe

Pretty-print an entire Pandas Series / DataFrame

I work with Series and DataFrames on the terminal a lot. The default __repr__ for a Series returns a reduced …

python pandas dataframe

Convert Python dict into a dataframe

I have a Python dictionary like the following: {u'2012-06-08': 388, u'2012-06-09': 388, u'2012-06-10': 388, …

python pandas dataframe

count the frequency that a value occurs in a dataframe column

I have a dataset |category| cat a cat b cat a I'd like to be able to return something like (…

python pandas

Load data from txt with pandas

I am loading a txt file containig a mix of float and string data. I want to store them in …

python io pandas

Converting a Pandas GroupBy output from Series to DataFrame

I'm starting with input data like this df1 = pandas.DataFrame( { "Name" : ["Alice", "Bob", "Mallory", "Mallory", "Bob" , "Mallory"] , "City" : ["Seattle", "Seattle", "…

python pandas dataframe pandas-groupby multi-index

Pandas - Get first row value of a given column

This seems like a ridiculously easy question... but I'm not seeing the easy answer I was expecting. So, how do …

python pandas indexing head

Delete rows from a pandas DataFrame based on a conditional expression involving len(string) giving KeyError

I have a pandas DataFrame and I want to delete rows from it where the length of the string in …

python pandas