Excel pivot table hierarchy – Super User

This is my input data (sample)

Input Data

Excel pivot table currently gives me this

Pivot Table Output

However I want an output like this

What I need

Can pivot table be configured to give that output?
Or is there anyother tool I can use to get it?

I want to get this done, without any coding.

Mac “other” storage super hidden

I’ve looked through quite a few other posts about this issue and they always seem to get resolved by some iTunes or document storage that the Mac is accidentally tracking as part of the “other” storage. But my Mac has no files on it except for System files and Steam.
I used it a long time ago but wiped everything clean, now there’s 87GB of other files somewhere? I don’t see them in any directory, DiskDaisy shows them as in hidden hidden space, but I don’t have the money to pay for DiskDaisy to do Admin Scan. I just want to be able to use my Mac again lol.

No TimeMachine, no caches that I can find, I’ve tried quite a few things so far

Storage Image

I’ll continue looking while I wait to see if this gets any responses, getting frustrated here :/

[WTS] Get your super fast OpenVZ VPS starting from $5.83: Bulgaria, USA, Canada.

NEW! Budget Linux VPS as low as $5.83 per month:

Locations:
Germany, Switzerland, Netherlands, Bulgaria (100 Gbps DDoS Protection), USA – Miami (FL), USA – New York (NY), Canada (480 Gbps DDoS Protection).

************************************************** ********************************
Here is the promo:

XMASQH25OFFHOST -25% SHARED RESELLER VPS AND COMODO POSITIVE SSL –
Recurring 2 more times!

—-
XMASQH12OFFDEDI -12% – any billing cycle, Lifetime recurring discount on
ALL SWITZERLAND AND USA DEDICATED SERVERS!

Please note the discount is visible on the Review & Checkout step.
And Comodo Positive SSL certificate!
************************************************** ********************************
Linux OpenVZ (Budget) VPS (LE)

OpenVZ Light Edition VPS
1 GB Dedicated memory
20 GB Disk space
500 GB Bandwidth
Full Root access
1 IP address
CentOS/Debian/Ubuntu
$5.83 PER MONTH
(applies to annual payment)
ORDER NOW

Need another Linux VPS? Check here: https://click.pstmrk.it/2ts/www.QHos…Awe/lF-7kUdPWS

Desiderate Instant Managed VPS? Here you are: http://www.qhoster.com/cpanel-managed-vps.html

Current promotions:

***********************************************
Discounts for all hosting and all VPS plans and Comodo Positive SSL certificate:

QHSPRING33
Recurring 33% OFF!
(applies to any billing cycle)

***********************************************
QHoster payment options:

WebMoney, Perfect Money, Bitcoin, NETELLER, Payza (formerly Alertpay), Skrill (formerly Moneybookers), Litecoin, Darkcoin (DRK), SolidTrust Pay, cashU, Ukash, Payeer, OKPAY, EgoPay, paysafecard, Alipay, MoneyGram, Western Union, SOFORT Banking, QIWI, Alfa Click, Sberbank Rossii, Promsvyazbank (PSB), Svyaznoy, Przelewy24, Interac, Boleto Bancario, MercadoPago, PagSeguro, OneCard, DaoPay, Fortumo.

Learn More about Payment options here:
http://www.qhoster.com/payment-methods.html

Windows 7 & 2003/2008 Server in Minutes
Choose your payment option, choose your server location and get your best Windows VPS!

Instant Setup! Ready in 20 minutes!

Visit QHoster now.

cPanel Shared Webhosting
CR2QS5B85D30% OFF!
Applies to all shared and VPS plans, 3+ month period of order!

VPS and Dedicated Server
Personal voucher for $50
GHR8WY5P4P
(applies to annual billing cycles)

Windows RDP VPS
– Managed & Scalable – Instant RDP VPS Upgrades – CPU, RAM etc.
– Full Adminstrator Access to Your Windows RDP VPS
– Use Windows Server & 7 Remotely Like Your Desktop Computer
– Choice: UK,USA,Canada,France,Germany,Netherlands,Switzerla nd

Windows VPS RDP (1)
2 CPU Cores (Intel Xeon)
1.5 GB Dedicated Memory
60 GB Disk Space
1 TB Monthly Bandwidth
1 GBit/s Internet Port
1 IP (additional 64 IPs)
Price $19.96/mo
ORDER HERE

