Posts by Lucas Marques Vieira • 57 points
4 posts
-
-1
votes1
answer23
viewsQ: Operation of datiff in SQL 2014
I have an accumulated base of dates in sql, I wanted to select all dates you have from the current date (today) until 60 days ago, but I’m not getting the code right. ***select data CPF, sum(risco)…
-
1
votes2
answers41
viewsQ: Varchar operation in SQL 2014
I am trying to do a less sql account in sql Sever management but this format error. I am wanting to do the months account 202103 - 202101 = 2 months How to solve this format problem? select * ,DPD =…
-
-2
votes1
answer874
viewsQ: Select the top 10 values of a dataframe variable in python?
I need to figure out the top 10 values of the variable qty sales together with the information of client name of a sales base. To find out the names of the 10 customers who bought the most. Making…
pythonasked Lucas Marques Vieira 57 -
3
votes1
answer1112
viewsQ: Count number of unique records in a Data Frame
I have a base with a column custumer_id and I need to know the amount of unique records on the base. quantidade_clientes = df[['customer_id']] quantidade_clientes.count() This way I count everyone,…