Posts by Jonatã Paulino • 135 points
9 posts
-
0
votes3
answers398
viewsA: Intersection between pandas columns
Taking advantage of the question, would these codes serve for totally different dataframes in both the number of rows and the number of columns? And if we were to compare the lines with texts…
-
0
votes1
answer27
viewsQ: Inserting Data Conditionally in MYSQL
I have a table: conluna1, column2, column3.. The first two columns have integer data, 0 and 1, while the third column is without even a record. I would like to fill this column according to one…
-
0
votes0
answers94
viewsQ: Time Out When trying to run query in Mysql
I’m running the following code: SELECT e.*, e.CO_ESCOLA, es.CO_ENTIDADE FROM enem20162 e INNER JOIN escolas es ON e.CO_ESCOLA = es.CO_ENTIDADE #WHERE CO_ENTIDADE = ORDER BY e.CO_ESCOLA; I want to…
-
1
votes1
answer999
viewsQ: LEFT OUTER JOIN
I have a table in Postgresql. I would like to count two columns where one has more record than the other. If I use LEFT OUTER JOIN I think it will work, however, I’m not succeeding with the…
-
1
votes1
answer1473
viewsQ: Error importing Postgre bank
I have a bank to import, it’s native to Postgresql and is with extension .sql, I’m trying to care in the PgAdmin4 but I can’t do it at all. There’s a picture of the error.…
-
0
votes0
answers58
viewsQ: Comparing three column records in a mysql table
I make an appointment at COL1 which has the total of lines and then make an appointment at COL2, but it is smaller than COL1. How do I make COL2 return me the Ids equal to those of COL1 so that they…
-
0
votes0
answers45
viewsQ: CAST in multiple columns to average
I have several columns in a csv table, I imported the table into mysql, but when I import into mysql I have to do this import as varchar for all data. If I do a CAST in these columns and then take…
-
0
votes1
answer47
viewsQ: Select 5 thousand rows from a table
I have a table with more than 5 thousand lines, where I have a column with year, nomes_municipios and another with values. I can get an average with a municipality that is represented on a line, but…
selectasked Jonatã Paulino 135 -
11
votes1
answer2490
viewsQ: Pattern recognition
I have hundreds of digital images of dogs and cats, I need to make an algorithm to recognize when the dog is and when the cat is. What steps should I take?