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 US… Read More Repeat data by group per year
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 the… Read More Handling errors when expanding table in power query
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 1.055255… Read More How to groupby multiple columns in pandas based on name?
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);…} This… Read More Expandable Importrange
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
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 = datetime.strptime(date,… Read More Variables within a function
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, DDD]… Read More split the text with random spaces
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 possible… Read More Load more data from json on click
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 of… Read More Why my div in display grid expand to cover all is available are?
I’m trying out BottomSheetScaffold and I just found a strange behavior (maybe a bug) when using it. I put it inside a Box { } that has a cyan background color: composable(route = "my_route") { Box( modifier = Modifier .fillMaxSize() .background(color = Color.Cyan), ) { val coroutineScope = rememberCoroutineScope() val bottomSheetScaffoldState = rememberBottomSheetScaffoldState() BottomSheetScaffold( scaffoldState… Read More BottomSheetScaffold is overriding the background color of its parent