Windows VPS RDP (2)
3 CPU Cores (Intel Xeon)
3 GB Dedicated Memory
120 GB Disk Space
2 TB Monthly Bandwidth
1 GBit/s Internet Port
1 IP (additional 64 IPs)
Price $39.92/mo
ORDER HERE

Windows VPS RDP (3)
4 CPU Cores (Intel Xeon)
4.5 GB Dedicated Memory
180 GB Disk Space
3 TB Monthly Bandwidth
1 GBit/s Internet Port
1 IP (additional 64 IPs)
Price $59.88/mo
ORDER HERE

Windows KVM Servers

Windows RDP VPS – KVM 1
1.5 GB Dedicated memory
60 GB Disk space
1000 GB Bandwidth
Administrator RDP access
1 IP address
Windows Server 2008/2012/2016
$24.95/m
ORDER HERE

Windows RDP VPS – KVM 2
3 GB Dedicated memory
120 GB Disk space
2000 GB Bandwidth
Administrator RDP access
1 IP address
Windows Server 2008/2012/2016
$49.90/m
ORDER HERE

Have questions?
Feel free to contact us:
https://www.qhoster.com/clients/subm…tep=2&deptid=1

.(tagsToTranslate)webmaster forum(t)internet marketing(t)search engine optimization(t)web designing(t)seo(t)ppc(t)affiliate marketing(t)search engine marketing(t)web hosting(t)domain name(t)social media

magento2 – Magento 2 – need super simple way of assessing whether cart is empty or not in list.phtml file

Client wants to display a conditional message on the category list.phtml page depending on whether or not the cart has ANYTHING in it

I’ve found a lot of posts about creating a custom module to be able to assess cart items etc. but surely there must just be a simple way of identifying whether the cart contains anything or not without the need for a whole module to do so.

I don’t care if we’re counting items, reporting totals, assessing whether a cart exists or however it’s done I just need a ‘cart_empty’ true or false variable

Any ideas?

Create 30 super web 2 0 backlinks buffer blogs for $5

Create 30 super web 2 0 backlinks buffer blogs

Here I am offering High PR10 to PR5 Super Web 2.0 backlinks for you with login details. All of the Web 2.0 will be 100% manually & indexable. The Super web 2.0 blogs will be 100% secure from Google Panda, Penguin, &

Hummingbird. All of the Super web 2.0 contextual backlinks are from high authority sites and high quality. My web 2.0 backlinks will definitely boost up your site with increase the Domain Authority, Page Authority and more.

Benefits to Buy My Gig:

  • Manually created super web 2.0 blogs.
  • Use random IP for each blog creation.
  • Manually spun 500+ words niche related article.
  • Relevant images/videos will be used in the content.
  • Mostly from PR (9 to 5) domains and Domain Authority (100 to 60)
  • Unique Domains and Permanent web 2.0 Backlinks.
  • Google safe no fear of Google algorithm penalty.
  • Login Details of every buffer blog (mail,username,password)
  • Mostly created Multiple Pages.
  • 48 Hours Express Delivery

.(tagsToTranslate)authority(t)backlinks(t)contextual(t)backlinks(t)web(t)2(t)web(t)2.0(t)blogs(t)web(t)2.0(t)backlinks

Super Fast Speed| HostingSource.com SSD CLOUD VPS servers + 100% UPTIME! | NewProxyLists

HostingSource, Inc. is a leading hosting provider, offering reliable, scalable solutions for customers of all sizes and services. We supply all of the servers, software, bandwidth and management tools needed to run almost any web hosted application – from small to enterprise server solutions.
Our staff has over 20 years of experience in the IT field.

Our team of dedicated professionals, specializing in managed hosting solutions, software development, website design, website marketing, database integration & programming, & e-commerce solutions, can offer you the service and support that you need to make your online presence a reality.

HostingSource Advantages:
– High Performance SSD
– Redundant Hardware
– 24/7/365 Dedicated Support
– 100% Uptime Guarantee
– Windows Hyper-V
– Linux KVM Hypervisor
– Fast VPS Deployment
– No Contract, Cancel Anytime

Save Big on Hosting – 50% off 1st month on all Servers/VPS plans.

