12,181 questions
0
votes
0
answers
40
views
How to merge rows with the same ID into one row by taking non-null values
I am working with a table in DolphinDB where multiple rows share the same id, and each row contains non-null values in different columns. My goal is to consolidate these rows into a single row for ...
0
votes
1
answer
74
views
Pivot Table shows all rows regardless of value field selected
I am creating a schedule and capacity planner for the team I manage. On the data table along the top, I have a column for the task and who its assigned to, and then I have each day/date (Mon-Fri), for ...
- 1
0
votes
0
answers
44
views
Would it be a good practice to make Talkback read all the items in a lazy row automatically?
Is it a good practice to make Talkback read all the items in a lazy row automatically?
For example, user focuses in the first item of the lazy row, talkback reads the whole item, and the move on to ...
0
votes
1
answer
68
views
Spacing property still enacts on empty children
looking for a solution to a render pattern I am finding myself in.
We tend to prefer spacing items with rows or columns using the spacing property instead of wrapping the child elements in their own ...
- 23
1
vote
2
answers
91
views
User Input VBA Autofill using more than one input
I need help for the following problem.
I want to create a macro that as for how many rows are to be added depending on user input. In addition, each newly row will accept a different numerical value ...
- 11
1
vote
2
answers
203
views
Automatically move row to top when cell text changed
Is there a way to move a row to the top of the spreadsheet every time one of the cells in the row that was labeled open is changed to closed?
I want this action every time not just once. I get them ...
0
votes
0
answers
25
views
Creating a Dynamic Table in android using TableLayout while setting the column view attributes in layout file
I am trying to create a dynamic table in android and was analyzing to see if I can use the TableLayout, though I see various options of how to add rows dynamically but all the examples requires me to ...
-1
votes
1
answer
58
views
How to copy the visible row instead of all row til the last row?
In my excel, there is a filter at E6 always, so the next visible row could be E170 or E600 or others, and i just wanna copy the visible rows under E6 instead of copying all rows before the last row. ...
- 11
1
vote
2
answers
98
views
Query to automatically update values based on other certain criteria [closed]
I've got a SQL query that is trying to update threshold information on a SolarWinds database.
The main data is within the Nodes view and the Thresholds table contains the warning and critical ...
0
votes
0
answers
52
views
AgselectedRowCountComponent in ag-grid status panel shows all rows instead of filtered selected rows
I am using AgselectedRowCountComponent in the status panel of an ag-grid table to display the count of selected rows. However, when i filter the data and use the "Select all" functionality, ...
- 1
-2
votes
3
answers
117
views
Ignore more than one row for a pattern in bash
While listing some logs, I get the following pattern:
id:Batch1
1:processed
id:Batch2
1:processing and some info
I get multiple rows like this and they are not sorted in any way. There is no pattern ...
- 1
11
votes
5
answers
799
views
In R, how can I collapse the data of grouped rows into one row?
I have the following sample dataframe:
df <- data.frame(
record_id = c(1, 1, 1, 2, 2, 3, 3, 3),
instance = c(NA, NA, 2, NA, 1, 2, NA, NA),
A = c(10, NA, NA, 20, 25, NA, 30, NA),
B = ...
- 878
1
vote
3
answers
88
views
How to get difference value (delta) between to rows after query in Mariadb
Helo,
this is my query:
MariaDB [PV_Anlage]>
SELECT created_at, verbrauch_ges
FROM pv_metrics
group by DATE(created_at)
ORDER BY ID DESC limit 20;
+---------------------+---------------+
| ...
- 23
0
votes
1
answer
48
views
Remove rows based on duplicated values in one column [duplicate]
I have the below sample table and I need a second table without duplicate grouped values from column 'Values'
+----+--------+
| Id | Values |
+----+--------+
| 1 | A |
| 2 | B |
| 3 | B ...
- 111
0
votes
1
answer
98
views
Can anyone see what is wrong with my transpose function in F#?
Given a list of tuples, where each tuple consists of 3 integers, transpose the list recursively so that the "rows" and "columns" are swapped. The result will be a list of lists.
So ...
6
votes
2
answers
225
views
Comparing the values of a certain number previous rows with the current row [closed]
In a database containing firm and patent class values, I want to calculate the following variables:
Technological abandonment: Number of previously active technological patent classes abandoned ...
- 583
5
votes
5
answers
128
views
Matching pair-wise columns from left to right across rows in one dataframe to another dataframe and adding new columns with matching values
I've got a dataset like this:
df1 <- data.frame(
col1 = c(1, 2, 3),
col2 = c(4, 5, 6),
col3 = c(2, 8, 9),
col4 = c(5, 11, 12),
col5 = c(13, 14, 15),
col6 = c(16, 17, 18),
...
- 321
0
votes
0
answers
30
views
Child inside Row not in the center of the w
I just want to create a row with 5 buttons. The problem is that the Child of the button is not centered in the widget as shown in photo: https://i.sstatic.net/lQE48lq9.png
Code is the following:
Row(
...
- 83
0
votes
1
answer
65
views
Cell conditioning based on cell value on a row to cell value on column
Above is the cell values I want to apply the condition too.
A solution that works is to create a new column using the transpose function for the row in Question is to use the cell = cell.
I dont want ...
0
votes
2
answers
123
views
Excel. How to get an one row data (multiple columns) from every three rows
Please need your help.
I have an excel file with this following structure, that one row is divided into the next two rows:
initial
And need finally get this one. Every third row need to be combined ...
0
votes
4
answers
179
views
How to insert a new row for each missing number of one variable while filling with NA for other variables using data.table in R?
How to insert a new row every time there is a break in the y column numbering, while filling the other columns with NA?
Edit: Iroha's suggestion based on tidyr::complete() works fine, as do the others....
- 972
0
votes
0
answers
54
views
Is there a formula to get row and column of range end in openoffice calc?
I am using OpenOffice Calc. I have a text which is address range, indirectly used for my calculations. My text is "C5:K5". It may vary at times.
I use ROW("C5:K5") and COLUMN("...
0
votes
0
answers
28
views
Tabulator: rowClick event not fired for list elements
I use rowClick event in Tabulator (6.3) to perform an row update into a database. The event is fired perfectly for standard elements, but not for list elements:
table.on("rowClick", function(...
- 1
0
votes
1
answer
26
views
Excluding rows in excel based on certain text
I have been trying to write a macro to exclude rows containing \ in column V. The data I will be working with will have a variable number of rows so I cant specify the last row. I have found various ...
2
votes
3
answers
118
views
Perform a random binomial draw for each row in R without rowwise()
I have an R data frame that I need to perform a random binomial draw for each row. The n = argument in the random binomial draw will be based on a value in a column of that row. Further, this ...
- 230
0
votes
0
answers
29
views
I am trying to add variables into a new DB row using Python. The code I have written gets no error but doesn't write the new row. into the table? [duplicate]
Connection to database
import datetime
import pymysql
conn = pymysql.connect(
host='localhost',
user='XXXX',
#password=,
db='golf_db',
charset='utf8mb4',
cursorclass=pymysql.cursors....
0
votes
1
answer
135
views
Changing a dataframe headers, but keeping the previous headers as a row
I have two issues on a dataframe:
It does not have the correct headers
The current headers contain values that should be a "simple" (first) row of the dataframe
How do I keep my current ...
- 61
0
votes
0
answers
12
views
How I can split a cell which contains a text to different rows whithout loosing whole sheet format?
enter image description here image from a part of my spread sheet.
how can I divide rows number 35-37 to a single row like 34. In the image for example names and numbers are in wrapped text format but ...
0
votes
2
answers
104
views
Calculating a value by summing several rows
Table contains data about hotel rooms.
We can see the same Room available for different date periods - at different Prices. AccmdMenTypeCode - is the Code that shows how many people can stay in this ...
- 13
1
vote
1
answer
104
views
copy a row then paste it to another row in Grid using extJS
I display a grid, there are two rows in the grid. I have a button called "Copy", when user click on the Copy button, all the data from first row will copied, then paste it into second row.
...
- 33
1
vote
0
answers
28
views
How can I get rid of diagonal tilting of shifting plt.pcolormesh() when shifting row positions?
I am plotting a 2D heat map as part of my research in python using plt.colormesh() and I am able to get nice plots this way:
raw data plot
I want to get rid of the bowing (artifact of experimental set ...
- 11
0
votes
1
answer
72
views
HTML and CSS: a row inside a div won't let me place items all next to each other and won't scroll
This code isn't mine, it's a free to use one I found on toyhouse, and I wanted to make some edits to fit my preferences. This is what I have:
At the bottom there's a horizontal scroll bar (it's grey, ...
- 67
2
votes
3
answers
83
views
Add alternating background to each row in display grid with grid of posts
I have a full width div which contains a dynamic grid of posts. The number of columns depends on the screen width, the number of rows depends on the number of posts.
I would like to have an ...
- 41
0
votes
1
answer
76
views
Excel VBA to hide rows if more than 10 blanks
Good evening,
I have data in non-continuous cells in Range A49:A103. I want to count the blank cells in this range (this part is easy as there are lots of examples on the internet on how to do this.) ...
1
vote
3
answers
54
views
Count occurences (rows) between dates (SPSS)
I have data on surgeries, every row represent a patient with a performed surgery. I wish to answer the question: How many procedures has this surgeon performed in the last year (at that time of the ...
1
vote
1
answer
94
views
Python: Discord Button Rows with different amount of buttons
So I am currently trying to make an archive bot where you can select characters and get all the information about them. I used buttons for each character.
Now I would want to sort the button rows so ...
- 11
0
votes
1
answer
46
views
highlight rows for different values in excel
I have
I want to highlight each row that has a different value to the one above it in a different colour. Makes it easier to view all the category 3, for example, especially when I have lots of ...
- 3,816
2
votes
1
answer
47
views
python dataframe slicing by row number
all Python experts,
I'm a Python newbie, stuck with a problem which may look very simple to you. Say I have a data frame of 100 rows, how can I split it into 5 sub-frames, each of which contains the ...
- 85
0
votes
1
answer
55
views
Extract row one by one from excel table, and save each extracted row individually as new excel file using loop
I have one header excel file (header.xlsx) with only one row, and one excel table file (station.xlsx) with multiple rows.
The aim is to extract first row from (station.xlsx), and then append the ...
0
votes
1
answer
61
views
Drop down List to hide rows from one sheet to others
I want to have a drop down list with the name for example calculations, other and with choosing one I can have certain rows hidden on another sheet.
Is there an easy way to do that?
I tried some codes ...
-2
votes
1
answer
97
views
have a code for copying rows from a sheet to another in google sheet but it do all of the rows not working for selected or filtered
I have a code for copying rows from a sheet (Parks) to another (Report) in google sheet. It works fine but the problem is, I have 335 rows in sheet 'Parks' and I don't want all of these rows in my ...
- 1
0
votes
0
answers
25
views
Unable to get all rows from csv based on some column value [duplicate]
I am confused about how to get all the matching some value, I went through to all the related post on such topic on stackoverflow, what I have right now should be working, I am unsure either this csv ...
- 31
0
votes
1
answer
60
views
How to insert multiple selects into separate rows [duplicate]
Having read several posts on this subject, I have managed to insert data from a multiple select form.
However, the data goes into one row. I need each value to go into separate rows.
Here is the ...
- 63
0
votes
1
answer
38
views
Flex direction row not working in React Native
I don't know what is wrong with my code, but always shows the < Text > under the < TouchableOpacity >. I tried to change everything in the code without results, nor about others similar ...
- 19
1
vote
2
answers
59
views
How can I make a Row with a Textfield and two stacked radio buttons in Flutter?
I have a TextField to enter the year and two RadioListTiles for AD or BC. I would like to have a Row with the TextField first, and then the RadioListTiles stacked after that and in a smaller font ...
- 504
1
vote
2
answers
83
views
group by, order and detect change between rows
I have a dataframe. I would like group by col1, order by col3 and detect changes from row to row in col2.
Here is my example:
import pandas as pd
import datetime
my_df = pd.DataFrame({'col1': ['a', '...
- 7,824
2
votes
2
answers
71
views
How can I edit the following Copysheets macro to NOT copy hidden columns/rows?
I have a macro that we use for copying a worksheet into a new workbook. The only issue I am having is that when it copies the worksheet into a new workbook, it copies the hidden columns/rows. What ...
- 47
0
votes
0
answers
834
views
What's the right way to cast ARRAY<ROW(...)> to JSON in Trino
I tried
select
json_format(cast(COALESCE(array_of_row, array[]) as JSON))
from my table
and it appears to work, but the trino documentation says that both JSON type and json_format are considered ...
- 9,140
0
votes
1
answer
110
views
Index Match Search Field with multiple rows in google sheets
I have a table of data where in column 1 I have connected rows 1-5 and in column 2 I have five different values belonging to the value in column 1.
Now I want to make a search function, where you can ...
- 3
0
votes
2
answers
43
views
How to display 2 text in row, text1 can be ellipsis but text2 should be display full length in flutter
Row[Image, Text1, Text2, Image]
Here Text1 is name, Text2 is ID and Image is fixed size25 and need to display at the end of the row.
- 461