Posts by RxT • 995 points
64 posts
-
1
votes0
answers195
viewsQ: Latex - How to turn a table into a longtable?
I have a table that got too grid. I would like to turn it into a long table. How do I ? I have tried to delete Begin{table} and change Begin{tabular} to Begin{longtable}, but it did not work. The…
-
0
votes1
answer102
viewsA: A - Adding values with one condition
It was very simple I was able to solve using the function Aggregate() Became: Balancete <- aggregate(Balanceteo, by = list(Balancete$CNPJ, Balancete$ANO), FUN = sum)…
-
-3
votes1
answer102
viewsQ: A - Adding values with one condition
Good morning ! I have the DF below, I need to add the values of the accounts (columns with numbers) SEMESTER 1 with the 2 (if you have), by CNPJ and YEAR. Thus, I will have the total values of the…
-
0
votes0
answers202
viewsQ: Animated Graphics - R
Hi, I need to make an animated chart that shows the top 10 states. I’m trying, but it’s showing the top 14 and it’s not in the order from the highest to the lowest. Below is the code used: #…
-
0
votes1
answer192
viewsA: A: Creating map by municipality
The map worked with the following code: # packages require(maptools) require(descr) require(RColorBrewer) require(plotrix) library(tidyverse) library(dplyr) library(rgdal) # Tratamento CPF_MUN_UF_IF…
-
0
votes1
answer192
viewsQ: A: Creating map by municipality
Hello, I need to create a map that shows the amount of CPF in Coop. per municipality (ex: blank cities = 0 CPF, dark green cities = 500 CPF). I did by State and it worked, but when I apply to…
-
7
votes2
answers4121
viewsQ: R - Map of Brazilian cities
Good morning, I’m trying to create a Brazilian map that presents the amount of cooperatives present in each city. I have a table with the IBGE code of the municipalities and the amount of Coop. I…
-
3
votes1
answer611
viewsQ: A - How to create a delayed variable (lag) conditioned to the individual?
I need to delay a variable from my db (dCoopCred). However, it cannot mix the delay of two individuals (CNPJ). I would like that LAG_Result_ant_desp were Result_ant_desp in t-1 (previous period).…
-
0
votes1
answer152
viewsQ: R - Econometrics - Wald test and autocorrelation
Good afternoon, I would like to know how to perform the Wald Test (for heterocedasticity) and the test proposed by Wooldridge for autocorrelation. I am using panel data (unbalanced), with Pooled…
-
0
votes1
answer75
viewsQ: R - Graphs with information from different columns
Hello, I have the following problem: I need to create a table and a chart with information on educational level for different positions of the firm for different years and regions. I have 4 levels…
-
2
votes1
answer126
viewsA: Create one column indexed to another in R
I solved through a for: dCoopCred$PIB <- c(0) for(i in row(dCoopCred)){ if(dCoopCred$ano[i]==2006){dCoopCred$PIB[i] <- c(4) } else if (dCoopCred$ano[i]==2007){dCoopCred$PIB[i] <- c(6.1)…
-
3
votes1
answer171
viewsQ: A - How to calculate the price variation for different periods and companies?
Hello, I would like to know how to calculate the price variation from one period to another. Being several years for several companies. Example: Company | Year | Price 1 |2007 | 25 1 | 2008 | 30 1…
-
3
votes1
answer530
viewsQ: R - How to calculate the price change from one period to another?
Hello, I would like to know how to calculate the price variation from one period to another. Example: Year | Price 2007 | 25 2008 | 30 2009 | 7 2010 | 15 ... |...|... The new column would be: Year |…
-
3
votes1
answer126
viewsQ: Create one column indexed to another in R
Good afternoon ! I am new to R and have a database where I need to include a column, however the values of this column need to be linked to the values of another column. In case, I have the column…