CHECK OUT HostingSource HIGH PERFORMANCE SSD CLOUD VPS PLans:

VPS – I
1 CPU Core
20GB – SSD DISK
5TB – DATA TRANSFER
1GB – RAM
Price – $8/mo
==>>> ORDER

VPS – II
2 CPU Core
40GB – SSD DISK
6TB – DATA TRANSFER
2GB – RAM
Price – $15/mo
==>>> ORDER

VPS – III
3 CPU Core
60GB – SSD DISK
7TB – DATA TRANSFER
4GB – RAM
Price – $22/mo
==>>> ORDER

CLOUD-I
4 CPU Core
100GB – SSD DISK
10TB – DATA TRANSFER
8GB – RAM
Price – $29/mo
==>>> ORDER

CLOUD-II
8 CPU Core
150GB – SSD DISK
15TB – DATA TRANSFER
12GB – RAM
Price – $39/mo
==>>> ORDER

CLOUD-III
12 CPU Core
200GB – SSD DISK
20TB – DATA TRANSFER
16GB – RAM
Price – $59/mo
==>>> ORDER

FOR MORE DETAILS CHECK: http://www.hostingsource.com/vps-hosting/

HostingSource, Inc., is committed to providing our customers the highest level of quality service and support. We are also committed to serving future customers by rapidly responding to sales or informational inquiries.
Please contact us at your convenience via the methods listed below:
– If you have any questions, feel free to call us toll-free: 1-888-586-1101
– Sales Department – For all sales inquiries or non technical questions.
– Technical Support Department – Technical Support available 24 hours a day, 7 days a week.
– FAQ Support – Use our in-depth Knowledgebase to get additional tips. It’s a great way to learn how to fine tune your website, enhance your service and more.

Super Fast Speed| Hostingsource.com Ssd Cloud Vps Servers + 100% Uptime!

HostingSource, Inc. is a leading hosting provider, offering reliable, scalable solutions for customers of all sizes and services. We supply all of the servers, software, bandwidth and management tools needed to run almost any web hosted application – from small to enterprise server solutions.
Our staff has over 20 years of experience in the IT field.

Our team of dedicated professionals, specializing in managed hosting solutions, software development, website design, website marketing, database integration & programming, & e-commerce solutions, can offer you the service and support that you need to make your online presence a reality.

HostingSource Advantages:
– High Performance SSD
– Redundant Hardware
– 24/7/365 Dedicated Support
– 100% Uptime Guarantee
– Windows Hyper-V
– Linux KVM Hypervisor
– Fast VPS Deployment
– No Contract, Cancel Anytime

Save Big on Hosting – 50% off 1st month on all Servers/VPS plans.

CHECK OUT HostingSource HIGH PERFORMANCE SSD CLOUD VPS PLans:

VPS – I
1 CPU Core
20GB – SSD DISK
5TB – DATA TRANSFER
1GB – RAM
Price – $8/mo
==>>> ORDER

VPS – II
2 CPU Core
40GB – SSD DISK
6TB – DATA TRANSFER
2GB – RAM
Price – $15/mo
==>>> ORDER

VPS – III
3 CPU Core
60GB – SSD DISK
7TB – DATA TRANSFER
4GB – RAM
Price – $22/mo
==>>> ORDER

CLOUD-I
4 CPU Core
100GB – SSD DISK
10TB – DATA TRANSFER
8GB – RAM
Price – $29/mo
==>>> ORDER

CLOUD-II
8 CPU Core
150GB – SSD DISK
15TB – DATA TRANSFER
12GB – RAM
Price – $39/mo
==>>> ORDER

CLOUD-III
12 CPU Core
200GB – SSD DISK
20TB – DATA TRANSFER
16GB – RAM
Price – $59/mo
==>>> ORDER

FOR MORE DETAILS CHECK: http://www.hostingsource.com/vps-hosting/

HostingSource, Inc., is committed to providing our customers the highest level of quality service and support. We are also committed to serving future customers by rapidly responding to sales or informational inquiries.
Please contact us at your convenience via the methods listed below:
– If you have any questions, feel free to call us toll-free: 1-888-586-1101
– Sales Department – For all sales inquiries or non technical questions.
– Technical Support Department – Technical Support available 24 hours a day, 7 days a week.
– FAQ Support – Use our in-depth Knowledgebase to get additional tips. It’s a great way to learn how to fine tune your website, enhance your service and more.

