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
7
votes
2 answers

iTextSharp - Use Colspan with PdfPRow

I am able to create multiple rows if they contain the same number of columns: table = new PdfPTable(3); var firstRowCell1 = new PdfPCell( new Phrase ("Row 1 - Column 1")); var firstRowCell2 = new PdfPCell( new Phrase ("Row 2 - Column 2")); var…
Baxter
  • 5,633
  • 24
  • 69
  • 105
7
votes
5 answers

In SSIS, how do I get the number of rows returned from the Source that SHOULD be processed

I am working on a project to add logging to our SSIS packages. I am doing my own custom logging by implementing some of the event handlers. I have implemented the OnInformation event to write the time, source name, and message to the log file. When…
nleidwinger18
  • 169
  • 1
  • 2
  • 12
7
votes
3 answers

sum every 3 rows of a table

I have the following query to count all data every minute. $sql= "SELECT COUNT(*) AS count, date_trunc('minute', date) AS momento FROM p WHERE fk_id_b=$id_b GROUP BY date_trunc('minute', date) ORDER BY momento ASC"; What I need to do is get the…
Pablo Tapia
  • 353
  • 2
  • 10
6
votes
3 answers

Alternate row coloring in jquery

I have a table with expand and collapse of rows, with column sortable. Below is my code, is there is any ways to improve its performance. And read appending complete group of rows into dom improves performance, but if i do out of $.each() loop it…
vinay
  • 999
  • 2
  • 10
  • 19
6
votes
4 answers

SQL to transpose row pairs to columns in MS ACCESS database

I have an MS Access database that contains translated sentences in source-target pairs (a translation memory for fellow users of CAT tools). Somewhat annoyingly, source and target are not stored in separate columns, but in rows linked by ID, like…
Marek Jedliński
  • 7,088
  • 11
  • 47
  • 57
6
votes
2 answers

Transform rows in columns by Day Name

I have this table |ID | day_name | day_date | 1 Monday 2018-01-08 00:00:00.000 2 Monday 2018-01-15 00:00:00.000 3 Monday 2018-01-22 00:00:00.000 4 Monday 2018-01-29 00:00:00.000 10 Tuesday …
mecnism
  • 195
  • 2
  • 14
6
votes
1 answer

julia DataFrame select rows based values of one column belonging to a set

Using a DataFrame in Julia, I want to select rows on the basis of the value taken in a column. With the following example using DataFrames, DataFramesMeta DT = DataFrame(ID = [1, 1, 2,2,3,3, 4,4], x1 = rand(8)) I want to extract the rows with ID…
djourd1
  • 459
  • 4
  • 14
6
votes
1 answer

Identify only non duplicated rows

I have a dataset with many duplicated rows, and I would like to isolate only non duplicated values. my df looks something like this df <- data.frame("group" = c("A", "A", "A","A","A","B","B","B"), "id" = c("id1", "id2", "id3",…
Alex
  • 1,207
  • 9
  • 25
6
votes
1 answer

Find rows of dataframe with the same column value in Pandas

Consider a dataframe with 2 columns for easiness. The first column is id and it is the key. The second column, named code is not a key but the case of two entries having the same value is very rare. I want to find the rows having the same code value…
roschach
  • 8,390
  • 14
  • 74
  • 124
6
votes
2 answers

Get a new dataframe with difference of every two rows in Pandas

I have a dataframe in Pandas like the above: A B C 0 1 10 43 1 2 12 34 2 1 9 57 3 2 7 47 4 1 6 30 5 2 10 31 What I would like to do is to calculate the differences of every two rows according to column A…
tzoukritzou
  • 337
  • 1
  • 4
  • 16
6
votes
5 answers

Matrix, algorithm interview question

This was one of my interview questions. We have a matrix containing integers (no range provided). The matrix is randomly populated with integers. We need to devise an algorithm which finds those rows which match exactly with a column(s). We need to…
Brahadeesh
  • 2,245
  • 8
  • 40
  • 58
6
votes
3 answers

How to delete the last two rows of a df with pandas

Here is the code I'm playing with. I want to delete the last two lines of the file. I'm actually working on a bigger file and the last two lines fluctuate. Once I get it to work on this small format, I will implement it in my primary source code.…
Roberto Gonzalez
  • 77
  • 1
  • 1
  • 7
6
votes
2 answers

UICollectionView autosize and dynamic number of rows

I am trying to do something like this: Basically, I am using a UICollectionView and the cells (3 diferent .xib). So far, it works. The thing I want to do is: Set a autoheight If rotate, add 1 row to the UIColectionView 2.1 If tablet, on portrait…
Amg91
  • 165
  • 8
  • 25
6
votes
0 answers

Two rows in owl carousel 2

is it possible to do such a carousel as in the diagram below? I tried to use OWL Carousel 2 but I can not deal with 2 rows for desktop. Thanks in advance for the hints.
wolekpl
  • 101
  • 2
  • 10
6
votes
3 answers

HTML table: how to make all rows equal height?

I'm generating a table in HTML. I have a number of rows, whose count is kept in the variable {{ items|length }} How do I make all rows the same height except the header row? I've tried: