dataframe Archives - IT Nursery

Call apply-like function on each row of dataframe with multiple arguments from each row

I have a dataframe with multiple columns. For each row in the dataframe, I want to call a function on the row, and … Read more

How to read a .xlsx file using the pandas Library in iPython?

by IT Nursery

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

Repeat each row of data.frame the number of times specified in a column

by IT Nursery

df <- data.frame(var1 = c(‘a’, ‘b’, ‘c’), var2 = c(‘d’, ‘e’, ‘f’), freq = 1:3) What is the simplest way to expand each … Read more

Compare two data.frames to find the rows in data.frame 1 that are not present in data.frame 2

by IT Nursery

I have the following 2 data.frames: a1 <- data.frame(a = 1:5, b=letters[1:5]) a2 <- data.frame(a = 1:3, b=letters[1:3]) I want to find the … Read more

getting the index of a row in a pandas apply function

by IT Nursery

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

How to combine multiple conditions to subset a data-frame using “OR”?

by IT Nursery

I have a data.frame in R. I want to try two different conditions on two different columns, but I want these conditions to … Read more

extract column value based on another column pandas dataframe

by IT Nursery

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

Pretty Printing a pandas dataframe

by IT Nursery

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

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

by IT Nursery

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[458]: A B 0 1 … Read more