[WTS] Super Fast Speed| HostingSource.com SSD CLOUD VPS servers + 100% UPTIME!

HostingSource, Inc. is a leading hosting provider, offering reliable, scalable solutions for customers of all sizes and services. We supply all of the servers, software, bandwidth and management tools needed to run almost any web hosted application – from small to enterprise server solutions.
Our staff has over 20 years of experience in the IT field.

Our team of dedicated professionals, specializing in managed hosting solutions, software development, website design, website marketing, database integration & programming, & e-commerce solutions, can offer you the service and support that you need to make your online presence a reality.

HostingSource Advantages:
– High Performance SSD
– Redundant Hardware
– 24/7/365 Dedicated Support
– 100% Uptime Guarantee
– Windows Hyper-V
– Linux KVM Hypervisor
– Fast VPS Deployment
– No Contract, Cancel Anytime

Save Big on Hosting – 50% off 1st month on all Servers/VPS plans.

CHECK OUT HostingSource HIGH PERFORMANCE SSD CLOUD VPS PLans:

VPS – I
1 CPU Core
20GB – SSD DISK
5TB – DATA TRANSFER
1GB – RAM
Price – $8/mo
==>>> ORDER

VPS – II
2 CPU Core
40GB – SSD DISK
6TB – DATA TRANSFER
2GB – RAM
Price – $15/mo
==>>> ORDER

VPS – III
3 CPU Core
60GB – SSD DISK
7TB – DATA TRANSFER
4GB – RAM
Price – $22/mo
==>>> ORDER

CLOUD-I
4 CPU Core
100GB – SSD DISK
10TB – DATA TRANSFER
8GB – RAM
Price – $29/mo
==>>> ORDER

CLOUD-II
8 CPU Core
150GB – SSD DISK
15TB – DATA TRANSFER
12GB – RAM
Price – $39/mo
==>>> ORDER

CLOUD-III
12 CPU Core
200GB – SSD DISK
20TB – DATA TRANSFER
16GB – RAM
Price – $59/mo
==>>> ORDER

FOR MORE DETAILS CHECK: http://www.hostingsource.com/vps-hosting/

HostingSource, Inc., is committed to providing our customers the highest level of quality service and support. We are also committed to serving future customers by rapidly responding to sales or informational inquiries.
Please contact us at your convenience via the methods listed below:
– If you have any questions, feel free to call us toll-free: 1-888-586-1101
– Sales Department – For all sales inquiries or non technical questions.
– Technical Support Department – Technical Support available 24 hours a day, 7 days a week.
– FAQ Support – Use our in-depth Knowledgebase to get additional tips. It’s a great way to learn how to fine tune your website, enhance your service and more.

.

python – Find number of islands: Super slow compared to top answers on Leetcode

I am on my second iteration of the famous “Number Of Islands” graph problem on Leetcode.

https://leetcode.com/problems/number-of-islands/

Given an m x n 2D binary grid grid which represents a map of '1's (land) and '0's (water), return the number of islands.

An island is surrounded by water and is formed by connecting adjacent lands horizontally or vertically. You may assume all four edges of the grid are all surrounded by water.

 

Example 1:

Input: grid = (
  ("1","1","1","1","0"),
  ("1","1","0","1","0"),
  ("1","1","0","0","0"),
  ("0","0","0","0","0")
)
Output: 1

Example 2:

Input: grid = (
  ("1","1","0","0","0"),
  ("1","1","0","0","0"),
  ("0","0","1","0","0"),
  ("0","0","0","1","1")
)
Output: 3

My approach is to iterate through each cell in the grid, incrementing a counter when the value == 1. Then, do a breadth-first search of the cell’s neighbors, adding them to the queue if their value == 1. Once the queue is empty, keep iterating through all the cells.

To avoid infinite loops, I first used a set() to keep track of a list of tuple coordinates. This seemed to jack up my memory usage, so I then improved the algorithm by removing the set and simply setting the value of visited cells to 0.

I passed all the test cases but still can’t figure out how to get a better runtime. I’m currently slower than ~90% of python submissions.

