Mapping science using BiExcel and Pajek.ppt

mappingscienceusingbibexcelandpajekbyollepersson relations unitsofanalysis documentlevel aggregatedlevel authors universities countries journals citationbasedrelationes directcitations sharedreferences co citationsco occurrences co authorships co word citatbasedrelationsbetweendokuments a b c d acitesc directcitationaandcbothcitesb bibliograficcouplingaandcafreborthcitedbyd co citation similaritymeasures frequencies rawcounts nofdirectofcitations nofco occurences nofsharedreferencesnormalizedmeasures salton sindex jaccard sindex pearsonscorrelation mappingscience preparingdatacalculatingmeasuresmakingmapsgoodifyouhavesomeexperiencewithpajek youwilllearnthebasicsofbibexcelinthistutorial youwillneedthismaterial asetofdatahttp www8 umu se inforsk esss cocit569 tx2bibexcelsofwarehttp www8 umu se inforsk bibexcel bibexcel exepajekhttp vlado fmf uni lj si pub networks pajek readingmaterial1stchapterin http www8 umu se inforsk bibexcel ollepersson60 pdf preparingdata 1 converttodialogformat wehavealreadysearchedanddownloaded569recordsfromwebofscienceonco citationanalysisandwehavealreadyreplacedlinefeedswithcarriagereturninthedownloadedfileusingbibexcel editdoc file replacelinefeedwithcarriagereturnthefiletobeusediscocit569 tx2putbibexcel exeinc bibexcelandcoccit569 tx2inc bibexcel datastartbibexcel exe andnextwewillhavetoconverttodialogformatthatbibexcelisdesignedfor topic co citation orcocitation databases sci expanded ssci a hcitimespan allyears update2011 03 04 selectthecocit569 tx2fileandrunmisc converttodialogformat convertfromwebofscience youcanopenbibexcelandmakeallstepsinthispresentation selectcocit569 docandpressviewfile endoffield separatesunits endofrecord twoletterfieldtag 2 extractingdatafromcd field citeddocuments puttaghere unitsareseparatedbysemicolon let sstart cocit569 outhastheciteddocuments thisisthereferencelistofdocnr1 3 refiningtheout file toimprovedataqualitytheeditout filesmenuhasseveraloptions forexample youmaywishtoreducevariationbyonlyallowingthe1stinitialinauthornames selectcocit569 outandruneditout files keeponlyauthor sfirstinitial lookatcocit569 1standyoucanseethateomsbischangedtoeoms let simprovealittlebitmore selectcocit569 1standruneditoutfiles convertupperlowercase goodforcitedreferencestrings lookatcocit569 low ithinkthislooksmuchnicercomparedtotheout file calculatingdata 1 lookingatfrequencies selectcocit569 low tickhere choosewholestring pressstart lookatcocit569 citwhichhasthecitedreferencesindecreasingfrequency foranyonefamiliarwithco citationresearch thetop3papersshouldn tcomeasasurprise 2 makingco citations selectthecocit569 cit file pressviewfile inthelist markcitedreferencesdowntofrequency 30andthenpresscopy thenclearandthenpaste thesearethereferencesforwhichyouwantco citations selectthecocit569 low file andrunanalyze co occurrence makepairsvialistbox andanswernotothenextquestion andokforthequestionafterthat thecocit569 cochadtheco citationfrequencies wewillusethatfileformapping selectcocit569 cocandrunmapping createnet fileforpajek besuretoanswernotothequestionifdirectedarcs sincewedonothaveanydirectionshere tfilecanbeopenedfromwithinpajek netdraw mapquationetcfordrawingmaps mappingwithpajek ofileinpajek andthendraw draw thisisthefirstlayoutwithrandomlyorderednodes totheupperleft chooselayout energy kamada kawai separatecomponentsorjustpressctrl k thekamada kawailayoutisbetterbutstillthereisperhpstoomanylinesinthegraph sincealmosteveryoneisconnectedtoallothers toreducecomplexityminimizethedrawwindowandthenrunnet transform remove lineswithvalue lowerthan andput10intheboxandansweryestomakenewnetwork afterthatrundraw drawagain thismaphamorestructure wefindthatpaperstotheleftandneweronestotheright youcanpressctrl kseveraltimestoseewhathappens makingvectorsmakingcirclesonnodesbasedoncitationfrequencies gotobibexcelandselectcocit569 citandtherunmapping createvec file belowyoucanseethatcocit569 veciscreated gobacktopajek openthevectorfilecocit569 vecandthenrundraw draw vector nowyoucanseethatcirclescorrespondtonofcitations makingpartitionsifyouwishyoucancreateaclu fileusingbibexcelthatindicatesthepublicationyear ordecadeoftheciteddocuments selectcocit569 citandruneditout file extractpublicationyearfromreferencesandyouwillgetafilenamedcocit569 dpy selectcocit569 dpyandrunmapping createclu fileandyouwillgetafilenamedcocit569 clugotopajekandopencocit569 cluaspartiotionrundraw draw partition vectorandtheninthedrawwindowlayers inydirection makessense usingoptions lines differentwidthsandgreyscaleandoptions size oflines 0 25 thiscouldbeachronologicalreadinglistforreviewersandstudents bibexcelmakessomanyfiles cocit569 tx2 text filewherelfwasreplacedbycrcocit569 doc convertedtodialog formatcocit569 out out filebasedoncd fieldcocit569 1st keeponlyauthor sfirstinitialcocit569 low converttoupperandlowercasecocit569 cit frequenciescocit569 coc co net filetobeopeninpajekcocit569 vec vec filetobeopenasvectorsinpajekcocit569 clu clu filetobeopenaspartitionsinpajekcocit569 vel verticesfornet fileforusebybibexcel butbettertohavethemthannot allauthorco citationanalysisusingscopusrecords itsalwaysbetternottolimitto1stcitedauthorasinwos getscopuscocit risfromhttp www8 umu se inforsk esss scopuscocit risselectscopuscocit risandruneditdoc file replacelinefeedwithcarriagereturnselectscopuscocit tx2andrunmisc converttodialogformat convertfromscopusrisformatselectscopuscocit doc putcdinoldtag choose any separatedfield andpressprepselectscopuscocit outandruneditout file scopustools extractallauthorsfromscopusreferencesselectscopuscocit scoandruneditout file decompressoutfileselectscopuscocit nnu choosewholestring markremoveduplicatesandmakenewout file andthenpressstartselectscopuscocit oux marksortdecendingandpressstartselectscopuscocit citandpressviewfileandselectunitsdowntofrequencies 30 andbesureonlytheseareinthelistselectscopuscocit ouxandrunanalyze co occurrences makepairsvialistboxselectthescopuscocit cocfileandthenrunmapping createnet fileforpajek selectscopuscocit citandrunmapping createvec filegotopasnetworkandscopuscocit vecasvectorsrundraw draw vector draw vector toreducecomplexityminimizethedrawwindowandthenrunnet transform remove lineswithvalue lowerthan andput10intheboxandansweryestomakenewnetwork afterthatrundraw draw vectorandthenctrl k webometrics griffithbcwouldprobablynotshowupin1stauthoranalysis gobackandfixthisvariant forvectorgraphicquality atthedrawwindowrunexport 2d svg generalandsaveasallauthormap htmgetinkscapefreefromhttp inkscape org download andopenallauthormap htm editandexporttopng format analyzingdirectcitationsonwebofsciencerecords selectcocit569 lowandrunanalyze citationsamongdocs makecitationlinks thiswillmakecocit569 linthathascitingdocnrinfirstcolumnandciteddocnrinsecondcolumn ofcourseyouneedtolabelthedocnumbers selectthecocit569 ddcanddoubleclickintheboxat typenewfilenamehere andthepathtococit569 ddcshouldappear selectcocit569 linandrunadddataclassify addlabelstodocnr docnrpairs answernotoquestionsaboutswapping self relatedpairs overlappingsets andaboutwritingdocnumbersinadditiontolabelsselectcocit569 addandthenrunmapping createnet fileforpajekandansweryesfordirectedgraphs oinpajekanddraw drawyouwillneedtoreducecomplexity runnet transform reduction degree inputandsetvalue 15 thendraw ifyouwouldliketohavedifferentcirclesizes minimizedrawwindowandthenrunnet vector summingupvaluesoflines inputavectoriscreatedthathasthenumberofinlinkstoeachnode thendraw draw vector analyzingusingweighteddirectcitations wdc wecanaddnumberofsharedoutlinksandinlinkstoeachdirectcitation togiveeachdirectcitationdifferentstrength selectcocit569 linandrunanalyze citationsamongdocs weighteddirectcitations wdc thecocit569 wdchasthewdcvaluesforeachdocnr docnrpairagainyouneedtolabelthedocnumbers selectthecocit569 ddcanddoubleclickintheboxat typenewfilenamehere andthepathtococit569 ddcshouldappear selectcocit569 wdcandrunadddataclassify addlabelstofreq docnr docnr makingfreq label label answernotoquestionsaboutswapping self relatedpairs andoverlappingsets selectthecocit569 cddfileandruneditout file sortnumeric descendingbyfirstcolumnandyouwillseewhicharethestrongestlinksbythewdcmeasureselectcocit569 cddandrunmapping createnet fileforpajek andansweryesfordirectedarcs inpajekusenet transform remove lineswithvalues lowerthan 10 thendraw drawandyouwillseeonebignetworkcomponentandseveralsmalleronesandquitemanyisolates youcanzoomintothebiggeronebypressingrightmoursebuttonanddraw ifyougobacktopajekmainwindowandrunnet components weakandtypesize 20youwillget1componentandthenwithoperations extractfromnetwork partition 1youwillgetanewnetworkwiththebigcomponent thendrawthatnetwork furtherimprovementbysavingmajorcomponentandaddingnewpartitionsandvectors besuretomarkthemaincomponent with63nodes thenfile network sinbandrunmapping createvel filefromnet fileselectthecocit569 ddcfileandrunandruneditout file extractpublicationyearfromreferencesselectcocit569 dpyandrunmapping createclu fileopencocit569 cluaspartitioninpajekandthendraw draw partitionandthenlayers inydirectionifyouwouldliketohavedifferentcirclesizes minimizedrawwindowandthenrunnet vector summingupvaluesoflines inputavectoriscreatedthathasthesumofwdcvaluesofinlinkstoeachnode thendraw draw partition vector reducedirectcitationsbycitationyearlag selectcocit569 cddandrunanalyze calculateyearlagsinpairsandansweryestoaddyearlagvalues whichwillcomeincolumn1 column2hasanormalization col 3dividedbycol 3 andcol 3hasthewdcvalue col 4citingdocandcol 5citeddoc selectcocit569 lagandtogetyearlags0 2yearsput2inmaxnumberboxandthenruneditout files deletevalueshighfrequenciesselectcocit569 max put3 4 5intheboxandruneditout file selectcolumnsnowcocit569 colhaswdcvaluesonlyforlinksnoolderthan2years selectcocit569 colandrunmapping crea