Working With SQL Databases From R: Introduction & Connecting To Databases
The portal.sqlite file can be downloaded here: ndownloader.figshare.com/file...
Notes on how to create a file like this from CSV files are available here: datacarpentry.org/semester-bi...
Пікірлер: 36
This video answered all my questions , great instructor
@weecology
2 жыл бұрын
Thanks!
Thank you for making it simple to understand.
Muito Obrigada por este vídeo! Simples e fácil! Parabéns!
Great video!! It will be great to make the 1st step as how to prepare the portal.sqlite
@weecology
2 жыл бұрын
Glad it's helpful. I added a link to download that file and another link describing how to create one in the video description. Let me know if you need anything else.
Thanks so much for your video, your expplaining way is very easy even for a brazilian person, great teaching method.
@weecology
Жыл бұрын
Glad it was helpful!
thanks for the introduction!
@weecology
2 жыл бұрын
You're welcome!
such easy way of teaching ,your teaching skills amazed me understanding such difficult thing easier. thank you so much
@weecology
Жыл бұрын
Thanks! I so glad it is helpful!
On point. Thanks!
@weecology
2 жыл бұрын
You're welcome!
great video, thank you!
@weecology
Жыл бұрын
Thanks!
Great video Thanks!
@weecology
2 жыл бұрын
You're welcome!
if i have a superstore CSV file and I want to select max sales where Region should be South/East/west/North with Order dates b/w (i.e:- 01-02-2019 to 01-01-2021).
thank you for the tutorial!
@weecology
2 жыл бұрын
you're welcome!
Creating SQL Database connection using connection panel in RStudio?
Do you have the video that connects to MySQL Workbench? I saw the database from MySQL Workbench on the "Connections' pane but when I use 'dbListTables (dbname), it says this: Error in h(simpleError(msg, call)) : error in evaluating the argument 'conn' in selecting a method for function 'dbListTables': object 'spear' not found
@weecology
Жыл бұрын
I don’t. Sorry. It’s been a few years since I worked with MySQL.
Nice ASMR, bro.
Hello. Could you, please, put numbers on the videos? I am not sure which video to go to after watching a video. Great teaching by the way.
@weecology
9 ай бұрын
Thanks! The quickest way to give you an answer is that the order is the same as in this playlist kzread.info/head/PLD8eCxFKntVH5EJmTBaZXWaU8cM_T9Lfl The Working with SQL Databases is all the way down at the bottom of the playlist. Hope that helps!
@weecology
9 ай бұрын
And I just added a playlist with just the Working with SQL Databases from R in the right order for you as well: kzread.info/head/PLD8eCxFKntVG4WztMnn3khib9v7TTgPTT
What do you mean "path to database file"?
@weecology
Жыл бұрын
The location of the database file on your computer. We’ve got a video on paths that might be useful in figuring out how to write this kzread.info/dash/bejne/ZKeGx6-mhLC_ds4.html
what if I'm using SSMS?
@weecology
Жыл бұрын
To connect to SQL Server you’ll need to use the ODBC package. There’s a brief introduction here solutions.posit.co/connections/db/getting-started/connect-to-database/ Hope it helps!
Getting character(0) when I show tables. Do you know how to fix this? :/
@weecology
6 ай бұрын
If this is happening when using dbListTables this probably means you didn’t connect to our database file and so R created an empty one. Check that you’ve downloaded the file linked in the description, that it is in your working directory, and that the name when you run dbConnect() matches the file name exactly (including the file extension)
@stephensaucedo2746
6 ай бұрын
Hello thank you for your help. The tables are now showing, but now I have a new error. When I reference a table it says object not found. Do you know why this is happening? The tables were working fine at first but I had to close and reopen R and that is when the problem arose.@@weecology
@weecology
6 ай бұрын
@stephensaucedo2746 since you restarted R you’ll need to rerun all of the code to recreate the connection to the database