365体育足球滚球比分

Questions tagged [row]

A horizontal line of cells in a spreadsheet, SQL table, HTML table, or similar structure.

Filter by
Sorted by
Tagged with
0
votes
1answer
18 views

How to merge two consequitve rows in a DataFrame using only specific data from second row?

My DataFrame contains pairs of rows that depict the start and stop of a machine downtime. The first row of the pair always show when the downtime started, the second one when it ended. I would now ...
0
votes
0answers
5 views

bootstrap 4 - placing one table under another and centering

I want to have my tables centered horizontally and I expect them to be displayed one under another. Using some bootstrap 4 classes I've managed to have the tables displayed very unevenly or to have ...
0
votes
0answers
11 views

InsertRowBefore() + Defined Range question

I have a bit of code that inserts a blank row to the top of a sheet and copies data into it. I also have a defined range on that sheet. Every time a row is inserted, the defined range moves down a ...
0
votes
0answers
6 views

Python: Creation of dataframe with downshifted values from one series

I have this given series: 0 11 1 12 2 13 3 14 4 15 And want to turn in a dataframe in this form: 0 1 2 3 4 0 11 NaN NaN NaN NaN 1 12 11 NaN ...
0
votes
1answer
46 views

Average by row and column

I have a large matrix, for each cell I want to calculate the average of the numbers falling in the column and row of that specific cell. As the matrix contains NA values and I'm not interested in ...
1
vote
1answer
31 views

How can I troubleshoot the delete row function

I am attempting to delete a row like this: data <- data[-1645,] However, after running the code, the row is still there. I can tell because there is an outlier in that row that is showing up on ...
1
vote
1answer
19 views

Google Sheets - Change row color once multiple boxes are checked

In Google Sheets, I would like each row to turn green, once two of the checkboxes (in Columns F and G) are checked for that row. I have tried using conditional formatting with the following formulas ...
0
votes
1answer
14 views

How to give numbers to row that reset every time the value of another column changes?

this is probably a simple question, but I want to create row numbers based on the values in the column. It would look like this: 1 | AAA 2 | AAA 3 | AAA 1 | BBB 2 | BBB 1 | CCC 2 | CCC 3 | CCC 4 | ...
1
vote
0answers
12 views

Script for Google Docs - automatic calendar - current week and 3 more

I need your help on a script, please. I have a calendar in a Google spreadsheet. I only want to show the current week and 3 more. So the calendar should "scroll" automatically. I've already tried ...
4
votes
3answers
37 views

Extract rows when value change in column with dplyr r

I'm trying to extract the rows each time there is a change in b : a b 1 1 A 2 4 A 3 5 A 4 3 B 5 3 B 6 2 B 7 4 B 8 6 A 9 2 A 10 4 C 11 1 C So the result i'm expecting would be : a b 1 ...
0
votes
1answer
25 views

Why is there extra space at the end of my rows?

I have created a widget to dispay a league table but get som extra space at the end of each row. The table is just a Column widget with a list of Row widgets. Each row contains a list of Containers ...
0
votes
1answer
28 views

Select a row after GroupBy based on a conditional

I have a first dataframe: df1 = pd.DataFrame({'subject':[2,2,2,2,2,2,2,2,3,3,3,3,3,3,3,3], 'trial' :[2,12,13,14,15,16,17,18,3,4,5,9,10,11,12,15], ...
0
votes
2answers
38 views

Octave Code for Minimum and Max and finding index

Hello everyone, I've been trying to code this program to find the max and min values in a row vector and I had a problem with assigning their dimension indexes I can't figure out what's wrong C and D ...
0
votes
1answer
44 views

JTable id resetting after dynamic search

I have a jtable that comes from MySQL database in my app like in this image; When i pick a row, i show its id number on left bottom as it seems in above image. Then i will send that id to somewhere ...
0
votes
1answer
26 views

How do I delete ROWS based on some calculations on column value in EXCEL

Please help me in below scenario, I have some data in excel and I want to delete rows based on ID and higher Timestamp( I want to keep only latest records for each ID). For each ID I want to keep ...

15 30 50 per page
1
2 3 4 5
408