How to Make a Visual CV
Getting data: You will need two pieces of information.
List of your sites of education, training, work, etc. for My Professional Development Sites
List of your publications for other sections. [Tip: Since we will manipulate in a spreadsheet, one way to get a PubMed search into a spreadsheet easily is to use Flink (http://nnlm.gov/pnr/dragonfly/2010/11/10/flink-a-new-way-to-save-pubmed-search-results/)]
You already know how to do this: Generating My Publications by Journal Impact Factor using spreadsheet
Look up Journal Impact Factors (http://www.citefactor.org/journal-impact-factor-list-2014.html) and input on publication list
Categorize impact factors as desired [Warning: No health services research journals over ~5.5 while even 3rd rate medical journals are over 10]
Create pivot chart of impact factors by PubDate(Year) [For interactive chart, go to 6. below]
Create stacked bar chart
Save or Screenshot as Picture and Crop and Resize to look nice
Easy to Do: Generating Word Cloud of Publication Titles using Wordle
Go to Wordle: http://www.wordle.net/create
Copy and Paste paper titles from pub list into Wordle input box
Press Go and Run Java
Press Randomize until it looks the way you want (or use Options I am too lazy to learn)
Save Screenshot as Picture and Crop and Resize to look nice
Medium: Generating My Professional Development Sites using Gephi
Install
Gephi (https://gephi.github.io/)
Plugins for GeoLayout and NoverlapLayout (Tools → Plugins → Available Plugins → Install)
Network Node Table (Sites)
Input sites in order in spreadsheet and label column as Label
Give each site an id number (1 to N) and label column as Id
Look up latitude and longitude of each site (http://www.findlatitudeandlongitude.com/) and input on sheet; label columns as Latitude and Longitude
If you want to categorize sites, input categories as numbers and label column as Modularity Class
Save as .csv
Network Edge Table (Moves)
Make copy of Network Node Table and change label of id numbers to Source; this is where you move from in each row
Insert new column of id number of sites you move to (probably Source + 1) and label as Target
Insert new column and give new id numbers (1001 to N); label as Id
Save as .csv
Import into Gephi
Start as File → New Project
Node Table
In center view, Data Table → Import Spreadsheet → Browse to .csv file for sites
Set As table: to Nodes Table and Press Next
Set Latitude and Longitude format as Double and Modularity Class format as Integer; Press Finish
Edge Table
In center view, Data Table → Import Spreadsheet → Browse to .csv file for moves
Set As table: to Edges Table and Press Next; don't need to change variable formats so Press Finish
Make network diagram: In center view, pick Graph
If you categorized sites, in left top, pick Ranking → Nodes → pick rank parameter as Modularity Class and Press Apply
In left bottom Layout, pick Geo Layout and Press Run
In center view, scroll to adjust size and tweak as desired
Center view bottom button towards left can Show Node Labels
Edge weight scale slider adjusts size of arrows and lines
Font size scale slider adjusts font size
In Layout, pick Noverlap and Press Run to prevent Nodes from overlapping
In Layout, pick Label Adjust and Press Run to prevent Labels from overlapping
Save Screenshot OR [For interactive chart, go to 7. below]
In top, Press Preview and then in left view towards bottom, Press Refresh
Tweak with options of left as desired [Tip: Uncheck Edges/Curved to show arrows; not self-evident to me that processes flow clockwise]
Save as File → Export → .png (or other format if preferred)
Medium: Generating My Co-Authors using Gephi
Install
Gephi (https://gephi.github.io/)
Plugins for NoverlapLayout (Tools → Plugins → Available Plugins → Install)
Network Node Table (Colleagues)
Input first authors in spreadsheet and label column as Label
Give each author an id number (1 to N) and label column as Id
If you want to categorize authors, input categories as numbers and label column as Modularity Class
Save as .csv
Network Edge Table (Co-Authorship)
Input first authors of each paper and label column as Source
Input authors linked to each first author on a paper and label column as Target
If desired, insert column with Weight of each first author- other author relationship on a paper (I weighted 2nd authors at 3, 3rd authors at 2, and others at 1)
Insert column with id numbers (1001 to N) and label column as Id
Save as .csv
Import into Gephi
Start as File → New Project
Node Table
In center view, Data Table → Import Spreadsheet → Browse to .csv file for sites
Set As table: to Nodes Table and Press Next
Set Modularity Class format as Integer; Press Finish
Edge Table
In center view, Data Table → Import Spreadsheet → Browse to .csv file for moves
Set As table: to Edges Table and Press Next; don't need to change variable formats so Press Finish
Make network diagram: In center view, pick Graph
If you weighted co-authorship, pick Ranking → Edges → pick rank parameter as Weight and Press Apply
In Ranking → Nodes → pick rank parameter as Degree and Press Apply; then, Press Size/Weight jewel and Apply
In left bottom Layout, pick Force Atlas, set Repulsion Strength to 10000, and Press Run
In center view, scroll to adjust size and tweak as desired
Center view bottom button towards left can Show Node Labels
Edge weight scale slider adjusts size of arrows and lines
Font size scale slider adjusts font size
In Layout, pick Noverlap and Press Run to prevent Nodes from overlapping
In Layout, pick Label Adjust and Press Run to prevent Labels from overlapping
Save Screenshot OR [For interactive chart, go to 7. below]
In top, Press Preview and then in left view towards bottom, Press Refresh
Tweak with options of left as desired [Tip: Uncheck Edges/Curved to show arrows; not self-evident to me that processes flow clockwise]
Save as File → Export → .png (or other format if preferred)
Advanced: Generating Interactive My Publications by Journal Impact Factor using Google Charts [continuing from 2.(c) above]
Insert data and edit options in html text below using Notepad; insert html text in to target webpage:
<html>
<head>
<script type="text/javascript" src="https://www.google.com/jsapi"></script>
<script type="text/javascript">
google.load("visualization", "1", {packages:["corechart"]});
google.setOnLoadCallback(drawChart);
function drawChart() {
var data = google.visualization.arrayToDataTable([
['Year', 'High (>10)', 'Medium (1-10)', 'Low (<1)'], <!-- Edit column labels-->
['1985', 1, 0, 0],
<!--Insert Your Data Here-->
['2014' , 0, 1, 0]
]);
var options = {
vAxis: {title:'No. of Publications'}, <!--Edit chart title-->
hAxis: {title: 'Year'}, <!--Edit horizontal axis label-->
isStacked:true <--For regular bar chart, set to false-->
};
var chart = new google.visualization.ColumnChart(document.getElementById('chart_div'));
chart.draw(data, options);
}
</script>
</head>
<body>
<div id="chart_div" style="width: 900px; height: 500px;"></div>
</body>
</html>
Advanced: Generating Interactive Gephi Output [continuing from 4.(f) or 5.(f) above]
Install Gephi Plugins for SigmaExporter (Tools → Plugins → Available Plugins → Install)
File → Export → Sigma.js template [This saves folder with all files needed for interactive.]
If map, open /js/sigma/sigma.parseJson.js using Notepad and insert “data.nodes[i].y=-data.nodes[i].y;” after “var id=data.nodes[i].id;” [otherwise, map will be upside down]
Tweak options in config.json below as desired using Notepad:
{
"type": "network", "version": "1.0", "data": "data.json",
"logo": {
"text": "",
"file": "", <!--Link to logo graphic if you have one-->
"link": ""
},
"text": {
"title": "", <!--Chart title-->
"more": "", <!--Long description of chart in pop-up box-->
"intro": "" <!--Short description of chart-->
},
"legend": {
"edgeLabel": "",<!--What edges represent-->
"colorLabel": "", <!--What color of nodes represents-->
"nodeLabel": "" <!--What nodes represent-->
},
"features": {
"search": false, <!--Include search?-->
"groupSelectorAttribute": false, "hoverBehavior": "dim"
},
"informationPanel": {
"imageAttribute": "Label", "groupByEdgeDirection": false
},
"sigma": {
"graphProperties": {
"minEdgeSize": 15, <!--Adjusts minimum line width-->
"maxNodeSize": 30, <!--Adjusts maximum node size-->
"maxEdgeSize": 15, <!--Adjusts maximum line width-->
"minNodeSize": 30 }, <!--Adjusts minimum node size-->
"drawingProperties": {
"labelThreshold": 0, <!--Minimum node size with label; “0” shows all labels-->
"hoverFontStyle": "bold", "defaultEdgeType": "curve", "defaultLabelColor": "#000",
"defaultLabelHoverColor": "#fff",
"defaultLabelSize": 20, <!--Font size of labels-->
"activeFontStyle": "bold", "fontStyle": "bold",
"defaultHoverLabelBGColor": "#002147", "defaultLabelBGColor": "#ddd"
},
"mouseProperties": {
"minRatio": 0.75, "maxRatio": 20
}
}
}