Відео

Can I also Visual Studio 2019 instead of VS Code?

nice

00:00 - introduction 01:13 - downloading stock data 07:13 - converting daily prices to monthly prices 09:00 - converting to tibble 10:38 - creating gt table 11:18 - styling the table 13:53 - using Markdown syntax to format title and subtitle 18:00 - adding footnotes for the min and max prices 20:38 - adding a source note 22:38 - formatting the currency column 24:25 - changing text alignment 25:13 - coloring the values

hi thanks for explain can you share 🤓 the code

excellent work

Your duckdb series is amazing, thanks for sharing your knowledge 😊

Awesome video

Thanks for the video

Nice explanation

Unfortunately, this still doesn't fix my problem. The GUI font (letters) is still too small for me. When I do this what you presented, it does increase the font, but everything is so blurry. Any other fix?

thanks

you are the MAN

I ran into a problem. When I render pdf files, the function tab_options(table.width = pct()" can only be used once. If more than once, I got the error as follow. No problem with HTML files. ERROR: compilation failed- error LaTeX Error: Command \holdLTleft already defined. Or name \end... illegal, see p.192 of the manual. See the LaTeX manual or LaTeX Companion for explanation. Type H <return> for immediate help. ... l.336 ewlength\holdLTleft ewlength\holdLTright\setlength\holdLTleft{\LTle... see table.log for more information.

Thank you sir! :)

The github link for the codes is not working. Can you repost the codes?

Thank you very much for this video! I am just on the way of combining HTML and Py in Jupyter

Hi and great video! I watched your Excel 365 YF addin first since that it was i was looking for. I am new to Excel 365 and a little disappointed with it's STOCKHISTORY function reliability. So I am looking for a data solution. Are you using Python to build a database to then have Excel view it or some other viewing platform? Either way it would be great to see how you view the data?

Just remember the R native pipe has some limitations compared to the magrittr pipe

Hi， could you please show in pdf file and reveals file in quarto? Thanks.

This is a fantastic tutorial. These are really vexing issues for those starting out and showing how to assert control in a clear way like this is extremely helpful. Kudos.

Dude you have great tutorials but you could cut in half, even more, the time. No need to explain the base R pipe or how to install R

This video went from 0 to 100 very quickly, hahahaha. I barely work with python code, but I certainly will try some of the things you suggest. Great vid.

Great video, thanks

Thanks for solving man. U deserve a million views

thank you. found it informative

Thanks. The source code link does not work.

Fnu, you could very well use the partition by Ticker and then order by date. Either way you most likely would end up at the same place. You are right, it is probably more correct to first partition and then order by. Thanks for the comment! Well spottet😅

At 16:38 , should it be partition by ticker order by date instead or order by ticker,date ?

"promo sm" 🎶

I unzipped the folder then imported the .sln to Visual Studio then build, but it failed. Tried to use on personal computer.

I hope not to be too rude my friend but I came to see a video about sql, not about how to do geoprocesses in qgis, what time do we get to the damn wkt?

[̲̅p][̲̅r][̲̅o][̲̅m][̲̅o][̲̅s][̲̅m]

Slick setup. Well done.

Thanks so much for your content! It has been hard to find out how to use spatial data in c# with sql server and NTS.

hello, excellent video, I'm having problem creating the spatial index, in a query that compares 1 point out of 7millions of another table, I could help, I saw that you stopped part 1 well in explaining the indexes.. thank you

