From time to time, I got to deal with CSVs that are millions lines each, whether the data is from large datasets or from web scraping.
One time, I extracted the followings of the followers of an account, having in mind to know with which accounts they were competing on their audience.
That was an 10k followers account - and, give or take, each follower was in average following 800 accounts as well: that's 8,000,000 lines in total. And I had this data in a CSV, not in a database (oup's).
Question is: what are the accounts the most followed by the follower of an account?
That's a basic COUNTIF question.
Excel only takes into account a little more than 1,000,000 rows. Even more - try to perform a =COUNTIF() on 1 million rows. You'll get the result two days after.
So here I'm just sharing a little Python script, that actually does the work in less than 2 minutes. I'm leaving comments to explain the script below.
Hope it'll help someone!
I'm sharing here a proven tactic that drive results to get back at least 25% of your lost checkouts, while the e-commerce average is around 8%.
Launching an ecommerce store? You have everything ready, your products, your website, your design - even your analytics? Yupee !But how about your CRM ? In this article, we'll review a simple go-to plan you can start with today to extend your CRM capabilities. Let's dive in!
This calculator will let you know which budget you'll need on Facebook - and if your ads are profitable.
This email A/B test significance test will let you know which version of your email A/B test is the most performant - and on which metrics. Plus, we'll display which recommandations you can take.
Landing pages -- unlike regular pages -- help convert better. Use them generously for all campaigns. eCommerce conversions -- along with sign ups with tracking pixels happen on landing pages. Sales happen on eCommerce product pages. All of this is tracked.
One way to challenge big brands is to leverage data. Which data? Yours
To help boost your Shopify store conversion rates, you’ll need a holistic approach.
What do customers want to see? Truth is, it really depends on what you offer and how you want to brand your business. Overall, here are the things that we highly suggest you consider when writing your newsletter.
How to increase click rate on emails? This is a very tricky question because it always depends on a lot of stuff and by a lot we mean — A LOT. So, we suggest to actually follow this checklist that we have formulated to help you get a bigger picture of what should be done.
Colourpop is a great makeup and skincare brand. It is well-known for its cosmetics and well-appreciated by beauty addicts around the world. We were curious how they gained even more popularity, so we did what we love to do - review their funnel. Let’s see all their good practices and what they could improve on their website!
The global eCommerce industry is pegged at a whopping $4.89 trillion in 2021, according to Shopify. If you get it right, it’s a profitable and borderless industry that you could take advantage of.
Peloton is a brand well-known for its exercise bikes, treadmills and fitness classes. Take a ride with us as we get a closer look at their funnel. Highlight vendor collections - The home page is the most important part of your site. It helps...
SEO-optimized FAQ for your eCommerce store gives people the information they're looking for without them having to leave your website or call customer service.