Advertisements Lets say I have three variables: var1<-c(101,102,103,104) var2<-c("AB","XY") var3<-c(1,2) X<-expand.grid(var1,var2,var3) X Above code gives this output Var1 Var2 Var3 1 101 AB 1 2 102 AB 1 3 103 AB 1 4 104 AB 1 5 101 XY 1 6 102 XY 1 7 103 XY 1 8 104 XY 1 9 101 AB… Read More Create a dataframe by fixing rows in one column and repeating other columns
Advertisements I have a data frame with more than thousand rows like this. org year country a 2010 US a 2012 UK b 2014 Mexico b 2014 CHile b 2015 Brazil And I would like to make my data like this. I want my data to be repeated after appearing. org year country a 2010… Read More Repeat data by group per year
Advertisements I wish to expand a table that contains data from an invoked column pulling data from the web. The issue is that not every row finds a desired result on the web and returns an error. Although I don’t mind the result failing for this row it causes an issue when trying to expand… Read More Handling errors when expanding table in power query
Advertisements I want to create a new dataframe with columns calculated as means of columns with similar names from this dataframe: B6_i B6_ii B6_iii … BXD80_i BXD80_ii BXD81_i data … Cd38 0.598864 -0.225322 0.306926 … -0.312190 0.281429 0.424752 Trim21 1.947399 2.920681 2.805861 … 1.469634 2.103585 0.827487 Kpnb1 -0.458240 -0.417507 -0.441522 … -0.314313 -0.153509 -0.095863 Six1… Read More How to groupby multiple columns in pandas based on name?
Advertisements I am combining several spreadsheets with identical layouts into one master, and want to create a way to have my query({importrange}) be dynamic, as I will be adding / removing some sheets as time goes on. I have all of my sheet addresses in column C, so my formula right now looks like: =QUERY({Importrange(C4,Sheet1!C5:F);Importrange(C5,Sheet1!C5:F);…}… Read More Expandable Importrange
Advertisements What I want here is for the Nans to ultimately be integer values. Since my dataset is 1000s of columns, I can’t just change a couple of columns to make them integer and when I tried df = df.astype(‘int’) in Dask, after changing the values to 0 floats, for whatever reason, it didn’t work.… Read More Filling NAs to string 0 and then to int reverts to float
Advertisements Writing a function to calculate date based on relativedelta. How do I make the ‘frequency’ a variable? e,g, relativedelta(years=5), ability to define frequency: "years", "months", "days" etc.. Tried f-string literal but i think the apostrophe is giving issues. def date_ago(date, period, frequency): """date: "yyyy-mm-dd" frequency: "years", "months", "weeks", "days" period: interger """ date_ago =… Read More Variables within a function
Advertisements I have a field with random spaces ID field1 1 C 2205 123 ABC 2 B 111 345 DDD I would like to split field1 into multiple columns. there are double spaces or single spaces. I tried below line and it gives me the array. new=df["field1"].str.split(‘:’) print(new): [C, 2205, 123, ABC] [B, 111, 345,… Read More split the text with random spaces
Advertisements I had another request which complicated my life even more. I’d like to load more datas in to my html when I click my button ´See more´. Ideally I should have only 4 items displayed by default. And each load should add 2 more. Now, what’s the best approach? I’d like a hint if… Read More Load more data from json on click
Advertisements I’m trying to insert 2 buttons inside 2 divs. All divs in my css have a display grid as assigned. My question is why do the divs with class button-left and button-right expand to take all the space available, even if I did not tell them to have a width of 100% or width… Read More Why my div in display grid expand to cover all is available are?