Hi Torbjorn, I was able to obtain the queries from the json. But, after configuring all the settings in SQL Server and running the query inside SQL. I get the following message. Do you know what could be happening? Or What should I review? Msg 39004, Level 16, State 20, Line 36 A 'R' script error occurred during execution of 'sp_execute_external_script' with HRESULT 0x80004004. Msg 39019, Level 16, State 2, Line 36 An external script error occurred: Loading required package: xts Loading required package: zoo Attaching package: 'zoo' The following objects are masked from 'package:base': as.Date, as.Date.numeric Attaching package: 'PerformanceAnalytics' The following object is masked from 'package:graphics': legend Loading required package: lubridate Attaching package: 'lubridate' The following object is masked from 'package:base': date Loading required package: quantmod Loading required package: TTR Version 0.4-0 included new data defaults. See ?getSymbols. Loading required package: tidyverse ── Attaching packages ─────────────────────────────────────── tidyverse 1.2.1 ── ✔ ggplot2 3.1.0 ✔ purrr 0.3.0 ✔ tibble 2.0.1 ✔ dplyr 0.7.8 ✔ tidyr 0.8.2 ✔ stringr 1.3.1 ✔ readr 1.3.1 ✔ forcats 0.3.0 Msg 39019, Level 16, State 2, Line 36 An external script error occurred: ── Conflicts ──────���─────────────────────────────────── tidyverse_conflicts() ── ✖ lubridate::as.difftime() masks base::as.difftime() ✖ lubridate::date() masks base::date() ✖ dplyr::filter() masks stats::filter() ✖ dplyr::first() masks xts::first() ✖ lubridate::intersect() masks base::intersect() ✖ dplyr::lag() masks stats::lag() ✖ dplyr::last() masks xts::last() ✖ lubridate::setdiff() masks base::setdiff() ✖ lubridate::union() masks base::union() Error in bind_rows_(x, .id) : Argument 1 must have names Calls: source ... withVisible -> eval -> eval -> bind_rows -> bind_rows_ Adem�s: Warning messages: 1: x = '^GSPC', get = 'stock.prices': Error in curl::curl_download(cu, tmp, handle = h): Failed to connect to finance.yahoo.com port 443: Bad access Msg 39019, Level 16, State 2, Line 36 An external script error occurred: 2: x = 'ABT', get = 'stock.prices': Error in curl::curl_download(cu, tmp, handle = h): Failed to connect to finance.yahoo.com port 443: Bad access 3: x = 'ABBV', get = 'stock.prices': Error in curl::curl_download(cu, tmp, handle = h): Failed to connect to finance.yahoo.com port 443: Bad access 4: x = 'JNRFX', get = 'stock.prices': Error in curl::curl_download(cu, tmp, handle = h): Failed to connect to finance.yahoo.com port 443: Bad access 5: x = 'JNOSX', get = 'stock.prices': Error in curl::curl_download(cu, tmp, handle = h): Failed to connect to finance.yahoo.com port 443: Bad access 6: x = 'JANRX', get = 'stock.prices': Error in curl::curl_download(cu, tmp, handle = h): Failed to connect to finance.yahoo.com port 443: Bad access 7: x = 'JANIX', get = 'stock.prices': Error in curl::curl_download(cu, tmp, handle = h): Failed to connect to finance.yahoo.com port 443: Bad access Msg 39019, Level 16, State 2, Line 36 An external script error occurred: 8: x = 'JANWX', get = 'stock.prices': Error in curl::curl_download(cu, tmp, handle = h): Failed to connect to finance.yahoo.com port 443: Bad access Error in execution. Check the output for more information. Error in eval(ei, envir) : Error in execution. Check the output for more information. Calls: runScriptFile -> source -> withVisible -> eval -> eval -> .Call Ejecuci�n interrumpida The query that I tried is: DECLARE @rScript nvarchar(max) SET @rScript = N'library("PerformanceAnalytics") library("tidyquant") GSPC <- tq_get("^GSPC", get = "stock.prices", from = "2013-01-01") ABT <- tq_get("ABT", get = "stock.prices", from = "2013-01-01") ABBV <- tq_get("ABBV", get = "stock.prices", from = "2013-01-01") JNRFX <- tq_get("JNRFX", get = "stock.prices", from = "2013-01-01") JNOSX <- tq_get("JNOSX", get = "stock.prices", from = "2013-01-01") JANRX <- tq_get("JANRX", get = "stock.prices", from = "2013-01-01") JANIX <- tq_get("JANIX", get = "stock.prices", from = "2013-01-01") JANWX <- tq_get("JANWX", get = "stock.prices", from = "2013-01-01") data <- bind_rows("^GSPC" = GSPC, "ABT" = ABT, "ABBV" = ABBV, "JNRFX" = JNRFX, "JNOSX" = JNOSX, "JANRX" = JANRX, "JANIX" = JANIX, "JANWX" = JANWX, .id = "symbol") data$date <- as.character(data$date) OutputDataSet <- data; '; EXEC sp_execute_external_script @language = N'R', @script = @rScript --, --@output_data_1 = N'OutputDataSet' WITH RESULT SETS( ([symbol] nvarchar(50), [date]nvarchar(50), [open] Decimal(20,2), [high] Decimal(20,2), [low] Decimal(20,2), [close] Decimal(20,2), [volume] Decimal(20,0), [adjusted] Decimal(20,2)) ); GO

Hello Torjborn, Can you upload again the scripts that you're using in your tutorial? I enterd to the github branch where you have them and I get an error. Thanks. Great content!

What a great presentation. Thank you!

so you didnt do any image preprocessing?why not? what could have been done for this dataset?

PostgreSQL is better for geospatial data right? (Using postgis)

great code you have there! i am trying to run it atm but when running the learn.fit.one_cycle, the process gets Interrupted almost when finishing the first epoch. do you have any idea of what that might be? thanks

where is the part 2

Can you email me your slides