วีดีโอ

Thank you Gurdip Singh for your feedback . I will check this part and get back to you. Please give me a day or two

It's Done Now....you have option to filter Date, Numeric and String Link for the Improved VBA - Excel Macro: th-cam.com/video/4EQh3_DwQXY/w-d-xo.html

@@happylearning-gp Thank you for the coding. Now it is working for me. Cheers

Thank you very much. It’s encouraging

Thank you sincerely for taking the time to watch my video and for subscribing to my channel. I appreciate your interest in the dynamic filter featured in the video. As you may have noticed, this filter operates without a conventional action button, making it challenging to retain previous filter details. However, I understand that you have specific requirements. If you could kindly elucidate them and provide minimal data, please email me at happylearninggp@gmail.com. I'm committed to finding a solution tailored to your needs. Once again, I deeply appreciate your support and engagement. Thank you.

Thanks Raouf for your feedback. Very much appreciated and it’s an encouragement to me. Please watch two more videos on excel macro to make multiple filters

Thank you very much for your feedback. I will make an rmarkdown explaining every step and upload and confirm to you

Happy New Year. I have uploaded a word file in this Github. please download and review. I have explained step by step with code. github.com/ganapap1/Dynamic_Filter_Revised further I have a revised shiny app for this Dynamic filter. you can get rscript in the same folder in Github. Email me if you need any clarification happylearninggp@gmail.com

Thank you very much for your feedback. It's encouraging. If you need anything to automate or any specific requirement, please add it in comments. Thank you

I will check this option, whether we can use semicolon for multiple criteria. I will get back to you

Hi I have uploaded a separate video on filtering single column with multiple criteria. here is the video link: th-cam.com/video/4wifaBm930I/w-d-xo.html Kindly watch and give me your valuable feedback. Thanks

I appreciate for taking your time. If you need something different in Macro please add your requirements in the comments section

Thank you for taking time to review. Let me check for loading more than one dataset, should have a provision to add columns if not in first dataset. Is that are you looking for. Or you want to merging columns for matching the unique ID column

@@happylearning-gp I have done the merging for multiple files in the app, it is not too difficult but quite frequently used in my day to day work. In my app, two files can be merged based on multiple variables that I selected

@@yiyuanzhang6335 , I have updated the app with the provision to upload multiple files. latest version of the app is in the github.com/ganapap1/Exploration_Cleansing.git you can also run the app in R Console without downloading from github. here is the script shiny::runGitHub(repo = "ganapap1/Exploration_Cleansing",username = "ganapap1") If the one which you have created is more user friendly, could you please share the approach and just relevant part of the code in Github and share the link please

Thank you very much for addressing your requirements. The code at the end of the script as given below saves kbl table as html with full formatting. *continuation of the code...............* add_header_above(c(" ", "High Level Group" = mtopGroup),font_size = 15,background ='#8e0000',color='#ffffff') %>% save_kable(file = "table1.html", self_contained = T) I have uploaded an output in Github. please download and see this link for table1.html github.com/ganapap1/kableExtra-Package-in-R Please add little more details, if it does not meet your requirements

@@happylearning-gp Thanks so much! That was exactly what I needed!

@@forza1sra Excellent that it meets your requirements

Thank you very much. Please add in comments, if you want me to take up any specific concept or topic in my next video

Thank you very much

Thank you very much. Yes , it has taken a considerable amount of time. Has come out more than I expected

Great stuff, so how do I get this app

@@nickread595, Thank you very much for taking your time to review. There is a link in the Video description, you can download the app as rscript from Github. com and run it on your RStudio

@@nickread595 Thank you very much for taking your time to review. There is a link in the Video description, you can download the app as rscript from Github. com and run it on your RStudio

Thanks a lot, please creat new topic or query in Rstudio forum, with specific addressed to me @ganapap1 And I will get the message and attend immediately

Email happylearninggp@gmail.com Please email you queries. I have created a new email account

Thank you very much for sharing your comments. If you need video on any specific topic in statistics using R, kindly put it in the comments, I will do my best.

Thank you very much Ahmad for your feedback. I will check those options as well. Good Day

Hi Good Morning, Sorry for the delayed response. here is the link to download. May not be exactly same data, but columns will be same. community.tableau.com/s/question/0D54T00000CWeX8SAL/sample-superstore-sales-excelxls

Thankyou @@happylearning-gp Sir

Thank you for the support

Thank you! Cheers!

Thank you so much. I really appreciate for taking your time. Similar one I have for ggplot2. You may like it

Thank you for the heads up. please look at line 20 in the code where you have myfile <- 'C:/Users/pc/Documents/ArrestsNew.csv' kindly change the directory suitably to link any CSV file on your laptop. sorry for not being clear in the video.

Hope you resolved it now.

@@happylearning-gp i had issue with the server deployed app and wanted a scheduled run the script, but thank you.

@@modithhadya3204 how to solve your problem?

@@modithhadya3204 did you solve the problem? if so how ? I have a problem updating the database once the app is deployed

Most welcome. It's my pleasure

Normally I don't explain the code in my video. However codes have suitable headings and arranged step by step. Are you able to follow that or Should I make any improvement on coding presentation side.

@@happylearning-gp so far i can understand your coding sir. I will inform you if I got a problem with the coding later :)

@@nurinsyirah7847 thank you

@@happylearning-gp hi sir, do you have an email? i have several question to ask about my project.

Yes possible, I will update you by tomorrow 13th Jan

@@happylearning-gp Noted. Thank you sir

Hi, I have uploaded the revised video and R script with multiple dynamic plots - Box Plot, Bar Plot, Histogram, QQ Plot, Density Plot, and Correlation Pair-Panel Plot. Link: th-cam.com/video/jO0yWXOwVCE/w-d-xo.html

Sorry, that you are facing an error. The majority of the recommendations on the net ask us to restart Rstudio and try to use Tools >> package and enter the package name and install. kindly try. If still, it does not work, please check your version of R and update if required. I found another strange suggestion that is asking us to install randomly a package eg ggplot2 and then try (please try this option also after you restart Rstudio) kindly get back to me. Thank you very much. Hope it gets resolved.

@@happylearning-gp Sir, I try to restart and install by using Tools >> Package and its works! Thank you so much sir :D

@@nurinsyirah7847 Wow. That's Great. Please watch my other videos on R Shiny App, on Data Science and Statistics. All my apps can be applied directly to any industry without any modification

@@happylearning-gp Sure sir! Thank you so much

@@happylearning-gp Hi sir, can we change the orange column colour?

Thank you very much for your feedback. I will organize one on auto update data

I have published a video on Auto Update Data for Shiny App. Thank you very much for proposing this rare topic

Thank you very much for your feedback. I will organize one on auto update data

Thank you very much for your feedback. I will organize one on auto update data

Thank you for letting me know. I have uploaded a fresh file on Github.com. github.com/ganapap1/Correlation_Analysis

I appreciate the time you took to share your feedback. Great motivation for me. Thank you very much

Thank you so much Trisha. Sure, I will organise.

Linear Regression part 1 of 2 is available in my channel th-cam.com/video/yqLqZ0s54RI/w-d-xo.html

Thank you so much