Stack Overflow
Stack Overflow

Questions tagged [rows]

A row is a single data item in a database, spreadsheet, table, grid or list. When using this tag, please also add additional tags to clarify your specific environment/language/use case.

A row is a single data item. In the context of a database or similar data structure, it's also known as a or and will have a well-defined structure. In the context of a dataset in data science, each row represents an observation.

Rows can also be added to a less structured data source, such as a , , grid or .

4419 questions
1
vote
2 answers

SQL Getting multiple rows from a single row

I need to accomplish the following : I have a table with multiple column (c1, c2, c3, c4 ... cn). I want a query that would return multiple rows in the following fashion (r1 r2 .. rx are the rows in the original table) : r1c1 r1c2 r1c3 r1c4 r1c5…
user2967384
  • 21
  • 3
1
vote
1 answer

Delete pandas DataFrame rows with content from array

I have a big DataFrame (~1 Milion lines) and i need to delete some rows based on the unique identifier Trade_Id. I have the content of this rows (45000 on my test database) on another DataFrame variable called tib. My approach is this…
VCLL
  • 158
  • 1
  • 7
1
vote
2 answers

Removing duplicate rows from relation

I have the following code which produces a relation: SELECT book_id, shipments.customer_id FROM shipments LEFT JOIN editions ON (shipments.isbn = editions.isbn) LEFT JOIN customers ON (shipments.customer_id = customers.customer_id) In this…
Sahand
  • 7,980
  • 23
  • 69
  • 137
1
vote
4 answers

Update only checked rows php mysql

I am trying to update only checked rows in the table but nothing is happening Here is my code
Bilal Zia
  • 41
  • 1
  • 8
1
vote
1 answer

Search first row for certain text, then copy entire column

I'm fairly new to VBA and I'm having a lot of trouble doing a seemingly easy task. I've tried many different codes using this website and this is the one that gets me closest to what I want but it doesn't return any values. Here is the premise of…
MayankB
  • 15
  • 1
  • 8
1
vote
2 answers

MS Access converting row information to column

I've spent hours trying to figure this one out. This is for a manufacturing plant. A person on the plant floor logs their activities on different machines using a computer system which produces data like this: Empnbr Datestamp Shift Machnbr…
Ryan
  • 11
  • 2
1
vote
2 answers

Insert rows on a existing dataset

I have a dataset called "titulos" and have 1 table there called "tb" with the columns with the name "titulo","titulo 2" and "titulo3". I'm trying to do an insertion of rows in the event onclick of a button but for some reason my code doesn't…
João Medeiros
  • 11
  • 2
1
vote
2 answers

NSInternalInconsistencyException: Invalid Update using tableview CoreData

I am using a tableView to display a list of people. I am trying to add an alert to confirm that the user actually wants to delete the person and to prevent mistakes. However, when I try to delete the person that is stored with CoreData, there seems…
themaxgoldman
  • 123
  • 9
1
vote
1 answer

How to multiply two columns in a table together to produce a new column

I have 2 fields quantity and price. I basically want to multiply them together and get a value for another column called Price (Which is the total of the multiplication). I have tried using the below html code: @Html.DisplayFor(modelItem =>…
Michael Fung
  • 129
  • 13
1
vote
1 answer

JQuery search bar to hide table rows

Hopefully someone will be able to help me with this. I have a dynamically created table full of info, and I am trying to use JQuery to only show rows that are matching what is being typed in the search bar. The match is of the first td within each…
Anon
  • 13
  • 3
1
vote
2 answers

Delete rows based on multiple conditions; including other column conditionals

I am seeking to drop some rows from a DataFrame based on two conditions needing to be met in the same row. So I have 5 columns, in which; if two columns have equal values (code1 and code2) AND one other column (count) is greater than 1, then when…
StringTheo
  • 23
  • 1
  • 5
1
vote
1 answer

Plot values in specific column range for a particular row in a pandas data frame

I have a 10 rows x 26 columns data set of a country region's oil production between 1990-2011. The first column designates the country region (e.g. Canada), the next 22 columns correspond to oil production between 1990 and 2010, and the last two…
Feynman27
  • 3,049
  • 6
  • 30
  • 39
1
vote
3 answers

PHP: Include an array inside another array that gets DB rows

The while loop gets DB rows as such: while($row = $result->fetch_assoc()){ $metadata_field74[] = $row['field74']; $metadata_field75[] = $row['field75']; $metadata_field76[] = $row['field76']; $metadata_field77[] =…
user3914680
  • 23
  • 3
1
vote
3 answers

Allowing different widths of columns in rows

I am trying to get the table columns to have different widths on each row. I'm using an array to get the values which I am turning into width percentages and passing it into the column. The output seems to copy the row above even though it has…
Daniel Stott
  • 39
  • 6
1
vote
3 answers

Sum Every N Values in Matrix

So I have taken a look at this question posted before which was used for summing every 2 values in each row in a matrix. Here is the link: sum specific columns among rows. I also took a look at another question here: R Sum every k columns in matrix…
Adam Warner
  • 1,334
  • 2
  • 14
  • 30
1 2 3
…
99
100