7,818 questions
0
votes
3
answers
97
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 ...
- 9
11
votes
5
answers
737
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 = ...
- 868
1
vote
3
answers
48
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
34
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
65
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
209
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
109
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
24
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
54
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
67
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
161
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....
- 844
0
votes
0
answers
29
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
14
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
19
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
85
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