Survival Of The Fittest

The Darwin’s famous theory. The phrase “Survival of the fittest” can be used in the context where a company is able to sustain in the volatile global market.

Recently I thought to order few books and then came to know about Flipkart 10th Anniversary Sale.

Flipkart which was founded by Sachin Bansal & Binny Bansal in 2007, both alumni of the IIT,Delhi. Worked in Amazon came a long way.

After 3 years that is 2010 they started the acquisition game and now they have big names on their acquisition list.

Not only they acquired Myntra they brought its rival Jabong the fashion shopping website too.

Might payzippy was a failure but they realised the power of digital money before demonetization and acquired payment start-up PhonePe In April-2016. In the recent sale, they are promoting PhonePe badly by offering 30% Cashback.I decided not to install it today as I already have 7 digital payment app in my One Plus 3 phone.

A couple of years ago there were many fish in e-commerce market but today buy from Myntra, Jabong or Flipkart, Flipkart will get the benefit.

Flipkart 10th Anniversary Sale is being promoted from the home page of Jabong and Myntra as well.

Where is Snapdeal?

It cut throat competition Flipkart survived, took full benefit of digital tools and the big fish is going to eat Snapdeal now. Once Flipkart acquires Snapdeal then only 2 competitors will be left in market i.e PayTm and Amazon. I believe competition is necessary too.

Though Snapdeal acquisition will benefit Tiger Global more than Flipkart but doesn’t seem a bad deal in long run.

Till now I purchased from all the above-mentioned site to test them or to get better products. Even today I ordered 3 books to get few more drops of knowledge available in it.

Lets’ see what will be the next step after Snapdeal acquisition.

How To Open and Handle Large CSV Files

Recently I was struggling to open Large CSV files and I was using Excel 2013 on Windows 7 64-bit machine.When I was opening big CSV it was throwing error.

With Excel 2013,it is said that the  limit is now gone the only restriction is your machines memory. However, you can still not edit the raw data, only handle (DAX) and aggregate (pivot tables) them! The row limit in Excel 2013 is still 1,048,576.

At that point I started searching for Software which can open large file,then I came across Delimit and it was very helpful.

Features are as follow:

  1. Quickly open any delimited data file.
  2. Edit any cell.
  3. Easily convert files from one delimiter to another like CSV to TAB.
  4. Split-up any delimited file into file parts of equal size.
  5. Join multiple delimited files into one resulting file.
  6. Quickly select which columns to extract and in which order.
  7. Extract data from any delimited file by specifying the columns,rows and/or filter to apply.
  8. Sort any delimited data file based on cell content.
  9. Remove duplicate rows based on user specified columns.
  10. Bookmark any cell for quick subsequent access.
  11. Open large delimited data files; 100s of MBs or GBs in size!
  12. Open data files up to 2 billion rows and 2 million columns large!
  13. Work with: character delimited, string delimited, fixed column width or just plain text files.
  14. Quickly see all your bookmarks, double-click to jump to any of them or click to rename.
  15. Keep track of long running operations.
  16. Keep track of the current selection.
  17. Scroll to any part of the file or split the view into multiple panes.
  18. Freeze the 1st row of any file.
  19. Open multiple files and quickly switch between them.
  20. Configure built-in and custom file delimitation rules for automatic parsing of files.

It is available with 15 day free Trial and can be downloaded from http://www.delimitware.com/