I would appreciate if anyone can help speed this thing up!


class Solution:
    def numIslands(self, grid: List(List(str))) -> int:
        """
        Gets the neighbors of a coordinate in a grid. Returns a list of tuples.
        """
        m = len(grid)
        n = len(grid(0))

        def get_neighbors(coord: Tuple(int, int)) -> List(Tuple):
            delta_row    = (0, 1, 0, -1)
            delta_column = (1, 0, -1, 0)

            neighbors = ()
            for i in range(len(delta_row)):
                new_x = coord(0) + delta_row(i)
                new_y = coord(1) + delta_column(i)

                if -1 < new_x < m and -1 < new_y < n:
                    neighbors.append((new_x, new_y))

            return neighbors

        # loop through the entire grid and set coords to 0 as we visit them 
        # if val == 1, do a breadth-first search for neighbors and increment islands
        # if val == 0, continue to next coordinate.

        islands = 0

        for i in range(len(grid)):
            for j in range(len(grid(0))):
                coord = (i, j)
                if grid(coord(0))(coord(1)) == "1":
                    islands += 1

                    # breadth-first search
                    q = deque((coord))
                    while len(q) > 0:
                        c = q.popleft()
                        grid(c(0))(c(1)) = "0"
                        for neighbor in get_neighbors(c):
                            if grid(neighbor(0))(neighbor(1)) == "1":
                                q.append(neighbor)
                                grid(neighbor(0))(neighbor(1)) = "0"

        return islands

c++ – Mimic `super` keyword: Set `base` class and `derived` class field during instantiation

Consider the following code:

#include <iostream>

struct Parent {
  int baseA_ = 0;
  double baseB_ = 0.0;

  Parent() = default;
  virtual ~Parent() = default;

  Parent(int a) : baseA_{a} {}

  Parent(int a, double b) : baseA_{a}, baseB_{b} {}

  auto set(int a) -> void { baseA_ = a; }

  auto set(int a, double b) -> void {
    baseA_ = a;
    baseB_ = b;
  }
};

struct AnotherParent {
  std::string baseA_ = {};

  AnotherParent() = default;
  virtual ~AnotherParent() = default;

  AnotherParent(const std::string &a) : baseA_{a} {}

  auto set(const std::string &a) -> void { baseA_ = a; }
};

// Notice that the `Child` class inherits from T.
template <typename T>
struct Child : public T {
  int derivedA_ = 0;

  Child() = default;
  ~Child() = default;

  Child(int a) : derivedA_{a} {}

  auto super(auto... args) -> Child & {
    T::set(args...);
    return (*this);
  }
};

int main() {
  auto c1 = Child<Parent>(23).super(23, 3.5);
  auto c2 = Child<AnotherParent>(243).super("Hello, World!");

  std::cout << "C1 - Base -> A: " << c1.baseA_ << ", B: " << c1.baseB_
            << std::endl;
  std::cout << "C1 - Derived -> A: " << c1.derivedA_ << std::endl;

  std::cout << "C2 - Base -> A: " << c2.baseA_ << std::endl;
  std::cout << "C2 - Derived -> A: " << c2.derivedA_ << std::endl;
  return 0;
}

To compile use:

g++ -std=c++17 -fconcepts Main.cpp

or

g++ -std=c++14 -fconcepts Main.cpp

What I want to achieve?

I want to initialize both child class (inherited from template class type) and parent class fields during instantiation. I don’t want to pass a parent class object as parameter to constructor.

Pros:

  1. It can be used to set super class (i mean it) data fields for any type.
  2. It offers safety by producing a compiler-error if set() method is not suitable.
  3. No need to overload child class constructor to set super class data fields
    (Infact, no one can overload child class constructor to match any super class, or is it possible?, I am not sure).
  4. Call to super() is optional.

Limitations:

  1. Works for single inheritance only, although interfaces can be implemented.
  2. Parent class should have a set() method.

Queries:

  1. The way how I implemented super – Is is a good practice?
  2. Are there any hidden cons?
  3. Does it violate any idiom?
  4. Is is ok to use -fconcepts?
  5. If it is good, can it be improved? Like, should I implement some interfaces to make it more maintainable or ensure availability of set() method.
  6. What are your opinions?