my best guy on youtube..His explanation is precise and understandable.

Oddy16:


Have you tried Mike Dane's (Giraffe Academy) video on MySQL?.... I learnt with it.


https://www.youtube.com/watch?v=HXV3zeQKqGY

engrjoe:
Hi guys please I need assistance on Data analysis. I am currently using youtube to learn SQL but I am not getting it well enough but I am very interested. Anyone around Ijaye, Kola, Alakuko, Tollgate or Sango area (Lagos) who can help me please.

Thanks you

for MySQL, I think I can assist you remotely (WhatsApp) provided you can pay for my data. If you aren't comfortable with this, watch the videos recommended to you and the formal, then quote me so I can drop my Digit.

lymelyte:
my best guy on youtube..His explanation is precise and understandable.

I'm telling you bro. I learnt Python too with his tutorial. I intend learning C++ from him too. My problem is that he doesn't make much videos.

Some people here are struggling with mysql tutorial and here I am struggling with mysql installation.

.

Olamyyde:
Some people here are struggling with mysql tutorial and here I am struggling with mysql installation.

How can we help?

Oddy16:


Have you tried Mike Dane's (Giraffe Academy) video on MySQL?.... I learnt with it.


https://www.youtube.com/watch?v=HXV3zeQKqGY

Yeah I actually have this video and that is what I am using. The set up part is my problem. I have reached 1hour of the video but havent been able to advance well enough. Is there a way I can reach u on WhatsApp pls

dauddy97:

for MySQL, I think I can assist you remotely (WhatsApp) provided you can pay for my data. If you aren't comfortable with this, watch the videos recommended to you and the formal, then quote me so I can drop my Digit.

Ok bro. I will send u a mail right away. Kindly reply so I can drop u my digits.Thanks

Olamyyde:
Some people here are struggling with mysql tutorial and here I am struggling with mysql installation.

U are not alone bro. Having same challenge though I have installed Mysql already and Popsql

engrjoe:


Yeah I actually have this video and that is what I am using. The set up part is my problem. I have reached 1hour of the video but havent been able to advance well enough. Is there a way I can reach u on WhatsApp pls

You can send me a mail

Oddy16:

How can we help?

I get this error when installing mysql server

Hi Guys - I have an excel list of about 100 countries all over the world, and need to group them into specific categories. Is this possible using Excel? For example, I would like for the list to show Belgium, Germany, Switzerland, etc. as 'Europe' and China, Japan, Nepal, etc. as 'Asia'. Is this possible? If so, what are the functions that I need to use and how do I set it up?

Any help is much appreciated!

Olamyyde:
Some people here are struggling with mysql tutorial and here I am struggling with mysql installation.

I think I can help you out. DM

gargoylern:

post your error message here. Someone can tell you a solution.

Abeg help me out Sir .
This is a picture of the code and empty graph. It plotted an empty graph. You can please put me through

A quick question

What's the difference between a data analyst, business analyst and a financial analyst?

mcemmy0z:
A quick question

What's the difference between a data analyst, business analyst and a financial analyst?

Please someone should answer this question biko!
Cuz the thing dey confuse me too

Chukwudaalu:
Abeg help me out Sir .
This is a picture of the code and empty graph. It plotted an empty graph. You can please put me through

You are dealing with a time series data sir. I do not know the insight you are trying to get by using bar chat... try using line chart instead...
Try this... I hope it does what you want

import pandas as pd
import matplotlib.pyplot as plt

filepath = 'covid.csv' #put your file path here
digits = pd.read_csv(filepath)
digits.set_index('Date', inplace = True)
digits.index = pd.to_datetime(digits.index) # this converts the date to datetime datatype
digits.plot() # you can design your chart anyhow you want
plt.show()

Chukwudaalu:
Abeg help me out Sir .
This is a picture of the code and empty graph. It plotted an empty graph. You can please put me through

If you don't understand that code Ibromodzi posted above, you can try this single line code
digit = pd.read_csv('covid.csv',index_col = 'Date', parse_date=True)

It will automatically set the date as the index.
Then you can plot

mcemmy0z:


If you don't understand that code Ibromodzi posted above, you can try this single line code
digit = pd.read_csv('covid.csv',index_col = 'Date', parse_date=True)

It will automatically set the date as the index.
Then you can plot

ibromodzi:


You are dealing with a time series data sir. I do not know the insight you are trying to get by using bar chat... try using line chart instead...
Try this... I hope it does what you want

import pandas as pd
import matplotlib.pyplot as plt

filepath = 'covid.csv' #put your file path here
digits = pd.read_csv(filepath)
digits.set_index('Date', inplace = True)
digits.index = pd.to_datetime(digits.index) # this converts the date to datetime datatype
digits.plot() # you can design your chart anyhow you want
plt.show()

Wow! Thanks a lot my bosses. I will try them out. Thank you

Chukwudaalu:
Abeg help me out Sir .
This is a picture of the code and empty graph. It plotted an empty graph. You can please put me through

I think you got your answers already. You need to know the structure of your dataframe before to plot it. You can set the date as index and then do a line plot.

Help check this code. I am trying to convert the NewCases column [/b]to a float/integer but I couldn't.
My approach
First I removed the commas and empty spaces.
Then I passed an argument to convert the column to float.
When I run the print(astype) command, the column had indeed changed to float64.
But when I run the print(covid.head()), the column is appearing as a [b]NaN n I can't plot.
How to fix this and convert the NaN to an actual number or how to convert a column to an integer while removing any unwanted characters. I [b]specifically [/b]want this approach because in real life, most data would most likely have funny characters that needs removed.

