Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Guys!
I'm new to R Studio and Power BI. When I try to run the script from R, I get the error message "Object (data) not found Execution halted" when the files necessary to complete is loaded. Can anyone help? Image for more information.
Bump
Hi @rdides,
Have you run the R script in R Studio and checked if it works well?
The above error could be caused by incorrect syntax in the R script, could you please share some sample data and R script so that we can try to reproduce?
Thanks,
Lydia Zhang
The data works in R! I just ran it once more.
Here's the code:
library(dplyr)
library(plotly)
library(scales)
ggplot(DMAMappingData,aes(long,lat))+
geom_polygon(aes(fill=`DTC Penetration Levels`,group=group),colour=I("white"))+
geom_polygon(data=States, aes(long, lat,group=group, colour = I("black"))
,alpha=0)+
coord_map("albers", at0 = 45.5, lat1 = 29.5)+
theme_bw() + theme(panel.border = element_blank(), panel.grid.major = element_blank(),
panel.grid.minor = element_blank(), axis.line = element_line(colour = "black"),
axis.line.x = element_blank(),axis.line.y = element_blank(),
axis.text.x = element_blank(),axis.text.y = element_blank(),
axis.title = element_blank(),axis.ticks = element_blank())+
scale_fill_brewer(palette = "Set1")
Sample DMA Mapping Data:
long | lat | DMA Number | group | X1 | DMA Tier | DMA Name | DTC Penetration Levels |
-83.2864 | 38.60018 | 515 | 515.1 | 16 | C | CINCINNATI | (0.47-0.821)% |
-83.6158 | 38.68465 | 515 | 515.1 | 16 | C | CINCINNATI | (0.47-0.821)% |
-83.6447 | 38.52566 | 515 | 515.1 | 16 | C | CINCINNATI | (0.47-0.821)% |
-83.9279 | 38.49336 | 515 | 515.1 | 16 | C | CINCINNATI | (0.47-0.821)% |
-83.9972 | 38.42132 | 515 | 515.1 | 16 | C | CINCINNATI | (0.47-0.821)% |
-84.1706 | 38.48591 | 515 | 515.1 | 16 | C | CINCINNATI | (0.47-0.821)% |
-84.2052 | 38.58279 | 515 | 515.1 | 16 | C | CINCINNATI | (0.47-0.821)% |
-84.4133 | 38.5654 | 515 | 515.1 | 16 | C | CINCINNATI | (0.47-0.821)% |
-84.7947 | 38.33934 | 515 | 515.1 | 16 | C | CINCINNATI | (0.47-0.821)% |
-85.0779 | 38.57783 | 515 | 515.1 | 16 | C | CINCINNATI | (0.47-0.821)% |
-84.9392 | 38.65235 | 515 | 515.1 | 16 | C | CINCINNATI | (0.47-0.821)% |
-85.0259 | 38.76166 | 515 | 515.1 | 16 | C | CINCINNATI | (0.47-0.821)% |
-85.1992 | 38.6921 | 515 | 515.1 | 16 | C | CINCINNATI | (0.47-0.821)% |
-85.205 | 38.9132 | 515 | 515.1 | 16 | C | CINCINNATI | (0.47-0.821)% |
-85.4477 | 38.9132 | 515 | 515.1 | 16 | C | CINCINNATI | (0.47-0.821)% |
-85.4419 | 39.19641 | 515 | 515.1 | 16 | C | CINCINNATI | (0.47-0.821)% |
-85.2975 | 39.26845 | 515 | 515.1 | 16 | C | CINCINNATI | (0.47-0.821)% |
-85.2975 | 39.52433 | 515 | 515.1 | 16 | C | CINCINNATI | (0.47-0.821)% |
-85.0374 | 39.52681 | 515 | 515.1 | 16 | C | CINCINNATI | (0.47-0.821)% |
-85.0316 | 39.72804 | 515 | 515.1 | 16 | C | CINCINNATI | (0.47-0.821)% |
-84.812 | 39.72555 | 515 | 515.1 | 16 | C | CINCINNATI | (0.47-0.821)% |
-84.8178 | 39.56656 | 515 | 515.1 | 16 | C | CINCINNATI | (0.47-0.821)% |
-83.5753 | 39.5442 | 515 | 515.1 | 16 | C | CINCINNATI | (0.47-0.821)% |
-83.5927 | 39.37776 | 515 | 515.1 | 16 | C | CINCINNATI | (0.47-0.821)% |
-83.3731 | 39.37776 | 515 | 515.1 | 16 | C | CINCINNATI | (0.47-0.821)% |
-83.3846 | 39.0548 | 515 | 515.1 | 16 | C | CINCINNATI | (0.47-0.821)% |
-83.2691 | 39.01506 | 515 | 515.1 | 16 | C | CINCINNATI | (0.47-0.821)% |
-83.2864 | 38.60018 | 515 | 515.1 | 16 | C | CINCINNATI | (0.47-0.821)% |
There is another file it uses in the code named "States" but that lays out the states on the USA. But the problem is with "DMAMappingData not found, so I don't know what the issue is. Thank you for your help!
Hi,
I have the same issue with the R visuals and I can't figure out why it doesn't detect my data fields in the data.frame.
Did you get any resolution and if yes, would you mind post it here for further reference?
Thanks!
Petya
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
102 | |
84 | |
79 | |
68 |
User | Count |
---|---|
120 | |
110 | |
94 | |
81 | |
77 |