pandas Archives - Page 2 of 25

Programming, Python

IT Nursery

Pretty Printing a pandas dataframe

How can I print a pandas dataframe as a nice text-based table, like the following? +------------+---------+-------------+ | column_one | col_two | column_3 | ...

June 2, 2022
0 Comments

Programming, Python

IT Nursery

How to access pandas groupby dataframe by key

How do I access the corresponding groupby dataframe in a groupby object by the key? With the following groupby: rand = np.random.RandomState(1) df ...

June 2, 2022
0 Comments

Programming, Python

IT Nursery

How to unnest (explode) a column in a pandas DataFrame, into multiple rows

I have the following DataFrame where one of the columns is an object (list type cell): df=pd.DataFrame({'A':[1,2],'B':[[1,2],[1,2]]}) df Out...

June 2, 2022
0 Comments

Programming, Python

IT Nursery

Pandas convert dataframe to array of tuples

I have manipulated some data using pandas and now I want to carry out a batch save back to the database. This requires ...

June 2, 2022
0 Comments

Programming, Python

IT Nursery

Remove unwanted parts from strings in a column

I am looking for an efficient way to remove unwanted parts from strings in a DataFrame column. Data looks like: time result 1 ...

June 2, 2022
0 Comments

Programming, Python

IT Nursery

Pandas DataFrame column to list [duplicate]

This question already has answers here: How do I convert a pandas Series or index to a Numpy array? [duplicate] (8 answers) Get ...

June 1, 2022
0 Comments

Programming, Python

IT Nursery

Pandas: sum DataFrame rows for given columns

I have the following DataFrame: In [1]: df = pd.DataFrame({'a': [1, 2, 3], 'b': [2, 3, 4], 'c': ['dd', 'ee', 'ff'], 'd':...

June 1, 2022
0 Comments

Programming, Python

IT Nursery

Right way to reverse a pandas DataFrame?

Here is my code: import pandas as pd data = pd.DataFrame({'Odd':[1,3,5,6,7,9], 'Even':[0,2,4,6,8,10]}) for i in reversed(data): print(data['Odd'], data...

June 1, 2022
0 Comments

Programming, Python

IT Nursery

How to add title to seaborn boxplot

Seems pretty Googleable but haven’t been able to find something online that works. I’ve tried both sns.boxplot('Day', 'Count', data= gg).title('lalala') and sns.boxplot('Day', 'Count', ...

June 1, 2022
0 Comments

Programming, Python

IT Nursery

How to form tuple column from two columns in Pandas

I’ve got a Pandas DataFrame and I want to combine the ‘lat’ and ‘long’ columns to form a tuple. <class 'pandas.core.frame.DataFrame'> Int64Index: 205482 ...

June 1, 2022
0 Comments