Stack Overflow
Stack Overflow

Questions tagged [row]

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

A row most commonly refers to a horizontal line of cells in a spreadsheet or similar structure.

7733 questions
1
vote
3 answers

Pandas merging rows on two unique column values

I have problem that I have been trying to find a solution for. You would think that it wouldn't be that hard to figure out. I have a pandas DataFrame with the below format: Id Name Now Then There Sold Needed 0 1 …
Thomas Paine
  • 291
  • 1
  • 14
1
vote
2 answers

Get first value from consecutive rows PySpark

I am using PySpark and I want to get the first status order by Date but only if there consecutive status, because the status can be more than once, but not more than one in a row. Here is my example of what i…
Alex Hernan
  • 19
  • 5
1
vote
2 answers

Compare two dataframes and retrieve common row elements

I need to compare two datasets: DF1 Subj 1 2 3 0 Biotech Cell culture Bioinfo Immunology 1 Zoology Cell culture Immunology NaN 2 Math Trigonometry Algebra NaN 3 …
Mimikyu o_0
  • 57
  • 4
1
vote
1 answer

Only keep certain rows in group from specific value to max in that group

I have a large df with keys that occur multiple times and values. Here is an example: index key value 0 1 346 1 1 349 2 1 351 3 1 353 4 1 355 5 2 359 6 2 359 7 2 360 8 2 365 9 2 …
Hyphens
  • 11
  • 2
1
vote
2 answers

Remove rows where groups of two columns have differences

Is it possible to remove rows if the values in the Block column occurs at least twice which has different values in the ID column? My data looks like this: ID Block 1 A 1 C 1 C 3 A 3 B In the above case, the value A in the Block…
john
  • 13
  • 3
1
vote
1 answer

How to iterate a RDD and remove the field if it exist in a list using PySpark

I have a list which contains a couple of string values/field names. I also have a Spark RDD, I'd like to iterate the rdd and remove any field name that exists in the list. For example: field_list = ["name_1", "name_2"] RDD looks like…
wawawa
  • 2,835
  • 6
  • 44
  • 105
1
vote
0 answers

Making index i to row and index j to column and index k = 0 or k = 1 depending on following

I have a 3D matrix as following: a = [[[0, 1, 2, 3, 4, 5], [1, 2, 3, 4, 5, 6], [2, 3, 2, 3, 4, 5], [3, 2, 3, 4, 3, 4], [4, 3, 4, 5, 4, 3], [5, 4, 5, 6, 5, 4]]] When I loop over the matrix I want the first index i to represent the row of a, the…
TheRi
  • 67
  • 5
1
vote
2 answers

Adding new row to dataframe with values taken from other rows to replace NAs in R

I have a dataframe much like this one ID Col2 Col3 Col4 Col5 ID_1 JDH 43 FJS f8j ID_8 ABC 73 *NA* *NA* ID_7 AFE 03 *NA* k32 ID_8 *NA* *NA* FDS z7d where I have some rows with the same name/ID (ID_8 in this…
Soph2010
  • 563
  • 3
  • 13
1
vote
1 answer

VBA (Excel) - Select rows in a particular group (outline)

I have a regular report delivered to me that contains grouped rows looking something like the below. Grouped Rows I would like to select/reference all of the rows within the group named 'Unassigned' (ie 'E', 'F', 'G') using VBA, so I can use the…
Dratsy
  • 11
  • 1
1
vote
0 answers

How can I make a dynamic table without DataTable, but with the Table widget in FLUTTER?

I want to make a table with moving rows and columns inside, it also should be able to add a row or column with a button and delete it likewise. Internet only suggests Datatable or DataGrid, but I need to use the Table Widget in Flutter and Row and…
Maria Grigoryan
  • 63
  • 6
1
vote
2 answers

First row in unsorted range VBA

I ask the user to select cells with an InputBox. I would then like to find the cell with the lowest row number in that range. Is there some function that does it or do I have to iterate through all cells? If the user selects from top to bottom there…
Paul
  • 19
  • 1
1
vote
1 answer

How do I find the max value in only specific columns in a row?

If this was my dataframe a b c 12 5 0.1 9 7 8 1.1 2 12.9 I can use the following code to get the max values in each row... (12) (9) (12.9) df = df.max(axis=1) But I don't know would you get the max values only comparing columns a &…
Jody
  • 115
  • 5
1
vote
2 answers

Select rows with some records having duplicated value in one column

I would like to retrieve all rows from a table where there are some records with a duplicated column, but i have to select only one row for those cases. Example: ------------------------------------------- | id | text |…
xaenea
  • 13
  • 3
1
vote
1 answer

Intrinsic Height Issue in row

I want to have three children in a row. First child on the top. Second child will have dynamic height according to the data in a column Third child needs to be in center of regarding the height of the second child. I was using Intrinsic height to…
Anees
  • 99
  • 7
1
vote
1 answer

Randomly selecting 4 unique rows of a data frame in r

I am working with R, and my data looks similar to this... group col_2 col_3 col_4 A p_m 12 21 A q_x 11 21 A i_z 13 22 B q_z 11 24 B p_x 14 25 B i_m 15 26 B …
Ajrhjnd
  • 330
  • 1
  • 9
1 2 3
…
99
100