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
10
votes
3 answers

Matlab - insert/append rows into matrix iteratively

How in matlab I can interactively append matrix with rows? For example lets say I have empty matrix: m = []; and when I run the for loop, I get rows that I need to insert into matrix. For example: for i=1:5 row = v - x; % for example getting 1 2…
Andrius
  • 19,658
  • 37
  • 143
  • 243
10
votes
3 answers

Spring Batch - Counting Processed Rows

So I am creating a Spring Batch job for reading a CSV file and for certain rows which contain incomplete data; it checks, outputs to the log that the row is incomplete, and skips. It works great except at the end of the job I want it to log how many…
dogfight
  • 193
  • 1
  • 1
  • 7
10
votes
1 answer

Twitter bootstrap row with spans wraps

Using twitter bootstrap, I'm trying to figure out why the last "column" wraps.
user1916419
  • 101
  • 1
  • 5
9
votes
2 answers

Update multiple rows with different values in a single query - MySQL

I'm new to MySQL. I'm using this to update multiple rows with different values, in a single query: UPDATE categories SET order = CASE id WHEN 1 THEN 3 WHEN 2 THEN 4 WHEN 3 THEN 5 END, title = CASE id WHEN…
Hakan
  • 3,835
  • 14
  • 45
  • 66
9
votes
6 answers

Insert into a row at specific position into SQL server table with PK

I want to insert a row into a SQL server table at a specific position. For example my table has 100 rows and I want to insert a new row at position 9. But the ID column which is PK for the table already has a row with ID 9. How can I insert a row at…
user648610
  • 121
  • 1
  • 5
  • 8
9
votes
1 answer

Find row number from a row name in R

How can I find the row number of a particular row name in R? I have found functions which allow you to find a row number for a particular matrix value, but not from a row name.
user507
  • 223
  • 1
  • 6
  • 14
9
votes
3 answers

R - Divide each value in matrix by maximum value of its row/column

I'm trying to transform the values in a matrix by dividing each value by the lesser of the maximum values of its column or row name. I am having trouble because I don't know how to query the row/column for a particular value from inside a larger…
Mon
  • 251
  • 1
  • 3
  • 9
9
votes
4 answers

How to delete rows from a dataframe that contain n*NA

I have a number of large datasets with ~10 columns, and ~200000 rows. Not all columns contain values for each row, although at least one column must contain a value for the row to be present, I would like to set a threshold for how many NAs are…
user2662708
  • 91
  • 1
  • 1
  • 2
9
votes
3 answers

Datagridview's row autoresize

I'm trying to automatically adjust a row's height and I've found it very challenging. I've already set this property : DataGridView.AutoSizeRowsMode = DataGridViewAutoSizeRowsMode.AllCells. I've also made it using this other…
monican
  • 353
  • 2
  • 3
  • 9
8
votes
1 answer

Concatenating multiple rows into single line in MS Access

Possible Duplicate: Combine rows in Access 2007 Access 2007 - Concatenate fields from one column in one table into a single, comma delmited value in another table Currently I have a table structure that is somewhat like this: Name --- Cat ---…
JT2013
  • 643
  • 6
  • 25
  • 46
8
votes
2 answers

Randomly re-order (shuffle) rows of a matrix?

I would like to randomly re-order the rows of matrix A to generate another new matrix. How to do that in R?
bit-question
  • 3,733
  • 17
  • 50
  • 63
8
votes
5 answers

SQL server: convert rows to columns

I have a table with columns sales(int), month(int). I want to retrieve sum of sales corresponding to every month. I need ouput in form of 12 columns corresponding to each month in which there will be a single record containing sales for for each…
Maddy.Shik
  • 6,609
  • 18
  • 69
  • 98
8
votes
2 answers

Building a matrix by merging the same row vector multiple times

Is there a matlab function which allows me to do the following operation? x = [1 2 2 3]; and then based on x I want to build the matrix m = [1 2 2 3; 1 2 2 3; 1 2 2 3; 1 2 2 3]
Simon
  • 4,999
  • 21
  • 69
  • 97
8
votes
1 answer

NSFetchedResultsController duplicated rows

I'm experiencing a weird behavior when using a secondary thread to refresh NSFetchedResultsController contents and I'd like to know it this is a common issue or I might be doing something wrong. I've got a centralized NSManagedObjectContext residing…