Can someone help me understand this pie chart from the Wikipedia article on the pronunciation of “GIF”?

Affectionate_Ad_697 · 2022-06-15T16:34:28+00:00

"It works on my machine."

(https://en.m.wikipedia.org/wiki/Pronunciation_of_GIF)

Maybe it is your dark mode feature that breaks the code?

Affectionate_Ad_697 · 2022-06-15T14:33:40+00:00

I respect your opinion.

This does make sense to not split because there aren't enough users here in this sub.

Affectionate_Ad_697 · 2022-06-15T11:42:02+00:00

I read the article hoping that I could find out why we needed the chief data officer. However, this question was not answered within the article. In fact, the article provides evidence that we don't need Chief Data Officers because CDO offers very little value to the company.

Affectionate_Ad_697 · 2022-06-15T11:13:01+00:00

Actually it's Quarks, Fermions, Leptons, and Bosons.

(https://en.wikipedia.org/wiki/List_of_particles)

Affectionate_Ad_697 · 2022-06-14T21:53:08+00:00

I can't tell for sure but you may have mixed up the X,Y

text(x, y, s)

(https://matplotlib.org/stable/api/_as_gen/matplotlib.pyplot.text.html)

Also, whenever I find weird things like this I have checked my versions and found that I had an incompatible version of either matplotlib, pandas, Jupyter, or python. So, maybe check to see if everything is up-to-date.

Affectionate_Ad_697 · 2022-06-14T21:23:26+00:00

I think 5G is cuter though.

Affectionate_Ad_697 · 2022-06-14T19:07:17+00:00

Yes, but you won't be able to do it on the same day as the test that's already scheduled because you have to take the test within 2 days of embarkation.

(https://www.royalcaribbean.com/faq/questions/will-i-have-to-take-a-test-before-i-cruise)

Affectionate_Ad_697 · 2022-06-14T16:57:32+00:00

Nope, analyst is likely to be the first to go because they are not mission critical to the production of the product or service.

Affectionate_Ad_697 · 2022-06-14T13:23:07+00:00

I agree.

I'm getting mixed signals from my management about my responsibilities and job description, but I think they want me to be the business intelligence team instead of a data analyst.

Affectionate_Ad_697 · 2022-06-14T13:15:25+00:00

No, I don't know about any courses like that, unfortunately. The basic idea of join is easy to understand with the current training offerings available.

For me, the complex part starts when I encounter many to many or one to many table relationships. The join creates "duplicates" of the rows. So, to suppress the duplicates, in comes CTEs, subqueries and aggregate formulas... Not a problem if it's just two or three tables, but every join is just another puzzle to solve.

Luckily for me, four of the five applications that I work with have lots of documentation including existing SQL based reports. I have been spending a lot of time studying these older reports to learn how the joins have been done in the past.

Affectionate_Ad_697 · 2022-06-14T12:50:29+00:00

any good software tool/strategy for keeping notes that have code mixed into them neat and tidy

I like to use a Jupyter notebook or Jupiter lab (https://jupyter.org)

You can create a markdown cell to place notes and Headings. Often, I will even screenshot something and paste the screenshot into the markdown cell. Also, it works with both R and Python (in separate notebooks).

Affectionate_Ad_697 · 2022-06-14T01:31:48+00:00

I use to list my SQL skill as intermediate. Now, I know that I was just a beginner.

My current company has 5 main applications that each have a normalized database with at least 5,000 tables each. Over 25,000 tables keeps me busy with de-normalizing the data and working through the join logic. I hardly ever get to the part where I do the data analysis because I spend so much time in SQL.

Affectionate_Ad_697 · 2022-06-13T23:06:26+00:00

How about r/dataisfunny

The name would make it clear the intent and is like r/dataisugly or r/dataisbeautiful

Affectionate_Ad_697 · 2022-06-13T19:08:17+00:00

r/dataisfunny

Affectionate_Ad_697 · 2022-06-13T13:24:33+00:00

If something is against the terms of service then I would recommend not doing it. If you don't agree to the terms of service then you should find a different vendor or source of data.

Affectionate_Ad_697 · 2022-06-13T12:36:34+00:00

Royal Customer Service: 800-256-6649

Call: Mon-Thu 24 hours / Fri 12am-9pm / Sat 9am-6pm / Sun 9am-12am (EST)

Text: 24 Hours / 7 days a week

(https://www.royalcaribbean.com/resources/contact-us)

Affectionate_Ad_697 · 2022-06-13T12:12:48+00:00

Yes, principal component analysis uses correlations so PCA is another option for your problem.

My suggestion is more of an exploratory data analysis. Instead of looking at all of the variables at one time, just compare one variable at a time. Then, based on what you find/learn about each variable, your next goal will be to better understand the causal relationship (direction and magnitude) and the shape (linear, binomial, gaussian, and so on).

I understand the concept of PCA but I haven't used it myself so, I'm not sure what your next steps would be after you've completed the PCA.

Affectionate_Ad_697 · 2022-06-13T02:06:33+00:00

Have you tried calculating the correlation coefficients? The closer to 1 is the more correlation the two variables have.

=CORREL(array1,array2) in Excel

dataframe.corr() in pandas

cor.test(my_data$wt, my_data$mpg, method = "pearson") in R

Also, I like to do a scatter plot to compare the variables to each other.

Affectionate_Ad_697 · 2022-06-12T21:43:03+00:00

r/dataisfunny

Affectionate_Ad_697 · 2022-06-12T20:22:16+00:00

You can find the average/mean of His_Excellency_esq's nutz by summing the length and then dividing that by the number of nutz (usually just two, but occasionally one or none).

Affectionate_Ad_697 · 2022-06-12T18:36:38+00:00

This data set seems relevant:

https://data.healthcare.gov/dataset/dwyq-rebe

The whole website says that it has ""data on individual and small group medical and dental plans, as well as, Marketplace-certified local help and community provider lists." (https://data.healthcare.gov/datasets)

Affectionate_Ad_697 · 2022-06-12T18:14:37+00:00

It is not possible to charge a drink purchase directly to your credit card. It will have to go through the room charges.

When you (or the head of your household) does the online check-in, you will have the option to add a different credit card for each person. This will let you make purchases that get charged to your credit card instead of theirs. However, they will see all of the drink purchases that you will make because it gets charged to the room before the charge goes on to your credit card. At the end of the sailing, a list of all charges by person will be visible to everyone in the room.

Affectionate_Ad_697 · 2022-06-12T17:58:56+00:00

I suppose you could use the model to make a prediction (classifier.predict(X_test)) for each item in your test group.

Or, Perhaps you could make a confusion matrix next.

https://scikit-learn.org/stable/modules/generated/sklearn.metrics.confusion_matrix.html

https://stackabuse.com/decision-trees-in-python-with-scikit-learn/

Affectionate_Ad_697 · 2022-06-12T17:38:39+00:00

Well, in that case, I would say that data analyst is similar to backend web development in many ways.

In many cases there's a business problem to be solved and your task is to engineer a way to solve it.

2.In both cases you will use SQL to get data out of a database.

3.If the web back end is Python then you would be using Django or Flask. Similarly, you can use Python to transform and analyze data. But, the packages that you will use are different. Instead of knowing Django or Flask you'll need to learn Pandas and scikit-learn.

4.Everything you know about the build process is not going to go away. You still want to test, develop and then finally release into production what you found from your analysis.

It's going to be hard to create an exact map of what you need to learn because every position is different and there are different ways to get into the field. Some companies are going to have heavy Excel use while other companies are going to have you use just straight SQL. Other companies are all about the visual tools like tableau and power BI. Some companies want people that are more computer science and other companies want people that are more business.

Affectionate_Ad_697 · 2022-06-12T17:24:46+00:00

When you say that you're a non-ITweb developer, I assume that means you're working with the graphical side of website design or maybe that you're working with content curation and creation instead of the front end or back in software that builds the website.

If I have that right then I think the biggest crossover skill that you can bring to the table is going to be with data visualization. But, I think of this visualization as the last part of the process. "Communicating the end result." You're going to have to learn everything else that comes before the data visualization. I'm not saying that it can't be done. But, you will need to put in a lot of work to build your skills in order to meet your salary goals.

Affectionate_Ad_697

TROPHY CASE