dataframe Archives - Page 3 of 17

Programming, r

IT Nursery

Determine the data types of a data frame’s columns

I’m using R and have loaded data into a dataframe using read.csv(). How do I determine the data type of each column in ...

May 31, 2022
0 Comments

Programming, Python

IT Nursery

pandas dataframe columns scaling with sklearn

I have a pandas dataframe with mixed type columns, and I’d like to apply sklearn’s min_max_scaler to some of the columns. Ideally, I’d ...

May 30, 2022
0 Comments

Programming, Python

IT Nursery

datetime dtypes in pandas read_csv

I’m reading in a csv file with multiple datetime columns. I’d need to set the data types upon reading in the file, but ...

May 30, 2022
0 Comments

Programming, Python

IT Nursery

Python Pandas – Find difference between two data frames

I have two data frames df1 and df2, where df2 is a subset of df1. How do I get a new data frame ...

May 30, 2022
0 Comments

Programming, Python

IT Nursery

Find the unique values in a column and then sort them

I have a pandas dataframe. I want to print the unique values of one of its columns in ascending order. This is how ...

May 30, 2022
0 Comments

Programming, Python

IT Nursery

Can pandas automatically read dates from a CSV file?

Today I was positively surprised by the fact that while reading data from a data file (for example) pandas is able to recognize ...

May 30, 2022
0 Comments

Programming, Python

IT Nursery

Find column whose name contains a specific string

I have a dataframe with column names, and I want to find the one that contains a certain string, but does not exactly ...

May 29, 2022
0 Comments

Programming, Python

IT Nursery

Turn Pandas Multi-Index into column

I have a dataframe with 2 index levels: value Trial measurement 1 0 13 1 3 2 4 2 0 NaN 1 12 ...

May 28, 2022
0 Comments

Programming, Python

IT Nursery

Multiple aggregations of the same column using pandas GroupBy.agg()

Is there a pandas built-in way to apply two different aggregating functions f1, f2 to the same column df...

May 28, 2022
0 Comments

Programming, Python

IT Nursery

python dataframe pandas drop column using int

I understand that to drop a column you use df.drop(‘column name’, axis=1). Is there a way to drop a column using a numerical ...

May 28, 2022
0 Comments