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
1 answer

Adding tooltip to rows in treeview in gtkmm

I am using a Gtk::TreeView to create a tree view in gtkmm. It has two columns. The first column has two types of icons in different rows. One icon is used to add an element to the tree and the second is used to delete the element from the tree. I…
Kamalpreet Grewal
  • 822
  • 1
  • 13
  • 28
1
vote
3 answers

Delete rows in a dataframe

I have this dataframe: x <- c(0,55,105,165,270,65,130,155,155,225,250,295, 30,100,110,135,160,190,230,300,30,70,105,170, 210,245,300,0,85,175,300,15,60,90,90,140,210, 260,270,295,5,55,55,90,100,140,190,255,285,270) y <-…
Lince202
  • 143
  • 10
1
vote
2 answers

Removing columns with all row entries of all zero except for the first occurrence

I have a big matrix with 3 rows and many columns. I want to remove the columns which have zeroes in all its rows except for the first occurrence. For example, given the following matrix: 1 1 0 0 0 0 0 0 A = 1 0 0 1 0 0 0 0 1 0 1 1 0 0 0…
Sardar Usama
  • 19,536
  • 9
  • 36
  • 58
1
vote
1 answer

Row requiring data in first field

Running into a problem where row[3] is requiring data in the csv for the first line or it throws an error. This field is for description/comments so its optional. Also any advise on what has to be ugly code for the quotes or anything else would be…
thinguy
  • 53
  • 7
1
vote
0 answers

count numbers of rows present in a column in MySql with C#

I want to add a Serial No. on the first column in the MySQL table in my C# program. To do this automatically with every row entry, I need to count previous rows and '+1' with the result. How to count numbers of rows present in a column in MySQL with…
Bishwajyoti Roy
  • 1,091
  • 1
  • 14
  • 19
1
vote
1 answer

Mysql Count and Sum Rows

I am having a mysql query (created by sagi) :- SELECT 'blr' AS Location, COUNT(*) AS playCnt, (select count(*) from blr_skip WHERE blr_skip_dt like '%2016-03-20%') as skipCnt FROM blr_play WHERE blr_play_dt like '%2016-03-20%'…
sona das
  • 1,299
  • 3
  • 9
  • 10
1
vote
3 answers

Convert rows to columns allowing duplicates

Consider the following table and rows: Listing A. ID, name, event, type 1, 'John Doe', '2010-09-01 15:00:00.000', 'input' 1, 'John Doe', '2010-09-03 11:00:00.000', 'input' 1, 'John Doe', '2010-09-04 17:00:00.000', 'input' 1, 'John Doe', '2010-09-02…
Gothmog
  • 871
  • 1
  • 8
  • 20
1
vote
2 answers

Excel VBA to delete rows -- how to make this quicker?

I am current using the below code snippet i found on stackxchg to delete rows that whereby there is no numeric value in column A. This works however it is gruesomely slow for a sheet with 5000 rows. Is there any way I can get this thing to go…
Jemie
  • 11
  • 2
1
vote
0 answers

Relational database batch processing rows

I have 3 tasks that needs to be done on a relational database (SQL Server or Oracle). 1. Archive (copy a set of rows if status is S from Table1 to ArchiveTable1(archive status set to X)) 2. Delete (Mark ArchiveTable1 rows for delete i.e. update…
Satish Rao
  • 31
  • 6
1
vote
3 answers

SQL select returning a defined number of rows

I want to get a 14 rows query result even when table has only 6 records available. For example table has only 6 records so I want to make a SELECT and the output throw me the 6 records with 8 blank rows. Like this: |trackings …
Luis Angel
  • 13
  • 3
1
vote
2 answers

Table rows into columns in mysql

Say I have a database similar to the following: Table events_degree: event_id degree_id 1 1 1 31 ... ... Table events_area: event_id area_id 1 1 1 31 ... …
Cesar Mtz
  • 322
  • 2
  • 13
1
vote
3 answers

C# Deleting Rows from DataGridView and Updating Database

I am trying to create an application that will contain a DataGridView with data bound to a DataSource. I use the fill method on Form_Load and I would like to know how do I delete one or more checkboxed rows, not only from my table but also from the…
SarahF
  • 11
  • 1
  • 2
1
vote
1 answer

How to Sum Visible Rows Only SSRS

I am trying to sum only the visible rows only in SSRS and I have read a few forums that say you need to put: =Sum( iif( , 0, Fields!A.Value)) However I am unsure on how this works, my visibility code…
HazelPhillips
  • 21
  • 6
1
vote
3 answers

Group months as season

I am stuck on a mysql query. I was wondering how I can group by multiple rows. I got the months and I wanted to group them together by season, so for example I want to show the crime count by adding all the crimes in the month from 01-03 and show…
armze3
  • 47
  • 1
  • 1
  • 7
1
vote
2 answers

SQL Server 2012: Pivoting(?) fixed number of rows as columns

I have a table called Car: CREATE TABLE [dbo].[Car]( [ID] [int] IDENTITY(1,1) NOT NULL, [Brand] [nchar](10) NOT NULL ) and one called Passenger: CREATE TABLE [dbo].[Passenger]( [ID] [int] IDENTITY(1,1) NOT NULL, [CarID] [int] NOT…
Peter
  • 169
  • 1
  • 12
1 2 3
…
99 100