Dear all,
I use the Python API to generate my DataTable and it's giving me some
headache. I want to display one column as a custom HTML tooltip.
Unfortunately, the column content is simply formatted as a string instead
of being rendered as HTML. The Python API insists on doing the following.
My table description is:
gviz_api.DataTable([("Pathway", "string"), ("Source", "string",
"Source", {"type": "string", "role": "tooltip", "p": {"html": True}}),
("Response Score", "number")])
and the relevant output when I call ToJSCode is:
var data = new google.visualization.DataTable();
data.addColumn("string", "Pathway", "Pathway");data.addColumn("string",
"Source", "Source");data.setColumnProperties(1,
{"role":"tooltip","type":"string","p":{"html":true}});data.addColumn("number",
"Response Score", "Response Score");
which leads to the unformatted string. When I change the "Source" column to:
data.addColumn({"role":"tooltip","type":"string","p":{"html":true}});
it works as expected.
Does anyone know of a way to fix this?
My whole output is:
<script src="https://www.google.com/jsapi
<view-source:https://www.google.com/jsapi>"
type="text/javascript"></script><script type="text/javascript">
google.load('visualization', '1', {packages:['corechart']}); function
drawChart() { var data = new
google.visualization.DataTable();data.addColumn("string", "Pathway",
"Pathway");data.addColumn("string", "Source",
"Source");data.setColumnProperties(1,
{"role":"tooltip","type":"string","p":{"html":true}});data.addColumn("number",
"Response Score", "Response Score");data.addRows(22);data.setCell(0, 0,
"Synthesis of epoxy (EET) and dihydroxyeicosatrienoic acids
(DHET)");data.setCell(0, 1, "\n<table id=\"tooltip\">\n <tr>\n <th
colspan=\"2\">\n Synthesis of epoxy (EET) and
dihydroxyeicosatrienoic acids (DHET)\n </th>\n </tr>\n <tr>\n
<td>\n Source:\n </td>\n <td>\n
Reactome\n </td>\n </tr>\n <tr>\n <td>\n
Score:\n </td>\n <td>\n 3.74698287477\n </td>\n
</tr>\n</table>\n ");data.setCell(0, 2,
3.7469828747713798);data.setCell(1, 0, "Synthesis of
(16-20)-hydroxyeicosatetraenoic acids (HETE)");data.setCell(1, 1, "\n<table
id=\"tooltip\">\n <tr>\n <th colspan=\"2\">\n Synthesis of
(16-20)-hydroxyeicosatetraenoic acids (HETE)\n </th>\n </tr>\n
<tr>\n <td>\n Source:\n </td>\n <td>\n
Reactome\n </td>\n </tr>\n <tr>\n <td>\n
Score:\n </td>\n <td>\n 3.58390651249\n </td>\n
</tr>\n</table>\n ");data.setCell(1, 2, 3.58390651248676);data.setCell(2,
0, "Benzo(a)pyrene metabolism");data.setCell(2, 1, "\n<table id=\"tooltip\">\n
<tr>\n <th colspan=\"2\">\n Benzo(a)pyrene metabolism\n
</th>\n </tr>\n <tr>\n <td>\n Source:\n
</td>\n <td>\n Wikipathways\n </td>\n </tr>\n
<tr>\n <td>\n Score:\n </td>\n <td>\n
3.37160874728\n </td>\n </tr>\n</table>\n ");data.setCell(2, 2,
3.3716087472838798);data.setCell(3, 0, "Xenobiotics");data.setCell(3, 1,
"\n<table id=\"tooltip\">\n <tr>\n <th colspan=\"2\">\n
Xenobiotics\n </th>\n </tr>\n <tr>\n <td>\n
Source:\n </td>\n <td>\n PID\n </td>\n
</tr>\n <tr>\n <td>\n Score:\n </td>\n
<td>\n 3.28024821395\n </td>\n </tr>\n</table>\n
");data.setCell(3, 2, 3.2802482139484401);data.setCell(4, 0, "Estrogen
metabolism");data.setCell(4, 1, "\n<table id=\"tooltip\">\n <tr>\n
<th colspan=\"2\">\n Estrogen metabolism\n </th>\n </tr>\n
<tr>\n <td>\n Source:\n </td>\n <td>\n
Wikipathways\n </td>\n </tr>\n <tr>\n <td>\n
Score:\n </td>\n <td>\n 3.25614745919\n
</td>\n </tr>\n</table>\n ");data.setCell(4, 2,
3.2561474591863502);data.setCell(5, 0, "Vitamin A (retinol)
metabolism");data.setCell(5, 1, "\n<table id=\"tooltip\">\n <tr>\n
<th colspan=\"2\">\n Vitamin A (retinol) metabolism\n </th>\n
</tr>\n <tr>\n <td>\n Source:\n </td>\n
<td>\n EHMN\n </td>\n </tr>\n <tr>\n <td>\n
Score:\n </td>\n <td>\n 3.07886384299\n
</td>\n </tr>\n</table>\n ");data.setCell(5, 2,
3.0788638429905202);data.setCell(6, 0, "Fatty Acid Omega
Oxidation");data.setCell(6, 1, "\n<table id=\"tooltip\">\n <tr>\n <th
colspan=\"2\">\n Fatty Acid Omega Oxidation\n </th>\n
</tr>\n <tr>\n <td>\n Source:\n </td>\n
<td>\n Wikipathways\n </td>\n </tr>\n <tr>\n
<td>\n Score:\n </td>\n <td>\n
3.02371577651\n </td>\n </tr>\n</table>\n ");data.setCell(6, 2,
3.0237157765081699);data.setCell(7, 0, "Tamoxifen metabolism");data.setCell(7,
1, "\n<table id=\"tooltip\">\n <tr>\n <th colspan=\"2\">\n
Tamoxifen metabolism\n </th>\n </tr>\n <tr>\n <td>\n
Source:\n </td>\n <td>\n Wikipathways\n
</td>\n </tr>\n <tr>\n <td>\n Score:\n </td>\n
<td>\n 2.97448827603\n </td>\n </tr>\n</table>\n
");data.setCell(7, 2, 2.9744882760281302);data.setCell(8, 0, "Activated AMPK
stimulates fatty-acid oxidation in muscle");data.setCell(8, 1, "\n<table
id=\"tooltip\">\n <tr>\n <th colspan=\"2\">\n Activated
AMPK stimulates fatty-acid oxidation in muscle\n </th>\n </tr>\n
<tr>\n <td>\n Source:\n </td>\n <td>\n
PID\n </td>\n </tr>\n <tr>\n <td>\n Score:\n
</td>\n <td>\n 2.70635126591\n </td>\n
</tr>\n</table>\n ");data.setCell(8, 2, 2.7063512659144999);data.setCell(9,
0, "Xenobiotics");data.setCell(9, 1, "\n<table id=\"tooltip\">\n <tr>\n
<th colspan=\"2\">\n Xenobiotics\n </th>\n </tr>\n
<tr>\n <td>\n Source:\n </td>\n <td>\n
Reactome\n </td>\n </tr>\n <tr>\n <td>\n
Score:\n </td>\n <td>\n 2.68022800253\n </td>\n
</tr>\n</table>\n ");data.setCell(9, 2,
2.6802280025310199);data.setCell(10, 0, "Linoleic acid (LA)
metabolism");data.setCell(10, 1, "\n<table id=\"tooltip\">\n <tr>\n
<th colspan=\"2\">\n Linoleic acid (LA) metabolism\n </th>\n
</tr>\n <tr>\n <td>\n Source:\n </td>\n
<td>\n Reactome\n </td>\n </tr>\n <tr>\n <td>\n
Score:\n </td>\n <td>\n 2.63165923553\n
</td>\n </tr>\n</table>\n ");data.setCell(10, 2,
2.6316592355259401);data.setCell(11, 0, "oleate biosynthesis II
(animals)");data.setCell(11, 1, "\n<table id=\"tooltip\">\n <tr>\n
<th colspan=\"2\">\n oleate biosynthesis II (animals)\n
</th>\n </tr>\n <tr>\n <td>\n Source:\n </td>\n
<td>\n HumanCyc\n </td>\n </tr>\n <tr>\n
<td>\n Score:\n </td>\n <td>\n
2.45033361866\n </td>\n </tr>\n</table>\n ");data.setCell(11, 2,
2.4503336186639699);data.setCell(12, 0, "Sodium-coupled sulphate, di- and
tri-carboxylate transporters");data.setCell(12, 1, "\n<table id=\"tooltip\">\n
<tr>\n <th colspan=\"2\">\n Sodium-coupled sulphate, di-
and tri-carboxylate transporters\n </th>\n </tr>\n <tr>\n
<td>\n Source:\n </td>\n <td>\n PID\n
</td>\n </tr>\n <tr>\n <td>\n Score:\n </td>\n
<td>\n 2.41280443003\n </td>\n </tr>\n</table>\n
");data.setCell(12, 2, 2.4128044300301599);data.setCell(13, 0, "Sodium-coupled
sulphate, di- and tri-carboxylate transporters");data.setCell(13, 1, "\n<table
id=\"tooltip\">\n <tr>\n <th colspan=\"2\">\n
Sodium-coupled sulphate, di- and tri-carboxylate transporters\n </th>\n
</tr>\n <tr>\n <td>\n Source:\n </td>\n
<td>\n Reactome\n </td>\n </tr>\n <tr>\n <td>\n
Score:\n </td>\n <td>\n 2.41280443003\n
</td>\n </tr>\n</table>\n ");data.setCell(13, 2,
2.4128044300301599);data.setCell(14, 0, "Arylhydrocarbon receptor (AhR)
signaling pathway");data.setCell(14, 1, "\n<table id=\"tooltip\">\n <tr>\n
<th colspan=\"2\">\n Arylhydrocarbon receptor (AhR) signaling
pathway\n </th>\n </tr>\n <tr>\n <td>\n
Source:\n </td>\n <td>\n Wikipathways\n </td>\n
</tr>\n <tr>\n <td>\n Score:\n </td>\n
<td>\n 2.4068884386\n </td>\n </tr>\n</table>\n
");data.setCell(14, 2, 2.4068884385953799);data.setCell(15, 0, "Triglyceride
Biosynthesis");data.setCell(15, 1, "\n<table id=\"tooltip\">\n <tr>\n
<th colspan=\"2\">\n Triglyceride Biosynthesis\n </th>\n
</tr>\n <tr>\n <td>\n Source:\n </td>\n
<td>\n PID\n </td>\n </tr>\n <tr>\n <td>\n
Score:\n </td>\n <td>\n 2.29185264558\n
</td>\n </tr>\n</table>\n ");data.setCell(15, 2,
2.2918526455769599);data.setCell(16, 0, "Glyoxylate
metabolism");data.setCell(16, 1, "\n<table id=\"tooltip\">\n <tr>\n
<th colspan=\"2\">\n Glyoxylate metabolism\n </th>\n
</tr>\n <tr>\n <td>\n Source:\n </td>\n
<td>\n Reactome\n </td>\n </tr>\n <tr>\n <td>\n
Score:\n </td>\n <td>\n 2.28677838278\n
</td>\n </tr>\n</table>\n ");data.setCell(16, 2,
2.2867783827828698);data.setCell(17, 0, "eicosapentaenoate biosynthesis II
(metazoa)");data.setCell(17, 1, "\n<table id=\"tooltip\">\n <tr>\n
<th colspan=\"2\">\n eicosapentaenoate biosynthesis II (metazoa)\n
</th>\n </tr>\n <tr>\n <td>\n Source:\n
</td>\n <td>\n HumanCyc\n </td>\n </tr>\n <tr>\n
<td>\n Score:\n </td>\n <td>\n
2.24013447152\n </td>\n </tr>\n</table>\n ");data.setCell(17, 2,
2.2401344715171798);data.setCell(18, 0, "fatty acid α-oxidation
II");data.setCell(18, 1, "\n<table id=\"tooltip\">\n <tr>\n <th
colspan=\"2\">\n fatty acid α-oxidation II\n </th>\n
</tr>\n <tr>\n <td>\n Source:\n </td>\n
<td>\n HumanCyc\n </td>\n </tr>\n <tr>\n <td>\n
Score:\n </td>\n <td>\n 2.08453543191\n
</td>\n </tr>\n</table>\n ");data.setCell(18, 2,
2.0845354319114899);data.setCell(19, 0, "Cyclin B2 mediated
events");data.setCell(19, 1, "\n<table id=\"tooltip\">\n <tr>\n <th
colspan=\"2\">\n Cyclin B2 mediated events\n </th>\n
</tr>\n <tr>\n <td>\n Source:\n </td>\n
<td>\n Reactome\n </td>\n </tr>\n <tr>\n <td>\n
Score:\n </td>\n <td>\n 2.02388474985\n
</td>\n </tr>\n</table>\n ");data.setCell(19, 2,
2.0238847498537198);data.setCell(20, 0, "Bile salt and organic anion SLC
transporters");data.setCell(20, 1, "\n<table id=\"tooltip\">\n <tr>\n
<th colspan=\"2\">\n Bile salt and organic anion SLC transporters\n
</th>\n </tr>\n <tr>\n <td>\n Source:\n
</td>\n <td>\n Reactome\n </td>\n </tr>\n <tr>\n
<td>\n Score:\n </td>\n <td>\n
2.00409320451\n </td>\n </tr>\n</table>\n ");data.setCell(20, 2,
2.0040932045128299);data.setCell(21, 0, "Oxidative Stress");data.setCell(21, 1,
"\n<table id=\"tooltip\">\n <tr>\n <th colspan=\"2\">\n
Oxidative Stress\n </th>\n </tr>\n <tr>\n <td>\n
Source:\n </td>\n <td>\n Wikipathways\n </td>\n
</tr>\n <tr>\n <td>\n Score:\n </td>\n
<td>\n 2.00302885626\n </td>\n </tr>\n</table>\n
");data.setCell(21, 2, 2.0030288562606899); var options = {
width: 800, height: 660, legend: 'none',
backgroundColor: '#EEE', colors: ['red'], chartArea:
{left: 200, top: 22, bottom: 22}, focusTarget: 'category',
tooltip: {isHtml: true} }; var chart = new
google.visualization.BarChart(document.getElementById('fig7cc3514cc4874932b512f155eb7959de'));
chart.draw(data, options); }
google.setOnLoadCallback(drawChart);</script>
--
You received this message because you are subscribed to the Google Groups
"Google Visualization API" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/google-visualization-api.
For more options, visit https://groups.google.com/d/optout.
