Pandas : Lets read multiple zipped CSV’s in one go !!
This short snippet of a python script which I find very handy to read multiple CSV in one go.
JIRA: Lets download JIRA data N Report
JIRA is a great product, in numerous ways. But at times the pain of PM’s (Project Managers) is, they are unable to get the holistic view across multiple projects. This becomes more import when the resources are shared across numerous projects. So as problem defined above the solution that struck me was Just download the Read More …
QlikView – Backup No Data with PRJ folder content to TFS
Hi, Working in Qlikview, would bring you across files which are gigantic and balloons up in your RAM once loaded (depending on the data set loaded in them). But its an amazing technology and the power it enables business user to so quickly slice-dice the data which are inter-related. All things good about Qlikview, but Read More …
Dates Overlap – Get the days count overlapping between 2 date ranges (SQL)
Hi, Well today’s post is a simple one, but this one which gave me a good fight to get the trick right !!! Situation: I have 2 date ranges, and I need to know the number of days over-lapping between these 2 date ranges The above highlighted red area is what I am interested in Read More …
VSTS (TFS Online): Create Work Item from Outlook Mail Integration via VSTO
Hi, Well I believe this post is going to be fancy, but yet quite productive one. In a team where the members are over-burdened with task, and yet they are asked to create TFS work-items for each relevant email which has the associated task for them. They kinda not happy with the effort and wish Read More …