@ Chukwudaalu, mcemmy0z, ibromodzi, Ejiod. You input is definitely valid and appreciated. But I am learning to fix all possible problems that might involve converting between any data type. That's I am just trying to learn to fish rather than being given the fish.

Keky:
Hi Guys - I have an excel list of about 100 countries all over the world, and need to group them into specific categories. Is this possible using Excel? For example, I would like for the list to show Belgium, Germany, Switzerland, etc. as 'Europe' and China, Japan, Nepal, etc. as 'Asia'. Is this possible? If so, what are the functions that I need to use and how do I set it up?

Any help is much appreciated!

Hi there. Data analyst here. You can do that in excel with Pivot tables. But it depends on how your data is formatted. Usually you should have at least two columns in there. One column should be country the other Column should be the continent that country is located in. One you your excel spreadsheet formatted that way, it takes less than 10 clicks to do what you’re looking to do in pivot table.

Ejiod:

Yes python n sql are programming languages

SQL is not a programming language, it’s a query language. Structured Query Language. Python is a programming language

RealTrump:
Help check this code. I am trying to convert the NewCases column [/b]to a float/integer but I couldn't.
My approach
First I removed the commas and empty spaces.
Then I passed an argument to convert the column to float.
When I run the print(astype) command, the column had indeed changed to float64.
But when I run the print(covid.head()), the column is appearing as a [b]NaN n I can't plot.
How to fix this and convert the NaN to an actual number or how to convert a column to an integer while removing any unwanted characters. I [b]specifically [/b]want this approach because in real life, most data would most likely have funny characters that needs removed.

@ Chukwudaalu, mcemmy0z, ibromodzi, Ejiod. You input is definitely valid and appreciated. But I am learning to fix all possible problems that might involve converting between any data type. That's I am just trying to learn to fish rather than being given the fish.

Why not first cast it to string
covid['Total Case'] = covid['Total Case].astype(str)

When you are done removing what you want to remove, you cast it back to the appropriate type.
covid['Total Case'] = covid['Total Case].astype(flot)

I decided to drop this here since the other thread is not really active..... My forecast using Prophet
From the first fig, the number of confirmed cases is likely to go above 1000 in the next 30-50
From the second fig, people get infected mostly during week days with a sharp decline on Friday

ibromodzi:
I decided to drop this here since the other thread is not really active..... My forecast using Prophet
From the first fig, the number of confirmed cases is likely to go above 1000 in the next 30-50
From the second fig, people get infected mostly during week days with a sharp decline on Friday

Nice one bro. But you cannot tell when people were infected for two reasons.
1. Corona virus can stay in the body without you knowing. You might actually have been infected on a weekend, but you only got tested on a weekday. How would you fix this?
2. Testing could take a couple of days. Which means that someone who was tested on a weekend, let's say Sunday, could get the result on the weekday. How would you make your charts more reliable?

@mcemmy0z. I solved the initial problem I have n can now plot. My code was missing a tiny character, is was right all along. The next problem I have is with slicing. Too many countries taking up spaces. I will try to fix it on my own, otherwise i will come ask people here o.

@ibromodzi nice . i like the word "prophet" will check it out.

RealTrump:


Nice one bro. But you cannot tell when people were infected for two reasons.
1. Corona virus can stay in the body without you knowing. You might actually have been infected on a weekend, but you only got tested on a weekday. How would you fix this?
2. Testing could take a couple of days. Which means that someone who was tested on a weekend, let's say Sunday, could get the result on the weekday. How would you make your charts more reliable?

@mcemmy0z. I solved the initial problem I have n can now plot. My code was missing a tiny character, is was right all along. The next problem I have is with slicing. Too many countries taking up spaces. I will try to fix it on my own, otherwise i will come ask people here o.

@ibromodzi nice . i like the word "prophet" will check it out.

Pardon my use of words..... Saying that more cases get confirmed during weekdays is another way to put it which I think is better and more appropriate... Thanks for spotting that out.

MamaOO:

SQL is not a programming language, it’s a query language. Structured Query Language. Python is a programming language

I think there's a grey area there. Some modern SQL variants are turing complete and actually qualify as a programming language.

RealTrump:


Nice one bro. But you cannot tell when people were infected for two reasons.
1. Corona virus can stay in the body without you knowing. You might actually have been infected on a weekend, but you only got tested on a weekday. How would you fix this?

This is also what I was thinking. I think it's even more likely for people to get infected on a weekend, since that's when they go out. I think what the result is most likely showing is that test centers open on weekdays and so put out results then.

gargoylern:

I think there's a grey area there. Some modern SQL variants are turing complete and actually qualify as a programming language.

Uhmmm, is love to know which variants that is. I’m genuinely curious. I use PL/SQL (Oracle) for work and while I can use loops and structures in my oracle queries, it’s an appendage an appendage to the original SQL.

The types of compiling I can do with programming languages like C#, C++ or even python, I can’t do with SQL

Please, we, the newbies, will appreciate if more people working in the field of data analysis/ data science upload actual work done with these data science tools.

It's easy to say go and learn python + SQL but we will learn faster if we can see the actual applications in real life work environments. Thank you all. Really appreciate.