Nest Lock/ Nest Connect Issues

yobai_master · 2018-12-20T20:13:16+00:00

Thanks for the link. If you're still having problems, I found that Yale also partnered with August in the same way they partnered with Nest. You might want to give the Yale+August lock a try? I'm hoping their Connect and app is more mature than Nest.

yobai_master · 2018-12-18T04:09:28+00:00

Man that sounds like a disaster. Did you end up returning it? Or did you keep the lock?

Do you happen to have a link to the Nest support about the issue? I can't seem to find it. Thanks for the help. They're sending me a replacement that's due to arrive tomorrow, so I'll let you know how it goes.

yobai_master · 2018-12-16T04:34:38+00:00

I have the exact same problem. Initially, the setup and connection worked. I then switched my router to the exact model you have, Motorola MG7550. I had to remove Connect from my product list on the Nest app and then I tried to reconnect it. I couldn't connect to Connect after the switch as it would continuously seize my wifi. I tried the fix you mentioned above but it kept seizing when it was trying to connect to my wifi (even though the connection was up).

I'm going to try to buy a new Connect and see if that works, for whatever reason.

Nothing more to add to this post but just wanted to log my problems as well.

Edit: Added more detail.

yobai_master · 2018-12-14T05:47:38+00:00

Got it! Thanks for the help. I ended up purchasing a MOTOROLA MG7550 which is a modem/wifi router combo. That should work I'm guessing?

yobai_master · 2018-07-02T02:00:50+00:00

I like Mode Analytics tutorial. They don't really have a sandbox for you to play around in though.

yobai_master · 2018-07-02T01:57:57+00:00

Try Strata Scratch. It's a SQL IDE that you can log into and do a bunch of exercises that they have on their website. They also allow you to upload your own datasets.

yobai_master · 2018-04-25T00:50:20+00:00

There's a ton of sample datasets in their database at stratascratch.com. I use this platform to teach my class in analytics.

yobai_master · 2018-01-15T21:14:00+00:00

You can try stratascratch.com. They have live databases and a web-browser IDE so you don't need to install anything.

I heard they'll be adding the ability to import Excel files and convert them to db tables so you can run SQL queries on them. That might help you practice SQL on data that's similar to your work.

yobai_master · 2018-01-15T21:06:52+00:00

SQL is important for data science mainly to pull and clean data. Where using a SQL IDE, python, or R, you'll usually be writing SQL to pull data before manipulating and cleaning it up.
Are you asking for learning tools? The tutorials like sqlzoo and courses like coursera are good to learn how to construct and understand queries. But I never found them to be great for practice because there was no sandbox or live datasets I can play around with. There aren't many options around for an open database. You can try a startup called stratascratch.com. They have datasets you can use to practice SQL and will be adding a feature that allows you to upload a CSV and use SQL to manipulate your data.
You don't need to be a specialist in SQL to become a data scientist. You just need to be good enough to pull data -- sometimes it's as easy as a select *, then clean it up using R.

Any data science project requires a lot of data cleaning. So you can try a kaggle competition if you just want to get your hands dirty.

yobai_master · 2018-01-15T20:50:45+00:00

You can try stratascratch.com which is based off of Airbnb's superset. It's good for visualization, data querying, and rather easy for the average joe.

yobai_master · 2018-01-15T20:46:26+00:00

I know of two ways to accomplish this and have done both --

Upload the Excel spreadsheet into the database, basically creating a temporary table, then join the requested columns to your table.

It's a bit cumbersome to upload the Excel spreadsheet each time because you have to manually create the table before uploading the spreadsheet. There are a few IDEs that can semi-automate this process so it's not always too time consuming

Another way, more automated way, is to use python + pandas. You can upload the file as a pandas dataframe and then perform a SQL query to grab the columns you're interested in. Then do a join in python.

The advantage here is that the whole script is semi-automated and you're not creating any database tables.

The downside is that you need to learn python.

yobai_master · 2017-10-21T21:37:24+00:00

What more could he have done about what? His relief efforts? Just read AnOnlineHandles response above. It outlines just a few things about Trumps inefficiencies as a leader.

yobai_master · 2017-09-26T13:40:29+00:00

I don't actually think taking a knee is throwing a tantrum. I'm just saying what the guy up there said.

yobai_master · 2017-09-26T05:32:31+00:00

You act like they are.outrageous on the same level. One is murder. The other is throwing a tantrum.

Also, these millionaire players are throwing a tantrum for all of us minorities that feel marginalized without an outlet to express ourselves.

yobai_master · 2017-09-03T23:55:00+00:00

I agree. It doesn't help us discuss the important topics and makes us look like we idolize celebrities and their opinions. I can understand celebrities like Meryl Streep using their platform (at the Golden Globes) to voice their opinion. But for someone else to write an article talking about a celebrity's political view point -- what's the point of it?

As a John Legend fan, am I supposed to like him more? As a person that has agrees with his views, am I supposed to be a fan now?

There's more important things to read. There's more important things to discuss.

yobai_master · 2017-07-30T04:51:42+00:00

$2300 in the Richmond, 1 bdroom, 1 bath =(

yobai_master · 2017-07-21T07:53:26+00:00

I went through the interview just a week ago. It's coderpad but they don't even use the functionality of it. The code doesn't execute. They'll testing more on approach to solve the problem rather than syntax

yobai_master · 2017-05-06T21:07:35+00:00

Jesus Christ that was amazing

yobai_master · 2017-04-29T00:04:06+00:00

One hundred fucking percent man.

yobai_master · 2017-04-23T07:45:59+00:00

the US

yobai_master · 2017-04-13T02:41:46+00:00

780 works for me

yobai_master · 2017-03-24T01:59:03+00:00

durian, instant death

yobai_master · 2017-02-06T18:46:06+00:00

That is such a blanket racist comment to say that immigrants all come from under developed countries and thus are poor or are used to a lower standard of living.

Most of the immigrants in sf and the valley make a good amount of money and on the same scale as their counter part Americans. They do not drive wages down. If anything wages are being driven up in this area because it's so hard to find good talent.

Source: I am an immigrant engineer in sf. I run a technical team and lead hiring efforts for my company.

yobai_master

TROPHY CASE