I have a dataframe with multiple columns. For each row in the dataframe, I want to call a function on the row, and the input of the function is using multiple columns from that row. For example, let’s say I have this data and this testFunc which accepts two args: > df <- data.frame(x=c(1,2), y=c(3,4), … Read more
I want to read a .xlsx file using the Pandas Library of python and port the data to a postgreSQL table. All I could do up until now is: import pandas as pd data = pd.ExcelFile(“*File Name*”) Now I know that the step got executed successfully, but I want to know how i can parse … Read more
df <- data.frame(var1 = c(‘a’, ‘b’, ‘c’), var2 = c(‘d’, ‘e’, ‘f’), freq = 1:3) What is the simplest way to expand each row the first two columns of the data.frame above, so that each row is repeated the number of times specified in the column ‘freq’? In other words, go from this: df var1 … Read more
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 row a1 has that a2 doesn’t. Is there a built in function for this type of operation? (p.s: I did write a solution for it, I am simply curious if someone already … Read more
I am trying to access the index of a row in a function applied across an entire DataFrame in Pandas. I have something like this: df = pandas.DataFrame([[1,2,3],[4,5,6]], columns=[‘a’,’b’,’c’]) >>> df a b c 0 1 2 3 1 4 5 6 and I’ll define a function that access elements with a given row def … Read more
I have a data.frame in R. I want to try two different conditions on two different columns, but I want these conditions to be inclusive. Therefore, I would like to use “OR” to combine the conditions. I have used the following syntax before with lot of success when I wanted to use the “AND” condition. … Read more
I am kind of getting stuck on extracting value of one variable conditioning on another variable. For example, the following dataframe: A B p1 1 p1 2 p3 3 p2 4 How can I get the value of A when B=3? Every time when I extracted the value of A, I got an object, not … Read more
How can I print a pandas dataframe as a nice text-based table, like the following? +————+———+————-+ | column_one | col_two | column_3 | +————+———+————-+ | 0 | 0.0001 | ABCD | | 1 | 1e-005 | ABCD | | 2 | 1e-006 | long string | | 3 | 1e-007 | ABCD | +————+———+————-+ 9 … Read more
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 = pd.DataFrame({‘A’: [‘foo’, ‘bar’] * 3, ‘B’: rand.randn(6), ‘C’: rand.randint(0, 20, 6)}) gb = df.groupby([‘A’]) I can iterate through it to get the keys and groups: In [11]: for k, gp in … Read more
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 [1, 2] 1 2 [1, 2] My expected output is: A B 0 1 1 1 1 2 3 2 1 4 2 2 What should I do to achieve this? Related … Read more