Posts by LuizZ • 454 points
11 posts
-
0
votes3
answers61
viewsA: How to transform data frame variables into the indexes of a matrix with R?
I’m going to use an adaptation of the data you cited as an example: df <- read.table( header=TRUE, text = "userID itemID rating 2 3 4 3 2 1 1 1 3") Then I use some package functions tidyverse to…
-
3
votes2
answers279
viewsA: Changing a key value in a Python dictionary
You don’t need the key to the 'Código' to access key values 'Status_Aluguel'. You use the keys to access the values directly. For example: Imoveis_Cadastrados['Status_Aluguel'] = ['N', 'S'] Now…
-
5
votes1
answer94
viewsA: How to make boxplots monthly, quarterly, biannual, annual and every 10 years for a period of 30 years?
Since you did not provide the complete data, we can create something similar to them by the features described. This dataframe will be called df: library(tidyverse) library(ggplot2) temp_date <-…
-
3
votes1
answer60
viewsA: Geom_rect does not recognize alpha
This problem was described in the post Soen. Briefly, the point is that the geom_rect() function draws a rectangle for each line of your dataframe. In this way, rectangles overlap and cancel out the…
-
1
votes2
answers120
viewsA: How to apply a mathematical expression to all columns of a table in SAS?
The "proc standardize" procedure, called by the command PROC STDIZE, allows several forms of standardization of the numerical variables of a dataset/table in SAS. For the complete documentation of…
-
1
votes1
answer57
viewsA: Macro to open, stack and save several . sequential csv files in SPSS
Well, I asked the same question in stackoverflow in English and a user there @Li-k, knew how to answer. The link to the answer is here. And the credits of the code are from the quoted user. I have…
-
0
votes1
answer57
viewsQ: Macro to open, stack and save several . sequential csv files in SPSS
How to program a macro that: Only import a few columns (for example: ano, mes, id, valor and motivo ) of sequential . csv files for SPSS. These files would have type names: DADOS_JAN_2010,…
-
3
votes2
answers921
viewsQ: What is the difference between table, database and database?
Users of databases and tables that are not IT-related, especially researchers in the natural sciences and humanities, often use the terms "database", "database" and "tables" to refer to objects…
-
3
votes1
answer107
viewsQ: What is the difference between facet_wrap() and facet_grid() in ggplot?
The options facet_wrap() and facet_grid() in the ggplot have similar purposes, produce graphs with results stratified by a categorical variable. However, sometimes these options produce…
-
0
votes1
answer135
viewsA: What is Task-Driven User Interface?
Yes, task-driven user interface is the same as task-based user interface. Both mean "task-driven (or task-based) interface" and typically refer to enterprise database management software. The…
-
4
votes3
answers9682
viewsA: What’s the difference between Where and having?
The fundamental difference between the two clauses is that Where perform filtering in the source tables as the first step of the query (query), while Having perform the filtering in the resulting…