For each row in an R dataframe
I have a dataframe, and for each row in that dataframe I have to do some complicated lookups and append some data to … Read more
dataframe
Order data frame rows according to vector with specific order
Is there an easier way to ensure that a data frame’s rows are ordered according to a “target” vector as the one I … Read more
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 … Read more
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’: [5, … Read more
How to convert a table to a data frame
I have a table in R that has str() of this: table [1:3, 1:4] 0.166 0.319 0.457 0.261 0.248 … – attr(*, “dimnames”)=List … Read more
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 … Read more
Convert row names into first column
I have a data frame like this: df VALUE ABS_CALL DETECTION P-VALUE 1007_s_at “957.729231881542” “P” “0.00486279317241156” 1053_at “320.632701283368” “P” “0.0313356324173416” 117_at “429.842323161046” “P” … Read more
add a string prefix to each value in a string column using Pandas
I would like to append a string to the start of each value in a said column of a pandas dataframe (elegantly). I … Read more
How to test if a string contains one of the substrings in a list, in pandas?
Is there any function that would be the equivalent of a combination of df.isin() and df[col].str.contains()? For example, say I have the series … Read more
Convert data.frame column to a vector?
I have a dataframe such as: a1 = c(1, 2, 3, 4, 5) a2 = c(6, 7, 8, 9, 10) a3 = c(11, … Read more