Top "Rows" questions

Python: Number of rows affected by cursor.execute("SELECT ...)

How can I access the number of rows affected by: cursor.execute("SELECT COUNT(*) from result where server_state='2…

python sql rows database

How to remove rows with any zero value

I have a problem to solve how to remove rows with a Zero value in R. In others hand, I …

r rows zero

Select multiple rows with the same value(s)

I have a table, sort of like this: ID | Chromosome | Locus | Symbol | Dominance | =============================================== 1 | 10 | 2 | A | Full | 2 | 10 | 2 | a | Rec. | 3 | 10 | 3 | B | Full | 4 | 10 | 3 | b | …

sql rows

Excel Create Collapsible Indented Row Hierarchies

I would like to create indented collapsible row hierarchies in Excel for my spreadsheet. I have used group function but …

excel rows folding

Delete rows containing specific strings in R

I would like to exclude lines containing a string "REVERSE", but my lines do not match exactly with the word, …

r string match rows

Repeat rows of a data.frame

I want to repeat the rows of a data.frame, each N times. The result should be a new data.…

r dataframe rows repeat

SQL count rows in a table

I need to send a SQL query to a database that tells me how many rows there are in a …

sql-server count rows database-table

Find which rows have different values for a given column in Teradata SQL

I am trying to compare two addresses from the same ID to see whether they match. For example: Id Adress …

sql join teradata rows matching

Converting rows into columns and columns into rows using R

I have a dataframe with unique row names and unique column names. I want to convert the rows into columns …

r rows transpose col

Removing specific rows from a dataframe

I have a data frame e.g.: sub day 1 1 1 2 1 3 1 4 2 1 2 2 2 3 2 4 3 1 3 2 3 3 3 4 and I would like to remove specific rows that can be …

r dataframe rows