{"id":5688,"date":"2016-09-08T08:37:42","date_gmt":"2016-09-08T13:37:42","guid":{"rendered":"http:\/\/appcrawler.com\/wordpress\/?p=5688"},"modified":"2016-09-08T08:37:42","modified_gmt":"2016-09-08T13:37:42","slug":"wireshark-python-and-excel-for-graphing-tcp-window-sizes","status":"publish","type":"post","link":"http:\/\/appcrawler.com\/wordpress\/2016\/09\/08\/wireshark-python-and-excel-for-graphing-tcp-window-sizes\/","title":{"rendered":"wireshark, python, and Excel for graphing TCP window sizes"},"content":{"rendered":"<p>Filter the packets in which you are interested.  In this case, we filter on the source IP&#8230;<\/p>\n<p><img alt='' class='alignnone size-full wp-image-5690 ' src='http:\/\/appcrawler.com\/wordpress\/wp-content\/uploads\/2016\/09\/img_57d168dbe1bfe.png' \/><\/p>\n<p>&#8230;then export the packets to a CSV file&#8230;<\/p>\n<p><img alt='' class='alignnone size-full wp-image-5691 ' src='http:\/\/appcrawler.com\/wordpress\/wp-content\/uploads\/2016\/09\/img_57d169015ba3a.png' \/><\/p>\n<p>&#8230;which we then parse in python to produce another CSV file&#8230;<\/p>\n<pre>\r\nf = open(\"good.csv\",\"w\")\r\nfor line in open(\"goodpackets.csv\"):\r\n  tmp = line.split(\",\")\r\n  for elem in tmp[6].split(\" \"):\r\n    if elem.find(\"Win=\") > -1:\r\n      f.write(tmp[1] + \",\" + str(elem.split(\"=\")[1]) + '\\n')\r\n<\/pre>\n<p>&#8230;for display and graphing in Excel&#8230;<\/p>\n<p><img alt='' class='alignnone size-full wp-image-5692 ' src='http:\/\/appcrawler.com\/wordpress\/wp-content\/uploads\/2016\/09\/img_57d1693dd8c1b.png' \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Filter the packets in which you are interested. In this case, we filter on the source IP&#8230; &#8230;then export the packets to a CSV file&#8230; &#8230;which we then parse in python to produce another CSV file&#8230; f = open(&#8220;good.csv&#8221;,&#8221;w&#8221;) for&hellip;<\/p>\n<p class=\"more-link-p\"><a class=\"more-link\" href=\"http:\/\/appcrawler.com\/wordpress\/2016\/09\/08\/wireshark-python-and-excel-for-graphing-tcp-window-sizes\/\">Read more &rarr;<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_mi_skip_tracking":false,"footnotes":""},"categories":[56,8,73],"tags":[],"_links":{"self":[{"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/posts\/5688"}],"collection":[{"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/comments?post=5688"}],"version-history":[{"count":2,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/posts\/5688\/revisions"}],"predecessor-version":[{"id":5694,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/posts\/5688\/revisions\/5694"}],"wp:attachment":[{"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/media?parent=5688"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/categories?post=5688"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/tags?post=5688"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}