Posts by LeoGallerDev • 117 points
4 posts
-
5
votes3
answers212
viewsQ: Capture the WHERE clause of an SQL query
I need to capture only the clause where several queries to analyze the filters used. For example: select "DIM_1"."col1", "DIM_2"."col2" , "DIM_3"."col3" , "DIM_4"."col4" , "FAT_1"."col5" from…
-
2
votes1
answer2763
viewsQ: Importing data using pandas in python
Good afternoon Personal! I am trying to import a csv file using the pandas package in Python import pandas as pd names_col = ['AnoInfracao', 'TrimestreInfracao', 'CodigoInfracao',…
-
3
votes4
answers2433
viewsQ: Count the number of times a character appears in a string
I need to count the number of times a character repeats itself in a string. For example: How many times the character / appears in the string down below?…
-
1
votes2
answers86
viewsQ: Inserting a string into a list of ints
I have the following rule: Create a function that receives a list of integers, and replaces the items as below: if Multiples of 3 = 'Fizz' multiples of 5 = 'Buzz' multiples of 3 and 5 = 'Fizzbuzz' I…