Posts by Roney Wesley Galan • 179 points
11 posts
-
1
votes1
answer29
viewsA: Grouping by several variables
I got the code below: df = df.sort_values(['year', 'month','quarter', 'week' , 'day']).drop_duplicates(['year', 'month','quarter', 'week'] , keep ='last')
pythonanswered Roney Wesley Galan 179 -
1
votes1
answer29
viewsQ: Grouping by several variables
I’m working on the base below, and I need to group the variable close, grouping the last day of each week, by month and year, the base I’m working on has data from 2005 to 2017, below I’m just…
pythonasked Roney Wesley Galan 179 -
1
votes2
answers60
viewsQ: Add multiple selects in a single dataset
I have the dataset below and I do a consolidation of the categories Mk_cap, Exports and Money_supply, but each of these grids has a different Unit. df <-…
-
-3
votes1
answer61
viewsQ: set a path according to the user to a folder
I have a script that I am setting a path where are the datasets that I will work, but now the scripts will start to be run by other people on the team, as I do to leave the folder with dynamic value…
rasked Roney Wesley Galan 179 -
2
votes1
answer64
viewsQ: How to extract only the first value from a row of concatenated values?
I have the database below, and would like to capture only the first value of each line. a <- data.frame('Exports' = c("c(182752.414, 179107.7)", "c(200491.435, 195097.2)", "c(217566.642,…
rasked Roney Wesley Galan 179 -
3
votes1
answer32
viewsQ: Create conditional with counter in a column
I have a basis that I need to know which number is greater than 100, but if I have a sequence of values greater than 100 I need the column to accumulate the value of 1 in 1, I added an output figure…
rasked Roney Wesley Galan 179 -
2
votes2
answers46
viewsQ: Multiple Moving Medium Columns
I would like to create several columns derived from the column x. These columns should receive moving averages of 2, 5... periods. I tried to do the creation with dplyr::mutate, but it didn’t work.…
-
1
votes1
answer26
viewsQ: Turns an observation into a variable in R
I would like to know how to transpose the observations of a dataframe to turn it into variables. The Subcategory column has to break down into several variables and its observations would be the…
rasked Roney Wesley Galan 179 -
3
votes1
answer52
viewsQ: Apply row-to-row formula within a table in R
I have a table where I need to apply a row-to-row formula to multiple columns, and the formula is: row value - mean(all column values) / standard deviation(all column values) is a normalization of…
-
2
votes2
answers62
viewsQ: Perform a previous values calculation in column on R
I would like to assemble a column according to the result of 2 lines of another column, follows the formula below, I have no idea how to assemble this in R or Python and would like a collaboration…
-
0
votes0
answers353
viewsQ: Bulk Insert bringing information without accentuation
Expensive, Good Afternoon! I have a problem when I perform an excel Bulk Insert for Sqlserver, I have a column called city and when I do the Bulk Insert and include the information in the database…