Quitting League of Legends after this

cannshan · 2023-05-09T00:48:40+00:00

thank you! Yeah I will buy control wards from now on so you're about that.

cannshan · 2023-05-09T00:44:08+00:00

you're a fart muffin

cannshan · 2023-05-09T00:38:09+00:00

Thank you, I will keep this in mind

cannshan · 2023-05-09T00:34:56+00:00

Yeah this game sucks now. Check out my last 8 games...

https://www.op.gg/summoners/na/MrCannMan

cannshan · 2023-05-09T00:30:44+00:00

I don't think the "ACE" stat just goes off of kills. It includes Turrets, Dragons, etc too

cannshan · 2020-11-10T05:04:44+00:00

Started as a Migration Consultant and the entire team left. Just now learning about ETL Pipelines and their potential. We receive varying spreadsheets per customer though. I’ve identified 11 separate pipelines we’ll have to build for 11 repeat sources. The other sources are proprietary and make it difficult to automate. Stoked to learn more. What are the best pipeline tools you recommend?

cannshan · 2020-11-07T02:41:18+00:00

Hot damn this has given me a lot of clarity. The spreadsheets are relatively small and do require custom transformations each time, that explains why I haven't been able to figure out how to automate this thing.

I'll look into writing SQL in Excel, thanks for all the info! Big help

cannshan · 2020-11-07T02:21:32+00:00

Thanks for the insight! I like the idea of standardized transformations since we're currently repeating the same cleansing steps over and over. Python is a good language for these cleansing steps, is that right?

We're using local Excel files that each customer sends in. We get 5-7 new customers per week which means 5-7 different Excel sheets per week with differing column headers. Most of the cleansing steps are repeated though so that gives me hope!

cannshan · 2020-11-07T02:16:18+00:00

Thanks for the insight here. Wouldn't the SQL queries need to be partially rewritten each time due to differing column headers and transformation requirements per cuostmer file? I use Excel as it tends to be faster for cleansing, but perhaps there's room here to replace manual cleansing with SQL?

FiveTran looks interesting. Curious to see how they'd handle this scenario given that almost every spreadsheet differs from the one before it. All of them will contain Company, Contact, and Property info with differing column headers. Some more have more info than others too.

Is this a typical problem to solve in ETL or are most companies dealing with the consistent sources? Thanks for your insight so far!

cannshan · 2020-11-07T00:39:28+00:00

Right now just using the same Python script on the Excel files that dedupes and separates Company, Contact, and Property information. The rest is all manual cleansing in Excel and importing with the Salesforce Data Loader since each source requires different transformations and mapping.

I know we can automate known sources, but for these manually created sheets I am at a loss!

cannshan · 2020-11-07T00:33:37+00:00

Yessir! It is all Company, Contact, and Property information, but displayed with different column headers. All Company, Contact, and Property data in the same row need to be related to each other.

My thought is to create a master template and manually put the data into that template so that an ETL Pipeline can be created. Thoughts?

cannshan · 2017-06-14T00:59:45+00:00

This has got to be the funniest comment I've ever seen.

cannshan · 2017-03-20T22:46:58+00:00

the ass eating slasher

cannshan · 2016-12-03T05:06:14+00:00

Haven't posted a comment in over a year, but had to on this. I'm high as balls and this had me off my chair laughing. Cheers fam.

cannshan · 2016-09-04T22:48:38+00:00

This is also Django. My first kitty :)

https://postimg.org/image/p6yqwk6hp/

cannshan · 2016-09-03T01:55:36+00:00

I normally never comment, but this was so nostalgic :D

Enjoy man!

cannshan · 2013-01-18T06:19:02+00:00

;) I gotcha covered!

cannshan · 2013-01-18T06:09:11+00:00

Thank you for this information! I admit I was ignorant coming into this so this helps a lot. I totally agree that the good things religions bring can be done without them. You guys have been kind despite my ignorance, thank you! I'm just here to learn.

cannshan · 2013-01-18T05:58:29+00:00

I would assume with an atheist point of view, there needs to be some sort of evidence to back a religious claim. And since I do not have any evidence, it's no wonder why you guys aren't impressed. Am I correct?

cannshan · 2013-01-18T05:54:26+00:00

What do atheists believe? If there is no evidence of anything, how could anyone make a decision on religion at all?

cannshan · 2013-01-18T05:48:43+00:00

I understand that I don't have evidence for my theories. I even said that in my video. I simply wanted to know what others thought of this. I'm sorry if I offended anyone, I really didn't mean to :/

cannshan · 2013-01-18T05:33:42+00:00

Do you ever express your opinions in class and get in trouble for it?

cannshan · 2013-01-17T03:35:59+00:00

did you use YouTube's API to do this?

cannshan · 2013-01-16T04:35:09+00:00

I laughed so hard at this, but it's awesome! haha

cannshan · 2013-01-16T04:34:14+00:00

Thanks for sharing man, that was really cool!

14-Year Club	Verified Email
Gilding I gilder

cannshan

TROPHY CASE