- 311
- 487 536
Data Analytic
Australia
เข้าร่วมเมื่อ 18 พ.ค. 2014
Demystify the data science, visualisation with simple, practical and concise answers to your data science and visualisation questions.
We have hundred of videos covering various aspects of Data Analytics. Our aim is to provide concise, practical and fit for purpose content for Data scientists .You would regularly find new R, Python, C#, database, automation related content on your channel.
In today's world just using one tool is not enough, like a tradesman toolkit which has various tools for various needs.
Enhance your toolkit by learning tools fit for purpose.
Browse through our full range of videos on visualisation using GGPLOT. When creating charts for a document it is important to have the same look and feel for all your charts. We have a full suite of GGPLOT charts tutorials.
We thank everyone in helping support this channel.
Please subscribe th-cam.com/users/TechAnswers88?s_confirmation=1
We have hundred of videos covering various aspects of Data Analytics. Our aim is to provide concise, practical and fit for purpose content for Data scientists .You would regularly find new R, Python, C#, database, automation related content on your channel.
In today's world just using one tool is not enough, like a tradesman toolkit which has various tools for various needs.
Enhance your toolkit by learning tools fit for purpose.
Browse through our full range of videos on visualisation using GGPLOT. When creating charts for a document it is important to have the same look and feel for all your charts. We have a full suite of GGPLOT charts tutorials.
We thank everyone in helping support this channel.
Please subscribe th-cam.com/users/TechAnswers88?s_confirmation=1
Flexdashboard 03: Advanced yet automatic theming of static charts using Bootstrap.
Automatic theming of your dashboard using Boostrap.
We specialise in practical, concise and sharp videos on various data related topics like statistics, visualisation, automation, validation.
We mainly create videos on R, Python and other related technologies which compliment the data science needs.
If you are beginner then watch this video to get started
How to install R and R Studio th-cam.com/video/MsMwj525qrY/w-d-xo.html
Watch our playlists
GGPLOT charting galore th-cam.com/play/PLkHcMTpvAaXV6Eg5ZHbcT2tA9-QnhJrIa.html
DPLYR series - DPLYR is one of the most important tool in data handling. Learn all about it in th-cam.com/play/PLkHcMTpvAaXVJzyRSytUn3nSK92TJphxR.html
Geo analytics mapping techniques th-cam.com/play/PLkHcMTpvAaXUTgm7q5yed8d6ZByHZOdnz.html
Statistics in R th-cam.com/play/PLkHcMTpvAaXXGWuNGNoTIY4lPIdAYIGlL.html
Python - statistics, automation and visualisation th-cam.com/play/PLkHcMTpvAaXUIyDSW2Dqeh2b0DUoCy3ne.html
HighCharter interactive and static charting th-cam.com/play/PLkHcMTpvAaXW2Q8mayIxw2YE9T5B-Xiq6.html
Some amazing stuff that Excel can do th-cam.com/play/PLkHcMTpvAaXVVlIC-b-bqqv3zMN-WKItv.html
Our everygrowing playlist of sharp and short videos in the #shorts format for one minute learning th-cam.com/play/PLkHcMTpvAaXWUmuBxdcUtS2DPKEkGCagU.html
We specialise in practical, concise and sharp videos on various data related topics like statistics, visualisation, automation, validation.
We mainly create videos on R, Python and other related technologies which compliment the data science needs.
If you are beginner then watch this video to get started
How to install R and R Studio th-cam.com/video/MsMwj525qrY/w-d-xo.html
Watch our playlists
GGPLOT charting galore th-cam.com/play/PLkHcMTpvAaXV6Eg5ZHbcT2tA9-QnhJrIa.html
DPLYR series - DPLYR is one of the most important tool in data handling. Learn all about it in th-cam.com/play/PLkHcMTpvAaXVJzyRSytUn3nSK92TJphxR.html
Geo analytics mapping techniques th-cam.com/play/PLkHcMTpvAaXUTgm7q5yed8d6ZByHZOdnz.html
Statistics in R th-cam.com/play/PLkHcMTpvAaXXGWuNGNoTIY4lPIdAYIGlL.html
Python - statistics, automation and visualisation th-cam.com/play/PLkHcMTpvAaXUIyDSW2Dqeh2b0DUoCy3ne.html
HighCharter interactive and static charting th-cam.com/play/PLkHcMTpvAaXW2Q8mayIxw2YE9T5B-Xiq6.html
Some amazing stuff that Excel can do th-cam.com/play/PLkHcMTpvAaXVVlIC-b-bqqv3zMN-WKItv.html
Our everygrowing playlist of sharp and short videos in the #shorts format for one minute learning th-cam.com/play/PLkHcMTpvAaXWUmuBxdcUtS2DPKEkGCagU.html
มุมมอง: 26
วีดีโอ
Mix Python and R in RMarkdown | Take your RMarkdown to next level
มุมมอง 4314 ชั่วโมงที่ผ่านมา
Best of both worlds, use Python and R Scripts in your RMarkdown seamlessly. We specialise in practical, concise and sharp videos on various data related topics like statistics, visualisation, automation, validation. We mainly create videos on R, Python and other related technologies which compliment the data science needs. If you are beginner then watch this video to get started How to install ...
Flexdashboard 02 - Can I use CSS in my flexdashboard. | Creating data visualisation like a pro.
มุมมอง 49วันที่ผ่านมา
Using Flexdashboard to develop data visualisations like a pro. We specialise in practical, concise and sharp videos on various data related topics like statistics, visualisation, automation, validation. We mainly create videos on R, Python and other related technologies which compliment the data science needs. If you are beginner then watch this video to get started How to install R and R Studi...
Why should Data Scientists care about Colour Vision Deficiency # Colour Blindness
มุมมอง 4814 วันที่ผ่านมา
Colour Vision Deficiency or Colour Blindness is an important aspect when using different colours in your presentations or charts. We specialise in practical, concise and sharp videos on various data related topics like statistics, visualisation, automation, validation. We mainly create videos on R, Python and other related technologies which compliment the data science needs. If you are beginne...
Can we use a Date Table in R ??
มุมมอง 12621 วันที่ผ่านมา
Can we use a Date Table in R ?? PowerBI uses a date table, can we use similar concept in R? We specialise in practical, concise and sharp videos on various data related topics like statistics, visualisation, automation, validation. We mainly create videos on R, Python and other related technologies which compliment the data science needs. If you are beginner then watch this video to get started...
Flexdashboard 01 :How to create a flexdashboard in R in 3 minutes
มุมมอง 80หลายเดือนก่อน
R Beginners:How to create a flexdashboard in R in 3 minutes Data Visualisation Dashboard in R We specialise in practical, concise and sharp videos on various data related topics like statistics, visualisation, automation, validation. We mainly create videos on R, Python and other related technologies which compliment the data science needs. If you are beginner then watch this video to get start...
R programming: Spotting Correlated Trends Across Stock Indices with YahooFinancer
มุมมอง 39หลายเดือนก่อน
Dive into the world of stock market analysis with YahooFinancer! This guide explores how to identify and interpret correlated trends across multiple stock indices, providing actionable insights for traders, investors, and analysts. Learn to harness YahooFinancer's powerful tools to visualize relationships between indices, uncover patterns, and make informed decisions. Whether you're tracking gl...
🗺️ RNaturalEarth Map creation: Highlight States with Custom Colors - No External Shapefiles Needed!
มุมมอง 85หลายเดือนก่อน
We specialise in practical, concise and sharp videos on various data related topics like statistics, visualisation, automation, validation. We mainly create videos on R, Python and other related technologies which compliment the data science needs. If you are beginner then watch this video to get started How to install R and R Studio th-cam.com/video/MsMwj525qrY/w-d-xo.html Watch our playlists ...
🐍 Python for Beginners: Calculate Financial Year from Dates Easily!
มุมมอง 34หลายเดือนก่อน
🐍 Python for Beginners: Calculate Financial Year from Dates Easily!
Python Beginners :How To Plot A Bar Chart With matplotlib by using Sample data | manual data |CSV
มุมมอง 45หลายเดือนก่อน
Python Beginners :How To Plot A Bar Chart With matplotlib by using Sample data | manual data |CSV
Store your R data in Apache Parquet Big Data Format | See the read /write performace comparison .
มุมมอง 100หลายเดือนก่อน
Store your R data in Apache Parquet Big Data Format | See the read /write performace comparison .
How to make a word cloud in R with ggplot
มุมมอง 1322 หลายเดือนก่อน
How to make a word cloud in R with ggplot
🕵️♂️ Tintin in Trouble: Analyzing and Charting Head Trauma in the Adventures of Tintin!
มุมมอง 1092 หลายเดือนก่อน
🕵️♂️ Tintin in Trouble: Analyzing and Charting Head Trauma in the Adventures of Tintin!
🌍 Geocoding in R: Address-to-Coordinates Made Easy - No APIs, No Hassle! 🌍
มุมมอง 1112 หลายเดือนก่อน
🌍 Geocoding in R: Address-to-Coordinates Made Easy - No APIs, No Hassle! 🌍
📊 One-Word Command to Calculate Mean & Confidence Intervals in R!
มุมมอง 1003 หลายเดือนก่อน
📊 One-Word Command to Calculate Mean & Confidence Intervals in R!
Easiest method: Cut numerical Values into groups or bins with one line of code.
มุมมอง 573 หลายเดือนก่อน
Easiest method: Cut numerical Values into groups or bins with one line of code.
R GeoAnalytics programming :Manipur State Map with Districts and plot data points on it.
มุมมอง 1194 หลายเดือนก่อน
R GeoAnalytics programming :Manipur State Map with Districts and plot data points on it.
R Programming: Unzip a TAR GZ file in R
มุมมอง 1104 หลายเดือนก่อน
R Programming: Unzip a TAR GZ file in R
Absolute Beginners: What is CSV and how to import the CSV Data in Power BI
มุมมอง 284 หลายเดือนก่อน
Absolute Beginners: What is CSV and how to import the CSV Data in Power BI
Absolute Beginners: 02 Understand PowerBI FACT and DIM Table concept , create fast,scalable reports.
มุมมอง 214 หลายเดือนก่อน
Absolute Beginners: 02 Understand PowerBI FACT and DIM Table concept , create fast,scalable reports.
Absolute Beginners: 01 Your very first Power BI Chart
มุมมอง 404 หลายเดือนก่อน
Absolute Beginners: 01 Your very first Power BI Chart
Stunning Histograms showing mean and standard deviation in R
มุมมอง 1625 หลายเดือนก่อน
Stunning Histograms showing mean and standard deviation in R
Rowwise operations in DPLYR, When to use it, don't get wrong results.
มุมมอง 2058 หลายเดือนก่อน
Rowwise operations in DPLYR, When to use it, don't get wrong results.
How to add a WaterMark in your ggplot charts using your own text !!
มุมมอง 1.6K8 หลายเดือนก่อน
How to add a WaterMark in your ggplot charts using your own text !!
Marginal Plot in R | Simple and Grouped Marginal Plots | Publication ready
มุมมอง 1938 หลายเดือนก่อน
Marginal Plot in R | Simple and Grouped Marginal Plots | Publication ready
Assign fixed colours to each categorical variable in GGPLOT! 🚀 📊✨
มุมมอง 1219 หลายเดือนก่อน
Assign fixed colours to each categorical variable in GGPLOT! 🚀 📊✨
🚀 Sophisticated Pie Chart using GGPLOT and GLUE 🚀 📊✨
มุมมอง 1669 หลายเดือนก่อน
🚀 Sophisticated Pie Chart using GGPLOT and GLUE 🚀 📊✨
Use GLUE in RMD to generate dynamic description about your data in R Markdown! 🚀 📊✨
มุมมอง 19810 หลายเดือนก่อน
Use GLUE in RMD to generate dynamic description about your data in R Markdown! 🚀 📊✨
Package is corrupt, not working!!!
Hi Just tested installing it on a fresh machine and it worked fine. I used the following two commands install.packages("remotes") remotes::install_github("davidsjoberg/ggsankey") And it resulted it installing the package. And I was able to use the code to produce the charts rpubs.com/techanswers88/multiple-choice-questions-in-ggplot-sankey See bnelow the messages received during installation of the packages. Note: It may also ask to update the dependencies ( additional packages which the ggsankey library might be using. I chose to skip the updates. remotes::install_github("davidsjoberg/ggsankey") Downloading GitHub repo davidsjoberg/ggsankey@HEAD These packages have more recent versions available. It is recommended to update all of them. Which would you like to update? 1: All 2: CRAN packages only 3: None 4: glue (1.7.0 -> 1.8.0 ) [CRAN] 5: cli (3.6.2 -> 3.6.3 ) [CRAN] 6: pillar (1.9.0 -> 1.10.0) [CRAN] 7: withr (3.0.0 -> 3.0.2 ) [CRAN] 8: colorspace (2.1-0 -> 2.1-1 ) [CRAN] 9: cpp11 (0.4.7 -> 0.5.1 ) [CRAN] 10: gtable (0.3.5 -> 0.3.6 ) [CRAN] Enter one or more numbers, or an empty line to skip updates: ── R CMD build ──────────────────────────────────────────────────────────────────────────────────────── ✔ checking for file 'C:\Users\HS\AppData\Local\Temp\Rtmp8QheiR emotes300454ed4de2\davidsjoberg-ggsankey-b675d0d/DESCRIPTION' ... ─ preparing 'ggsankey': ✔ checking DESCRIPTION meta-information ─ checking for LF line-endings in source and make files and shell scripts ─ checking for empty or unneeded directories ─ building 'ggsankey_0.0.99999.tar.gz' Installing package into ‘C:/Users/HS/AppData/Local/R/win-library/4.4’ (as ‘lib’ is unspecified) * installing *source* package 'ggsankey' ... ** using staged installation ** R ** byte-compile and prepare package for lazy loading ** help *** installing help indices *** copying figures ** building package indices ** testing if installed package can be loaded from temporary location ** testing if installed package can be loaded from final location ** testing if installed package keeps a record of temporary installation path * DONE (ggsankey)
Great video! But how do you select the env you want to use when creating a new python script?
Hi Thanks a lot for compliments. You can use the use_virtual_environment('your_python_virtual_env", required = 'TRUE') , Please see the video at timestamp 1:26. All the best.
PieChart in lessR is much easier
Nice.
Do you post the code anywhere?
Hi there. I have realised that on the videos where I posted the code, the views dropped as people just take the code without watching the video. However I have put the code in such a way that it is fully visible on one single screen, please take a screenshot. Apologies if I disappointed you. I might post the code in few days though.
Proposing the case for using a readymade data table in R. When creating a chart or a aggregate table we can always use the appropriate functions to convert a date into any other unit like year, month, financial year, quarter, financial quarter, semester and so on. But if it is already available via a simple date table then it makes the life easy. You can make the coffee from scratch, but when you are hard pressed for time an instant coffee might be what we need. (Not offending the coffee lovers , I love my cofee too, but just using an analogy). This is what the ready made date table can do for you. Since I have started using the data table, it is a piece of cake to draw various charts in few seconds. Create once use again and again. Would love to hear your experiences on this. Is there any other field which you use when using dates ?
Fetch Data from Yahoo Finance API - Obtain historical and near real time data related to stocks, index and currencies from the Yahoo Finance API using R.
Super helpful. Thanks a lot. Btw, prof Ravi, is that you?
Ever noticed how often Tintin gets hit on the head? We’ve charted his head trauma in a fun and creative way, complete with the iconic color schemes from his comic book covers!
Easy Maps of any country using RNaturalEarth. Learn to customise the colours for each state and learn to highlight a state. We also have a full playlist of geoanalytics th-cam.com/play/PLkHcMTpvAaXUTgm7q5yed8d6ZByHZOdnz.html
thank you madam well explained.
A quick clip to see the power of tbl_summary in action th-cam.com/users/clipUgkxdzJBFDR4FKAmq10tkbkBaBoAPnOdd4OH?si=KcUXQqTbwrx-qzhP
Python Videos of interest to you Python Podcastth-cam.com/play/PLkHcMTpvAaXXmjc6hr58Li0sdtt7EGQ2G.html
Financial Year or Fiscal Year can be extracted from your dates, sometimes a nicely formatted label like '2024-25' is used for indicating fin years. Learn to do that in simple steps. Greate learning steps for beginners of Data Analytics in Python. 🙂
It is very helpful. Thank you
Glad it was helpful!
PowerBI Playlist th-cam.com/play/PLkHcMTpvAaXV5TOrcSbn-fZiMyMbEEbgf.html
More than 100 videos on GGPLOT, I would like to see that ! th-cam.com/play/PLkHcMTpvAaXV6Eg5ZHbcT2tA9-QnhJrIa.html
More than 100 videos on GGPLOT, I would like to see that ! th-cam.com/play/PLkHcMTpvAaXV6Eg5ZHbcT2tA9-QnhJrIa.html
More than 100 videos on GGPLOT, I would like to see that ! th-cam.com/play/PLkHcMTpvAaXV6Eg5ZHbcT2tA9-QnhJrIa.html
More than 100 videos on GGPLOT, I would like to see that ! th-cam.com/play/PLkHcMTpvAaXV6Eg5ZHbcT2tA9-QnhJrIa.html
More than 100 videos on GGPLOT, I would like to see that ! th-cam.com/play/PLkHcMTpvAaXV6Eg5ZHbcT2tA9-QnhJrIa.html
More than 100 videos on GGPLOT, I would like to see that ! th-cam.com/play/PLkHcMTpvAaXV6Eg5ZHbcT2tA9-QnhJrIa.html
Want to learn to create maps, choropleths maps and more. th-cam.com/play/PLkHcMTpvAaXUTgm7q5yed8d6ZByHZOdnz.html
Want to learn to create maps, choropleths maps and more. th-cam.com/play/PLkHcMTpvAaXUTgm7q5yed8d6ZByHZOdnz.html
Learn to use dplyr in R. th-cam.com/play/PLkHcMTpvAaXVJzyRSytUn3nSK92TJphxR.html
Great, thanks. Also the Code URL is very helpful!
If to "tools& global options" Can?
Your videos are always excellent. Thank you for that.
Thanks for your kind words.
THX, but what if in my country Monday is first day and I'd like to show data in that order?
Hi That can be achieved as following by creating a new column and using following DAX command. Hope it helps. For Monday as start of week MondayStart = WEEKDAY('Table'[Admit Date] ,2) For Tuesday as start of week TuesdayStart = WEEKDAY('Table'[Admit Date] ,3) For Saturday as start of week. The options above are only 1, 2 or 3 so to make Saturday as start of week. SaturdayStart = IF(WEEKDAY('Table'[Admit Date], 1) = 7, 1, WEEKDAY('Table'[Admit Date], 1) + 1) All the best.
@@DataAnalytic thanks a lot!!! I wait for next videos 😊
Thank you for your kind words.
Great to see another tutorial from you sir... Its been a while you unloaded contents. Trust you are doing great over there and your loved ones? Thanks a million for the previous contents _ they indeed gave me good directions in my journey of using R.
So thankful for your kind words!
It is a video which i am also looking for but the font is extremely blurred. Will ne very helpful if you could share the formula in a bigger and clear font. Thanks in advance
Hello there, I will ensure that the DAX formulii are zoomed in. Here is the code AgeGroup = SWITCH( TRUE, ISBLANK(AGES[Customer Age]), "Unknown", AGES[Customer Age] <= 4, "0-4 yrs", AGES[Customer Age] <= 9, "5-9 yrs", AGES[Customer Age] <= 14, "10-14 yrs", AGES[Customer Age] <= 19, "15-19 yrs", AGES[Customer Age] <= 24, "20-24 yrs", AGES[Customer Age] <= 29, "25-29 yrs", AGES[Customer Age] <= 34, "30-34 yrs", AGES[Customer Age] <= 39, "35-39 yrs", AGES[Customer Age] <= 44, "40-44 yrs", AGES[Customer Age] <= 49, "45-49 yrs", AGES[Customer Age] <= 54, "50-54 yrs", AGES[Customer Age] <= 59, "55-59 yrs", AGES[Customer Age] <= 64, "60-64 yrs", AGES[Customer Age] <= 69, "65-69 yrs", AGES[Customer Age] <= 74, "70-74 yrs", AGES[Customer Age] <= 79, "75-79 yrs", AGES[Customer Age] <= 84, "80-84 yrs", AGES[Customer Age] > 84, "85+ yrs" )
Thanks a lot! Appreciated
Sir do you conduct classes on r studio?
Hi, happy to create more information videos on the topics you would like to suggest.
Sir, It is a very informative and wonderful video. Thank you very much for considering my request. I hope your good self will create more informative videoes in the future 🙏
Thanks and welcome
Great video. What was the procedure for getting the entire list of base r colours to change colour?
Hi, to see the entire lists of colors simpy type the command colors()
@@DataAnalytic Thanks. I meant getting the list of colour names from the colour() function output to then change colour?
Hi Not sure if I got the question right. But I will try to give you a generic answer and hope that it covers what you wanted to ask... 1. Type the colours() command and it gives you a list of all the colours listed in the terminal window. 2. Copy all these values from tthe terminal window and copy them in your script and then you are able to see the actual colours also, which makes it easy to choose the colour which you want. 3. In order to use the colours you have two choices, eg. if you want all the points to be of the same colour then you can set the colour outside the aesthetics. If you want the colour to be different based on some other grouping then give the colour command within the aesthetics eg . aes (colour = gender), this was each gender will get different colour. and then you can have another line to specify the colours eg. scale_colour_manual(values = c('red', 'blue')) Hope this is what you initially wanted to ask. Let me know if I haven't been able to answer you question. All the best.
@@DataAnalytic Thankyou very much for the detailed reply. That's exactly what I was after (and more). Cheers
Can we do the same in python
Hi , I haven't tried it myself but try this outt pypi.org/project/fuzzywuzzy/
please share the dataset file in discription
Hi The dataset is generated by code and it is available at rpubs.com/techanswers88/913784 Hope it helps. All the best.
Is it still work the same if I simplyfy the code as: ``` data |> ggplot(aes(x = date)) + geom_line(aes(y = patients)) + geom_point(aes(y = patients)) + geom_line(aes(y = death)) + geom-point(aes(y = death)) + Theme_classic() ``` Without the clutter p1 every new lines 😊
Hi Yes, it will work perfectly, this syntax is short and lot of people prefer this style. Pros Easier to write, quick, less typing Cons If you have a complex code then it is hard to read, I use the pl <- pl + geom_classic() like syntax, If I have 30 charts in a report then I can easily search for it and comment it or modify it easily. Hope it helps. All the best.
Very useful video!
Glad it was helpful!
hi, I have a problem when I want to run the following code to have a boxplot: boxplot(data_ind$Na~data_ind$Stations, range = 1.5, width = NULL, varwidth = FALSE, notch = FALSE, col = c("blue","red","orange","gray"), xlab = "", ylab = "Na %",) the following message appears: Error in plot.new() : figure margins too large. and the drawing does not appear the range of the variable Na% from 17.39 to 43.02
Hello You are not using the GGPLOT boxplot you are using the BASE R to plot your chart. You can try to use the dev.off() command to see if it works for you. Check the margings using this command par("mar") set the margins by the following command par(mar=c(1,1,1,1)) Here is an example library(tibble) data <- tribble(~ Gender, ~ Age , 'Male' , 80 , 'Male' , 40 , 'Male' , 60 , 'Male' , 70 , 'Female' , 80 , 'Female' , 30 , 'Female' , 40 , 'Female' , 50 , 'Female' , 60 , 'Female' , 70 , 'Female' , 150 ) dev.off() par(mar=c(1,1,1,1)) boxplot(formula = Age ~ Gender, data = data, col = c("red","blue"), xlab = "Patient Gender", ylab = "Patient Age") Hope it works for you.
@@DataAnalytic thanks
One of the best tutorials ever. Thanks a bunch!
Glad you think so!
Good morning Sir, I have analysed 750 soil samples for soil acidity in the state of Manipur, India. So, how can I develop the same maps in ggplot for my data. Kindly teach me
Hello, yes I assume that you have taken soil samples for tested for the soil acidity for Manipur, 750 locations is a good number, I will try to do a mockup.
@@DataAnalyticSir could you share your email id with me?
Hi, I have prepared a demo for you to plot Manipur Chart and I will soon upload it. th-cam.com/video/jvpRKndh5RA/w-d-xo.html
Sir, thank you I'm eagarly waiting
Hi, thanks for your patience, I have create a video for Manipur District Map with data points.
excellent video, thank you so much!
You're very welcome!
@@DataAnalytic from Barranquilla, Colombia 🙏❤️🇨🇴
Thank you. I have two datasets: case (d1) and control (d2). Both d1 (n=226) and d2 (n-=219) have unique persons per observation. I want to fuzzy_left_join matching d2 to d1 on gender (M/F), and age_in_months (lowage and highage based on +/- 6 months). Your tutorial worked, but my joined had n=3067 observations because multiple d2 meet the match criteria of gender and age range for every d1 observation. My problem: in the djoined of n=3067, if I remove duplicated d1 records and downsize to n=226, some unique records from d2 will be dropped and not represented. My request: how do I retain only (n=226) d1 observations, while maximizing the number of d2 matched without duplication? Thank you.
Hi, thanks for explaining your question very clearly. As you have a control dataset and a case dataset and one person will only appear in either the control or the case dataset, so you would not have a unique person ID to join the data. In your case you are joining the gender and the age range, is it possible to pick some other key which can help you ? The same record from d1 is joined to multiple rows in d2. Another way is to only take the first value in each group, so you group your joined dataset by gender, agegroup and pick the top1 using slice(1). Without looking at the data, I can only give generic advice which may not fit in your exact circumstances. If you are able to make some dummy data then put the code here, then I can give it a further try.
Thank you for this. But how can you interact with the chart that you created in R? Instead of clicking the Power BI chart, but rather clicking the R chart?
Hi the R charts reflect the changes in other POWERBI components, in the video it shows that when we select a particular product in a PowerBI chart then the R chart also get changed to reflect the selected product. But there are no controls within the R Chart to interact directly.
no music, please
Hi, yes I agree, it is one of the older videos, we do not use background music at all now!
Thank you !!
Thanks
i tried running the gtsummary package and it shows errors because my variables are factors. So, I guess y9ou need to mention what type of variables work for the gtsummary cross tabs
Nice video! . I got a question, how can I use data with NA values ? .
Try filling the NAs with a string like 'Not Available' or 'Blank', but be aware that the NAs might be at each node level, so do this write at the start.
How do you fix the distortion of the hexagons? (i.e., AK and HI). They are not all uniform at the end.
Hi, in this example the hexagons are controlled by the shape file, hence can't be changed to make them uniform. There are other methods which can achieve uniform size for the hexagons, as in that method the hexagons are not in the shape file but generated programatically. But the second method does not ensure that you would get one hexagon for each state.
Thanks, brother, exactly on what I been searching
Glad to hear it
Hi!!!! excellent!!! but for work again with R?
Open an existing R script or open a new R Script page and you can start working in R.