NewStats: 3,261,358 , 8,173,781 topics. Date: Thursday, 29 May 2025 at 12:18 AM 264dz

Please can you recommend any book or video to learn excel for someone without prior knowledge to it

Ejiod:

Where is the error coming from and how’s your data like?.. can you make use of seaborn?

I'm trying to compare the number of confirmed cases in the US, and Nigeria. The data is in 2D array. The error is with the dates, trying to figure it out. Seaborn? I'm currently learning it on datacamp. I don't mind if you could put me through with seaborn. I appreciate your efforts.

Chukwudaalu:
My battery lasted up to 4hrs then, before I spoilt it. Now, it works with light

How did you spoil it? So that I'll take caution too.

Apologies sir, Ejiod.

BoleAndFish:
How did you spoil it? So that I'll take caution too.

Apologies sir, Ejiod.

Always putting it on sleep mode to charge then. Please don't let us derail from the topic. You can send a private message for further enquiries.

Chukwudaalu:
I've been working on the data I ed through the link you posted. I had to extract, and rearrange the needed data on Excel, then load the data using Pandas on python. But I'm currently stuck on visualizing the data with a chart using matplotlib. Been getting errors since, not giving up though. I successfully did the analysis on Excel. But I am currently working on analyzing it using matplotlib too.
I'm actually working on some other programming projects outside Data Science, reason for the delay. Thanks bro.

You could have used pandas for cleaning the data, it does it like magic... Matplotlib sucks for visualization, I used plotly for that, the only problem I'm having is saving my figures since it doesn't work like matplot and seaborn...

If you want to see my solution, I can drop the ipynb file in your mail.

DAY 1: GET DATA

Task one was to pull the data directly online rather than ing.
Some using jupyter notebook I already have it on the ipynb which you can always rerun.Also the excel file of the data. The data is dirty which needs to be clean


To get online data use this,

from bs4 import BeautifulSoup
import requests
import pandas as pd
s = requests.Session()
s.headers = {'-agent': 'Corona'}
page = s.get('https://www.worldometers.info/coronavirus/')
data = pd.read_html(page.text)[0]
data.to_excel('Corona.xlsx')

Will continue tomorrow.

Chukwudaalu:
I'm trying to compare the number of confirmed cases in the US, and Nigeria. The data is in 2D array. The error is with the dates, trying to figure it out. Seaborn? I'm currently learning it on datacamp. I don't mind if you could put me through with seaborn. I appreciate your efforts.

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

gargoylern:

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

I still want to try all possible solutions before bringing it out. I will sure inform the house if error persists. I so much appreciate.

ibromodzi:


You could have used pandas for cleaning the data, it does it like magic... Matplotlib sucks for visualization, I used plotly for that, the only problem I'm having is saving my figures since it doesn't work like matplot and seaborn...

If you want to see my solution, I can drop the ipynb file in your mail.

I wouldn't mind bro. I've sent you a private message.

Kaycee54321:


Wow. 4GIG RAM isn't enough for them?

I use HP notebook 15 4gig Ram and power BI works just fine... I ed mine from the Microsoft store... its is about 360mb+

damtan:
Who knows where I can data to use for tableau practice??
Or if anyone can a set of data to

do u have any data wrangling skill with any of the programming languages such as Python Or R?

mcemmy0z:
If you reside around songo Ota I have these available
*Udemy - Beginner to Pro in Excel Financial Modeling and Valuation
*Udemy - SQL - MySQL for Data Analytics and Business Intelligence
*Tableau 10 A-Z Hands-On Tableau Training For Data Science!
*Tableau Hands-on Learn Data Visualization with Tableau
*Udemy - Power BI A-Z Hands-On Power BI Training For Data Science
*Udemy - Machine Learning A-Z™ Hands-On Python & R In Data Science
*Udemy - Python for Financial Analysis and Algorithmic Trading

Bro I stay in Sango, and I need them badly... Please how should I you?? Will you drop your number or should I PM you??

petux:


Bro I stay in Sango, and I need them badly... Please how should I you?? Will you drop your number or should I PM you??

Ejiod:
DAY 1: GET DATA

Task one was to pull the data directly online rather than ing.
Some using jupyter notebook I already have it on the ipynb which you can always rerun.Also the excel file of the data. The data is dirty which needs to be clean


To get online data use this,

from bs4 import BeautifulSoup
import requests
import pandas as pd
s = requests.Session()
s.headers = {'-agent': 'Corona'}
page = s.get('https://www.worldometers.info/coronavirus/')
data = pd.read_html(page.text)[0]
data.to_excel('Corona.xlsx')

Will continue tomorrow.

Every Data tells a story. Here's mine. From the excel file here, I was able to create a simple dashboard in Excel using pivot charts and pivot tables.

Covid-19 started in China. Right now though, they have the highest number of recovered cases in the World and they're currently not even in the top ten countries list with current active cases....Let me not type much. Let the dashboard speak for itself.

