In [1]:

    

#Scipt for converting TSV to our format

import pandas as pd
import json

file_location = raw_input("Enter file name or location(in TSV format):: ")
resources_data = pd.read_table(file_location)
resources_data = resources_data.fillna("")
temp = resources_data
for i in range(resources_data.shape[0]):
    temp_tag = temp.tags[i]
    temp_tags = temp_tag.split(",")
    temp.set_value(i, 'tags', temp_tags)
    
print temp.to_json(orient="records")


    

    




Enter file name or location(in TSV format):: Resources.tsv
[{"name":"MailChimp","short_description":"Email marketing software.","description":"MailChimp allows you to easily customize the way you send automated emails to most effectively market to your audience.","link":"http:\/\/mailchimp.com\/","pricing":"New Business (Free), Growing Business ($10 per month), Pro Marketer (additional $199 per month)","recommendation":"For any company that wants to customize and send automated emails to their audience.","tags":["Marketing"," Advertising"," User Retention"],"category":"Marketing"},{"name":"Basecamp","short_description":"Project management tool.","description":"Basecamp organizes all of your company's projects, communications, and resources in a centralized location.","link":"https:\/\/basecamp.com\/","pricing":"$99 per month, $1100 per year","recommendation":"Recommended if you have multiple projects at the same time and prefer to centralize team communications.","tags":["Project Management"," Communications"," Teamwork"],"category":"Teamwork"},{"name":"Trello","short_description":"Project management tool.","description":"Trello's drag-and-drop interface allows you to easily organize and manage your company's projects","link":"https:\/\/trello.com\/","pricing":"Free, Business Class ($9.99 per month), Enterprise ($20.83 per month)","recommendation":"Recommended if you prefer a visual-focused and user-friendly project management tool that is akin to using online whiteboards.","tags":["Project Management"," Communications"," Teamwork"],"category":"Teamwork"},{"name":"Slack","short_description":"Internal communication app.","description":"Slack organizes your internal communications through project-specific channels.","link":"https:\/\/slack.com\/ ","pricing":"Free, Standard ($6.67 per month), Plus ($12.50 per month)","recommendation":"For any company that wants to organize internal communications for improved team collaboration.","tags":["Communications"," Teamwork"],"category":"Teamwork"},{"name":"Shopify","short_description":"E-commerce platform.","description":"","link":"https:\/\/www.shopify.com\/","pricing":"","recommendation":"","tags":[""],"category":""},{"name":"Searchmetrics","short_description":"","description":"Market analysis tool.","link":"http:\/\/www.searchmetrics.com\/","pricing":"","recommendation":"","tags":["Data & Analytics"," Market Intellgience & Research"],"category":""},{"name":"Ryver","short_description":"","description":"Project management and team communication tool.","link":"https:\/\/ryver.com\/","pricing":"","recommendation":"","tags":["Team Building"],"category":""},{"name":"HelpScout","short_description":"","description":"Tool for customer support and management.","link":"https:\/\/www.helpscout.net\/","pricing":"","recommendation":"","tags":["User Retention"," Data & Analytics"],"category":""},{"name":"Google Apps for Work","short_description":"","description":"Internal infrastructure tools.","link":"https:\/\/gsuite.google.com\/","pricing":"","recommendation":"","tags":[""],"category":""},{"name":"Asana","short_description":"","description":"Project management tool.","link":"https:\/\/asana.com\/","pricing":"","recommendation":"","tags":[""],"category":""},{"name":"UserVoice","short_description":"","description":"Tool for product feedback.","link":"https:\/\/www.uservoice.com\/","pricing":"","recommendation":"","tags":[""],"category":""},{"name":"New Relic","short_description":"","description":"","link":"https:\/\/newrelic.com\/","pricing":"","recommendation":"","tags":[""],"category":""},{"name":"Moz","short_description":"","description":"","link":"https:\/\/moz.com\/","pricing":"","recommendation":"","tags":[""],"category":""},{"name":"Optimizely","short_description":"","description":"","link":"https:\/\/www.optimizely.com\/","pricing":"","recommendation":"","tags":[""],"category":""},{"name":"Google Analytics","short_description":"","description":"","link":"https:\/\/analytics.google.com\/analytics\/web\/provision\/?authuser=0#provision\/SignUp\/","pricing":"","recommendation":"","tags":[""],"category":""},{"name":"botkeeper","short_description":"","description":"","link":"https:\/\/www.botkeeper.com\/","pricing":"","recommendation":"","tags":[""],"category":""},{"name":"Evernote","short_description":"","description":"","link":"https:\/\/evernote.com\/","pricing":"","recommendation":"","tags":[""],"category":""},{"name":"Zenefits","short_description":"","description":"","link":"https:\/\/www.zenefits.com\/","pricing":"","recommendation":"","tags":[""],"category":""},{"name":"Square","short_description":"","description":"","link":"https:\/\/squareup.com\/","pricing":"","recommendation":"","tags":[""],"category":""},{"name":"Buffer","short_description":"","description":"","link":"https:\/\/buffer.com\/","pricing":"","recommendation":"","tags":[""],"category":""},{"name":"Rescue Time","short_description":"","description":"","link":"https:\/\/www.rescuetime.com\/","pricing":"","recommendation":"","tags":[""],"category":""},{"name":"Autosend","short_description":"","description":"","link":"","pricing":"","recommendation":"","tags":[""],"category":""},{"name":"OptiMonk","short_description":"","description":"","link":"","pricing":"","recommendation":"","tags":[""],"category":""},{"name":"SimilarTech","short_description":"","description":"","link":"","pricing":"","recommendation":"","tags":[""],"category":""},{"name":"Upsight","short_description":"","description":"","link":"","pricing":"","recommendation":"","tags":[""],"category":""},{"name":"UserTesting","short_description":"","description":"","link":"","pricing":"","recommendation":"","tags":[""],"category":""},{"name":"LeadPages","short_description":"","description":"","link":"","pricing":"","recommendation":"","tags":[""],"category":""},{"name":"Heap","short_description":"","description":"","link":"","pricing":"","recommendation":"","tags":[""],"category":""},{"name":"OptinMonster","short_description":"","description":"","link":"","pricing":"","recommendation":"","tags":[""],"category":""},{"name":"Mixpanel","short_description":"","description":"","link":"","pricing":"","recommendation":"","tags":[""],"category":""},{"name":"Artisan","short_description":"","description":"","link":"","pricing":"","recommendation":"","tags":[""],"category":""}]