Posts by Paula Pompeu • 96 points
4 posts
-
1
votes2
answers4838
viewsA: Changing a value with the pandas library
If the desired data type is numerical, you can, after opening the file, do this: df['coluna']=pd.to_numeric(df['coluna'], errors='coerce') Thus, you already convert the existing values to number and…
-
-1
votes1
answer424
viewsA: ORACLE/PLSQL auto increment
The dense_rank function assigns a ranking to the selected values. In the case of the code below, for each Name, apply a ranking according to the Age, and save this ranking in the ID field. SELECT…
-
2
votes3
answers127
viewsA: Select dates less than a given year
SELECT * FROM Tfuncionario where EXTRACT (YEAR FROM anoAdmissao) < '2000' The Extract function was used to select only the year of the fieldAdmission, and then compare it with the desired year.…
-
2
votes3
answers381
viewsA: How to select the year in PLSQL?
To extract the year you can use: SELECT idFuncionario, nomeFuncionario, anoAdmissao, EXTRACT (YEAR FROM anoAdmissao) AS ano FROM Tfuncionario If you want to select who is completing a year today can…