Posts by Natália Melgaço • 76 points

• 1

  votes

  2

  answers

  870

  views

  A: Adding total sum grouped to a new column Dataframe pyspark

  Adriana, I don’t understand the calculation to make your new column. If NEW_COL = (total sum of col1 by type - the value of col3) / (total Qtd of col1 by type - 1) then for first line of NEW_COL…

  python sum

  answered 6 years, 6 months ago Natália Melgaço 76

• 5

  votes

  1

  answer

  83

  views

  A: Query in two tables

  Hello! Just make a Join by the common key in both tables. Your code would look like this: SELECT Empresa.id, Empresa.cnpj, Filial.endereco FROM Empresa INNER JOIN Filial on…

  sql

  answered 6 years, 6 months ago Natália Melgaço 76