wisdomremz:



I use HP notebook 15 4gig Ram and power BI works just fine... I ed mine from the Microsoft store... its is about 360mb+

Let me try again. I just hope it works. Thanks.

mcemmy0z:
If you reside around songo Ota I have these available
*Udemy - Beginner to Pro in Excel Financial Modeling and Valuation
*Udemy - SQL - MySQL for Data Analytics and Business Intelligence
*Tableau 10 A-Z Hands-On Tableau Training For Data Science!
*Tableau Hands-on Learn Data Visualization with Tableau
*Udemy - Power BI A-Z Hands-On Power BI Training For Data Science
*Udemy - Machine Learning A-Z™ Hands-On Python & R In Data Science
*Udemy - Python for Financial Analysis and Algorithmic Trading

wisdomremz:


do u have any data wrangling skill with any of the programming languages such as Python Or R?

Still learning with Python

Chukwudaalu:
I wouldn't mind bro. I've sent you a private message.

Oops.... Email not active, check the updated one

damtan:
Still learning with Python

can u use python visualization library lyk matplotlib, seaborn, plotly?

wisdomremz:



can u use python visualization library lyk matplotlib, seaborn, plotly?

I'm actually working with matplotlib

Hello enthusiasts,

Can anyone please point me to a good YouTube video that major on:

1. Data science with the use of jupyter notebook please.

2. Data analysis with the use of Microsoft excel.

I need am anything please....

No skill is actually a waste sha. Some years ago, out of boredom, I started using Mavis Beacon typing tutor to whirl away time anytime I had nothing doing. I became so good and very fast with typing without looking at the keyboard overtime.
Learning to use Python for data analysis would have been more difficult for me if my typing skill was whack. I'm glad I learnt to type

trigar12:
Hello enthusiasts,

Can anyone please point me to a good YouTube video that major on:

1. Data science with the use of jupyter notebook please.

2. Data analysis with the use of Microsoft excel.

I need am anything please....

For Data Science you can start with this

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



For Data Analysis with Excel, search for “Excelisfun” on YouTube, go through the playlists.

damtan:
No skill is actually a waste sha. Some years ago, out of boredom, I started using Mavis Beacon typing tutor to whirl away time anytime I had nothing doing. I became so good and very fast with typing without looking at the keyboard overtime.
Learning to use Python for data analysis would have been more difficult for me if my typing skill was whack. I'm glad I learnt to type

Till today am still angry with my whack typing skill, more reason I want a system with an integrated keyboard backlight.

Toppytek:


For Data Science you can start with this

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



For Data Analysis with Excel, search for “Excelisfun” on YouTube, go through the playlists.

Thank you bro

Grandlord:
So many driven contributors. Cool.

Anyone on here taking up challenges on Kaggle?

I did Titanic and House Prices, but the one I can defend wella is Titanic. Doing it really exposed me to Data Wrangling and Feature Engineering. I looked up on different notebooks and ed videos from YouTube to help me with it.

trigar12:
Hello enthusiasts,

Can anyone please point me to a good YouTube video that major on:

1. Data science with the use of jupyter notebook please.

2. Data analysis with the use of Microsoft excel.

I need am anything please....

I'm trying to answer no 1 without complicating it for you. You can search Edureka's 9hrs video on Machine Learning, they did a good job there. If you can, please try Kaggle. You will see lots of Jupyter notebooks you can look at to guide you through. Google tutorials on the use of jupyter notebook, Dataquest did justice to that.........https://www.dataquest.io/blog/jupyter-notebook-tutorial/ When you feel you are ready to practice, pick up Titanic competition on Kaggle. There are so many notebooks that will guide you through.
NB: Kaggle can get overwhelming. You may feel lost being there, but continue anyway.

trigar12:
Hello enthusiasts,

Can anyone please point me to a good YouTube video that major on:

1. Data science with the use of jupyter notebook please.

2. Data analysis with the use of Microsoft excel.

I need am anything please....

The beginner friendly video I watched that introduced me to jupyter was Mosh's YouTube video on Python, the section where he discussed Machine learning.

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

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

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


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

Oddy16:



The beginner friendly video I watched that introduced me to jupyter was Mosh's YouTube video on Python, the section where he discussed Machine learning.

Yea I am at that section but he didn't really explain it deeply, I want a more detailed video that was why I asked, thank you

Oddy16:


I'm trying to answer no 1 without complicating it for you. You can search Edureka's 9hrs video on Machine Learning, they did a good job there. If you can, please try Kaggle. You will see lots of Jupyter notebooks you can look at to guide you through. Google tutorials on the use of jupyter notebook, Dataquest did justice to that.........https://www.dataquest.io/blog/jupyter-notebook-tutorial/ When you feel you are ready to practice, pick up Titanic competition on Kaggle. There are so many notebooks that will guide you through.
NB: Kaggle can get overwhelming. You may feel lost being there, but continue anyway.

Thank you, I will check it out