Wednesday, September 17, 2014

Python scripts to shorten column names, or to fetch Google Ngrams data

I've made a couple new GitHub repos:

google_ngram_py, which allows you to look up one- to five-word phrases in Google Ngrams Viewer (which shows the frequency by year) from python and returns the data as pandas dataframes, separated into parent and child for case-insensitive searches (e.g. parent is 'the (All)', children are 'the', 'The', 'THE').

shorten_column_names, which allows you to find the most common words in a list of phrases and abbreviate them; I used them for shortening the sometimes 100+-character column names from World Bank data (e.g. population -> pop), but you could use it on any list of strings.
• • •


  1. thanks for shared wonderful information of giving best information.its more useful and more helpful. great doing keep sharing
    Germany Education Consultants in Chennai

  2. Hello,
    The Article on Python scripts to shorten column names, or to fetch Google Ngrams data is very informative give detail information about it .Thanks for Sharing the information about it. hire data scientists

  3. Superb kind of work by the author as on this particular topic people needs more precise information and special attention to it.Thanks a lot.
    Online synonyms

  4. This is an awesome post.Really very informative and creative contents. These concept is a good way to enhance the knowledge.I like it and help me to development very well.Thank you for this brief explanation and very nice information.Well, got a good knowledge.

    rpa Training in tambaram

    blueprism Training in tambaram

    automation anywhere training in tambaram

    iot Training in tambaram

    rpa training in sholinganallur

    blue prism training in sholinganallur

    automation anywhere training in sholinganallur

    iot training in sholinganallur

  5. This is quite educational arrange. It has famous breeding about what I rarity to vouch. Colossal proverb. This trumpet is a famous tone to nab to troths. Congratulations on a career well achieved. This arrange is synchronous s informative impolite festivity to pity. I appreciated what you ok extremely here.
    java training in tambaram | java training in velachery

    java training in omr | oracle training in chennai

    java training in annanagar | java training in chennai

  6. I have been meaning to write something like this on my website and you have given me an idea. Cheers.
    python training in pune
    python online training
    python training in OMR

  7. The knowledge of technology you have been sharing thorough this post is very much helpful to develop new idea. here by i also want to share this.
    Devops training in tambaram
    DevOps online Training
    DevOps Training in USA

  8. This is most informative and also this post most user friendly and super navigation to all posts... Thank you so much for giving this information to me.. 
    Blueprism training institute in Chennai

    Blueprism online training

    Blue Prism Training Course in Pune

    Blue Prism Training Institute in Bangalore

  9. Gaining Python certifications will validate your skills and advance your career.
    python certification

  10. Greetings. I know this is somewhat off-topic, but I was wondering if you knew where I could get a captcha plugin for my comment form? I’m using the same blog platform like yours, and I’m having difficulty finding one? Thanks a lot.
    AWS Interview Questions And Answers
    AWS Online Training | Online AWS Certification Course - Gangboard
    AWS Training in Chennai | AWS Training Institute in Chennai Velachery, Tambaram, OMR
    AWS Training in Bangalore |Best AWS Training Institute in BTM ,Marathahalli