Calculating SPI index using R studio | Video Tutorial

[@nezarhammouri2032]

Thank you for your great video. Since you have a daily data and you need to convert these to monthly data, you should use SUM function within PivotTable and not average.

[@theteddychannel2770]

Yes thank you so much. I was looking everywhere to check that. 😊

[@ritujhalani2890]

@@theteddychannel2770 Please confirm. its sum or average?

[@theteddychannel2770]

@@ritujhalani2890 Sum them up 🙂. although the results wouldnt be different in both the cases

[@ritujhalani2890]

@@theteddychannel2770 Thanx

[@chandrakantkadam1953]

I have 109 stations, for which I have daily precipitation values. Please tell me how to prepare data from this for SPI ??

[@sanjeewaillangasingha5212]

HI Thank you very much for your useful video. I noticed that there is some difference when you were calculating the monthly rainfall values here. I think it should be a monthly rainfall value, not a monthly daily average value. Each monthly value represents the total rainfall amount for that particular month. If possible please check. Thank you so much

[@mashiwanigasuriya1212]

thanks a lot.🥰🥰🥰...wow wow😍 very interesting and useful video🥰

[@asmarebelay1851]

Great work, Continue this valuable jobs !

[@danielgeletaw300]

Great explanation. But it is better if we use monthly data which are the sum of daily data. my question is how the month display in your Rstudio result as Jan, Feb...

[@layatielhoucein9063]

hello I like your video, I would like to modify your Excel because my chronicle 1984-2021 but it gives me Error when I pass 2017

[@nguyenhoangphi5026]

Why does the SPI index result not show the month but only the values ​​of 5 columns?

[@albertocarlosmatsinhe5505]

Good morning, I ask for your help, not the PROCH function, how does the 1978 appear?

[@zubairusman57]

Very useful video and the Excel file sheet! Please, if you prepared a different kind Excel sheet for SPEI, kindly share with us.

[@Hydro-SolutionTube]

Sir,which version of R studio you are using?

[@mohammedkareem6476]

Thank you so much great video We wish to make videos about: 1 How do you calculate the Palmer Drought Index? 2 How do you calculate climate extremes? Thank you so much

[@mustafapipaliya]

@Red Fish I got a REF error from 2018 to 2020? what to do for that.

[@nguyenhoangphi5026]

Please help me, I do everything like the video but R responds like this: "Calculating the Standardized Precipitation Evapotranspiration Index (SPEI) at a time scale of 3. Using kernel type 'rectangular', with 0 shift. Fitting the data to a Gamma distribution. Using the ub-pwm parameter fitting method. Checking for missing values (`NA`): all the data must be complete. Using the whole time series as reference period. Input type is vector. No time information provided, assuming a monthly time series."

[@MohamadrezaHosseinianMoghadamN]

Hello. Why i can not see months in the result?

[@MrAslam2176]

How to change the study period in your file, would appreciate your quick response

[@ingridvivianamendozanieto7159]

Thank u so much, it was very useful.

[@harish_140]

bro how can we get plots in excel after adding data from R I'm getting spi values but below that I'm not getting year values how can I get years like 1975 , 1980 , 1985..... in plots

[@Jessica02581]

How can i get data from R to excel ?

[@soumago911]

please how can I modify the horizontal axis value, to use dates instead of numbers?

[@tadiwanashezhuwawo3901]

Thanks a lot this was very helpful. How do you then interpret the spi values ? do you like find the average spi value which you can use to draw conclusions?

[@ResNeeD1]

I support you for your good information

[@mahsumbozdogan7109]

Hi. I get this warning when I type the formula spi3

[@badygo338]

Please! How to solve #REF! when editing?Why 1978 -A in the table?

[@harish_140]

it's really great and can u please explain how can i calculate SPI for multiple stations , actually i'm having many stations for one district, how can i consider all stations ? means is it necessary to do for every station ?

[@qianhe6963]

Have you figured out how to calculate for multiple staions?

[@jeunesentialaura3372]

Hello. How can you help me? I don't find months on mine.

[@chandrakantkadam1953]

I have 109 stations, for which I have daily precipitation values. Please tell me how to prepare data from this for SPI ??

[@ritujhalani2890]

Is that necessary to use all monthly rainfall data in excel sheet or I can take 5 months data (may- September)

[@prakasamm3650]

Thank you very much for your video on SPI. But, I have a question, that how to add missing values.

[@alvinofadilah3146]

Hallo, can you help me process SPI data? I want to ask for an example of this processing in this excel

[@alex18216]

It was a really useful video. Thank you very much. How can we calculate SPI for multi-station precipitation data for a basin?I want to do spi analysis for multiple stations as R studio.

[@mohamedfomba1031]

Thank you very much for your interesting video. Please, I would like to know how did you set up the spei formulas in the different sheets to get the plots directly after adding data from R?

[@amelieu2734]

Hello, I got SPI values but there are no months included along the values. How can i fix it?

[@yusufsidikarasuwa241]

Hello, have you figure out this problem? I am having the same issue please

[@amelieu2734]

@@yusufsidikarasuwa241 Still not yet but i believe it is in the coding of the upper left console, in his "Untitled7". We have to set values for it to display the months

[@feyeneregassa1921]

Thank you it's so supportive video.

[@temesgenfekadie519]

you makes a good video ...thank you ..!! what about Combined drought index (by using PDI, TDI, NDVI)INDEX how can i get it ??

[@mustafapipaliya]

thanks for this amazing explanation

[@annamarijafirere8040]

Why did it show NA for January and February?

[@cornishpixie4989]

Because SPI-3 is accumulation period of three months. Hence, the data for the first year starts from March.

[@Avisolu]

Lovely video, i wish u could please remove music in the future

[@MohamadrezaHosseinianMoghadamN]

Hello. Why i can not see months in the result?

[@MohamadrezaHosseinianMoghadamN]

Hello. Why i can not see months in the result?

[@MohamadrezaHosseinianMoghadamN]

Hello. Why i can not see months in the result?