At 33:45 I would like to share a simple Excel formula SUMIFS. We can use it after removing duplicates in document id and placing list of term id in horizontal. I had 313 terms and 448 documents. For me this formula in the cell corresponding to term 1 and document 1 is like " =SUMIFS($C$2:$C$4554,$A$2:$A$4554,$F2,$B$2:$B$4554,G$1) ". Those who are new to this formula may need to spent a few minutes to understand and practice it however, the spent in learning worth it. As after correctly writing this formula in one cell the rest you have to do it to drag it horizontally an vertically to complete the matrix in less then a minute.
Sir, please explain frequency column because it is not downloaded from vosviewer from text analysis, then from where it has come, I am listening your video again and again but not getting
attending the whole workshop since the very start of it till the end mentioned about the attendence sheet or google form whatever was being circulated but no one shared anything, was there since it started till it ended. this is really very disappointing, even after making efforts to ask about it again and again no one shared the form..whts the use of attending any workshop if there is no certifcate i would like to complain about it if doctor , sir reads it i need my certificate how can we fill the form if even after asking 100 times no one shares it or tells whats the procedure for it?
@@CONNECTINGASIATV sir , this is to inform you that i have still not received the certificate for attending this webinar. i please request you to look into this matter.
Hello sir! Thank you so much for this excellent video!. Really useful. I had a doubt as to how we get the term frequency for each document after exporting from Vos viewer. I am only able to get the total occurrence of words and not the split in each document. (time 29.57 in the video) It would be great if you could throw some light.
Good Evening sir, I'm Rafi, ph.d Scholar in Agriculture Economics. I have seen all your videos regarding systematic review using VOS viewer. In this session, there is difficulty in understanding the term I'd ,document I'd (the values extracted from VOS viewer and the values in your Excel sheet is differing). I would like to have any base article regarding the procedure of doing PCA data extracted from VOS viewer using any data base. ( please help me sir in this regard, if any article showing methodology how to perform advance statics using VOS viewer other than descriptive statistics will be useful )
Good evening sir I also want to join the workshop but i don't know how to join it . I want to join the online courses also. The lecture is so much informative
I solved the problem of frequency. In order to have a frequency column, at the beginning after "create a map", you should choose"create a map based on BIBLIOGRAPHIC data", then read data from your bibliographic database, then choose your document, then check the "co-occurrence" and "all keywords". And voile! You have a frequency column when extracting a data UPD: sorry guys. What I described is for keywords, not terms. So, I do not know how to help :(
Good Evening sir, I'm Rafi, ph.d Scholar in Agriculture Economics. I have seen all your videos regarding systematic review using VOS viewer. In this session, there is difficulty in understanding the term I'd ,document I'd (the values extracted from VOS viewer and the values in your Excel sheet is differing). I would like to have any base article regarding the procedure of doing PCA data extracted from VOS viewer using any data base. ( please help me sir in this regard, if any article showing methodology how to perform advance statics using VOS viewer other than descriptive statistics will be useful ) Thanks sir
Sir, please explain frequency column because it is not downloaded from vosviewer from text analysis, then from where it has come, I am listening your video again and again but not getting
At 33:45 I would like to share a simple Excel formula SUMIFS. We can use it after removing duplicates in document id and placing list of term id in horizontal. I had 313 terms and 448 documents. For me this formula in the cell corresponding to term 1 and document 1 is like " =SUMIFS($C$2:$C$4554,$A$2:$A$4554,$F2,$B$2:$B$4554,G$1) ". Those who are new to this formula may need to spent a few minutes to understand and practice it however, the spent in learning worth it. As after correctly writing this formula in one cell the rest you have to do it to drag it horizontally an vertically to complete the matrix in less then a minute.
Ahmed Bilal your contact source, please
how to calculate frequency as it does not come in vos viewer document ?
Sir, please explain frequency column because it is not downloaded from vosviewer from text analysis, then from where it has come, I am listening your video again and again but not getting
Hello! Were you able to solve your problem?
During the making of VoS analysis, choose 'Full counting' instead of 'Binary counting'. Doing so will get you 'frequency' as well.
Sir, how the frequency is calcualted by your
How are the frequency of term words in each document obtained?
Sir please let us know how you have found frequency after term ID and document ID?
Sir, kindly do workshop
How i an register for online certification.course?
what will be the fee for the course?
can you guide me?
regards
attending the whole workshop
since the very start of it till the end mentioned about the attendence sheet or google form whatever was being circulated but no one shared anything, was there since it started till it ended.
this is really very disappointing, even after making efforts to ask about it again and again no one shared the form..whts the use of attending any workshop if there is no certifcate
i would like to complain about it if doctor , sir reads it
i need my certificate
how can we fill the form if even after asking 100 times no one shares it or tells whats the procedure for it?
forms.gle/PTZWjkEmJMdn8ZdB6
@@CONNECTINGASIATV thankyou so much sir, finally
thanks a ton
have filled it
@@CONNECTINGASIATV as of now have not received the certificate , so waiting for it
@@CONNECTINGASIATV sir , have u mailed the certificate , because i didn' t get the mail yet
@@CONNECTINGASIATV sir , this is to inform you that i have still not received the certificate for attending this webinar. i please request you to look into this matter.
Thank Prof, for your sharing.
Hello sir! Thank you so much for this excellent video!. Really useful. I had a doubt as to how we get the term frequency for each document after exporting from Vos viewer. I am only able to get the total occurrence of words and not the split in each document. (time 29.57 in the video) It would be great if you could throw some light.
Yes, the same problem. I cannot find how to figure out the frequency of the occurence in each article. Did you solve it?
During the making of VoS analysis, choose 'Full counting' instead of 'Binary counting'. Doing so will get you 'frequency' as well.
hai, can u help me,how to find the frequency?which one in the slides? i couldn't cope it
Were you able to get answer? If yes, please share with me also
During the making of VoS analysis, choose 'Full counting' instead of 'Binary counting'. Doing so will get you 'frequency' as well.
Your sessions are always awesome. Thanks indeed
Nice and clear presentation! In which database "Systematic Literature Review and Meta-Analysis Journal" indexed?
Dear Prof., will you open for Phd opportunity under your supervision?
Yes, learnt a lot 👍👍👍
Thank you very much 🙏🙏🙏
Good Evening sir,
I'm Rafi, ph.d Scholar in Agriculture Economics. I have seen all your videos regarding systematic review using VOS viewer.
In this session, there is difficulty in understanding the term I'd ,document I'd (the values extracted from VOS viewer and the values in your Excel sheet is differing).
I would like to have any base article regarding the procedure of doing PCA data extracted from VOS viewer using any data base. ( please help me sir in this regard, if any article showing methodology how to perform advance statics using VOS viewer other than descriptive statistics will be useful )
Thanks for your great efforts
Very informative sessions sir.
Very informative session. Thank you Sir
Sir which is link for part 3?
Hi anuradha....if you want participate in MG Central University seminar on 25 June....if you need any help call me on 9616505066
Very educative. Thanks sir
Hello sir I want to get training
just finished last video of bibliometrics.
Thank you sir, learned a lot, please help me with the link to Systematic Literature Review 3
Sir when u will cover meta analysis?
Good evening sir I also want to join the workshop but i don't know how to join it . I want to join the online courses also. The lecture is so much informative
Great Sir
FEEDBACK FORM LINK PLEASE
Thank You Sir for this fruitful session. Would you discuss on how to find research gap???
Nyc
Excellent
Thank you
thanks sir
Clear 👍
I solved the problem of frequency. In order to have a frequency column, at the beginning after "create a map", you should choose"create a map based on BIBLIOGRAPHIC data", then read data from your bibliographic database, then choose your document, then check the "co-occurrence" and "all keywords". And voile! You have a frequency column when extracting a data
UPD: sorry guys. What I described is for keywords, not terms. So, I do not know how to help :(
During the making of VoS analysis, choose 'Full counting' instead of 'Binary counting'. Doing so will get you 'frequency' as well.
nice appraoch
😮😮😮
W.Salam Sir ❤
Good Evening sir,
I'm Rafi, ph.d Scholar in Agriculture Economics. I have seen all your videos regarding systematic review using VOS viewer.
In this session, there is difficulty in understanding the term I'd ,document I'd (the values extracted from VOS viewer and the values in your Excel sheet is differing).
I would like to have any base article regarding the procedure of doing PCA data extracted from VOS viewer using any data base. ( please help me sir in this regard, if any article showing methodology how to perform advance statics using VOS viewer other than descriptive statistics will be useful )
Thanks sir
Attendance forms.gle/PTZWjkEmJMdn8ZdB6
the term Id is different in the Excel sheet from the extracted data, please could you help me how to find the term id
Sir, please explain frequency column because it is not downloaded from vosviewer from text analysis, then from where it has come, I am listening your video again and again but not getting
watch the video th-cam.com/video/DZ2eoD9cMSI/w-d-xo.html
Hi! Were you able to solve this problem?
During the making of VoS analysis, choose 'Full counting' instead of 'Binary counting'. Doing so will get you 'frequency' as well.
@@Лейла-ж7е During the making of VoS analysis, choose 'Full counting' instead of 'Binary counting'. Doing so will get you 'frequency' as well.
Clear 👍