mcemmy0z:
Rough visualization of Nigeria covid-19

Boss, can you please help me with the code you used in getting the required info from the table in ncdc site?

I came up with one but it is giving me all the table data alongside the code in a column..

Can you layout the code for me?

Thank you

Raxxye:

Oh really?
Mine is even 64-bit. So what could the problem be then?

without doing anything, most of the libraries should run automatically so far it is probably installed! I didn't even know the usefulness of anaconda when I first installed it, and everything is working fine... maybe You should uninstall and reinstall again, but this time click "Add Anaconda to your path environment variable" while installing, I hope it works this way.

NB: I'm also a learner.

brashear:


What kind of data have you worked on with PowerBI? my powerbi desktop is extremely slow and it often freezes my laptop.

Baba na learner I still be, I'm still working on python for data science, I haven't moved to visualisation with PBI, but I'm certain it will work fine.
I just got all necessary Packages installed ni.

Dahyormine:
without doing anything, most of the libraries should run automatically so far it is probably installed! I didn't even know the usefulness of anaconda when I first installed it, and everything is working fine... maybe You should uninstall and reinstall again, but this time click "Add Anaconda to your path environment variable" while installing, I hope it works this way.

NB: I'm also a learner.

Thank you

Kaycee54321:


Seconded Boss Ejiod.

Sent you a pm, Bro.
Will appreciate a response.
Thanks.

Raxxye:
Hello Guys.
I want to learn programming. Someone advised Python. I downloaded Anaconda distribution in my pc, but none of the programs is able to run. The guy told me it's because of the Pentium Intel Dual core processor that my system has; that I need a new laptop with a minimum of core i3 processor. I have never done programming aside the FORTRAN77 and a couple of other programming courses I did as an undergrad many years ago.
It's confusing. I need help on what to do.

Go to official python website and download Python, then download Visual studio code, and check YouTube on how to set up VS Code for Python. That should work for you.

Good evening my Ogas. I have issues with my VS code. The "Go live" icon initially didn't appear on my status but soon did...Now, clicking the Go live button does nothing!!...I believe it should be the code that is affecting its normal functioning... I did not expect it to be this difficult to set up VS code since the set up for Bracket was seamless...Hence, I would greatly appreciate if you assist with valuable insights on appropriate settings...I checked online but there's limited answers and the little I saw is not explicit enough...You can also screenshot your settings..Anyway to assist....

P.S I uninstalled and reinstalled but still same issue

Toppytek:


Go to official python website and download Python, then download Visual studio code, and check YouTube on how to set up VS Code for Python. That should work for you.

Many thanks, Bro. I'll try that right away.

I once asked this question...pls how can I deal with repetitive data using Excel..

Working on covid 19 cases in the US,but the data are repeated like 1/02/2020(5 cases),1/03/2020(5 cases),since there is no new case...this has made the total case so high! Reaching like 39 million,pls how can I go about it...I am practicing with the data on Excel..I anticipate your responses.Thanks

Raxxye:

Many thanks, Bro. I'll try that right away.

You’re welcome, in case you want to use python for data analysis then anaconda is the, once u download it, make sure u deactivate any antivirus you’re having on your system before u do the installation and make sure your default browser is updated.

Emmagenius:
Good evening my Ogas. I have issues with my VS code. The "Go live" icon initially didn't appear on my status but soon did...Now, clicking the Go live button does nothing!!...I believe it should be the code that is affecting its normal functioning... I did not expect it to be this difficult to set up VS code since the set up for Bracket was seamless...Hence, I would greatly appreciate if you assist with valuable insights on appropriate settings...I checked online but there's limited answers and the little I saw is not explicit enough...You can also screenshot your settings..Anyway to assist....

P.S I uninstalled and reinstalled but still same issue

Sometimes it's due to de system ram is small.
Well u click on liveserver and it showed it has be created on **** datz de number of de local Host or so
Just type it on de browser
Also make sure u instead de extension live server

This is soo helpful...God bless you. I understand better now

Random walks is basically a random simulation of random variables to produce an output randomly. From my example, the nsteps is the number of times the walk is simulated, that is 1000 times, which means its gonna produce 1000 outputs(walks).
The draws is what I want to output in 1000 times. From my example, the random.randnint(0,2, size=nsteps) means pick a number between 0 & 2, 1000 times.
The 'steps' variable is the where the draws happen, the draws produces 2 outputs, 0 & 1, 1000 times.
np.where(condition, True, False) means if the draw produces 1 (draws >0), return 1, else -1.
This is stored in the 'walks' variable which is a cumulative sum of all the steps in the draws. \

The first pic is the cumulative sum of the first 100 draws while the second pic is a graph of the first 100 draws.

Looking at the first pic, notice how they either increase or decrease by 1 or -1 respectively.
so basically, the whole thing picks 1 or -1 simultaneously and the size is the number of steps, that means, pick 1 or -1 randomly 1000 times. The output could be anything but this is a basic example.[/quote]

Try removing duplicates... select the column and go to the Data tab. Click on remove duplicates. It will give you unique values

Gcool2:
I once asked this question...pls how can I deal with repetitive data using Excel..

Working on covid 19 cases in the US,but the data are repeated like 1/02/2020(5 cases),1/03/2020(5 cases),since there is no new case...this has made the total case so high! Reaching like 39 million,pls how can I go about it...I am practicing with the data on Excel..I anticipate your responses.Thanks

hello gurus, please someone should help me out with this problem hash analytic gave me. please i will be very grateful for any input

thanks

Pprince2:
hello gurus, please someone should help me out with this problem hash analytic gave me. please i will be very grateful for any input

thanks

Any specified software??
Or any data visualization tool is accepted

'

Zabiboy:


Any specified software??
Or any data visualization tool is accepted

pandas,numpy,matplotlib,seaborn,

Pprince2:
hello gurus, please someone should help me out with this problem hash analytic gave me. please i will be very grateful for any input

thanks

Excel and power bi would have handle this pretty well.
Check this out, it will give u some insight.
https://www.datacamp.com/community/tutorials/predicting-employee-churn-python

Evanspaul:

Sometimes it's due to de system ram is small.
Well u click on liveserver and it showed it has be created on **** datz de number of de local Host or so
Just type it on de browser
Also make sure u instead de extension live server

Thank you chief. Though, my RAM is 4GB corei5....I'll try typing it on the browser...

Emmagenius:

Thank you chief. Though, my RAM is 4GB corei5....I'll try typing it on the browser...

if you have installed liveserver the go life in the pic will show.
then if you have installed it and it still doesnt open live in ur browser but it shows that port 5050 down there when you click it, open your browser and type 127.0.0.1:5500
also try reinstalling the Go live extension

Evanspaul:

if you have installed liveserver the go life in the pic will show.
then if you have installed it and it still doesnt open live in ur browser but it shows that port 5050 down there when you click it, open your browser and type 127.0.0.1:5500
also try reinstalling the Go live extension

I very much appreciate your assistance and time chief...God bless you.

wisdomremz:


quote me with your email, i will send the pdf

Please wisdomremz can you send me the pdf.

trigar12:

Boss, can you please help me with the code you used in getting the required info from the table in ncdc site?

I came up with one but it is giving me all the table data alongside the code in a column..

Can you layout the code for me?

Thank you

I encountered something similar to that while scraping the website but I later found my way around it. Quote me with your email, I'll send the code. Alternatively, you can use power BI to get the data. Just put the URL under source.

ibromodzi:

I encountered something similar to that while scraping the website but I later found my way around it. Quote me with your email, I'll send the code. Alternatively, you can use power BI to get the data. Just put the URL under source.

You can as well drop the code so we all could learn.

I’m new here. Learning my first language SQL and it’s been fun so far. I see lots of information in this thread, I can’t wait to explore them

Is anyone here self trained and a beginner?

I would be working on python, R and machine language later on.

Any tips or resources for a beginner would be appreciated

whizqueen:
I’m new here. Learning my first language SQL and it’s been fun so far. I see lots of information in this thread, I can’t wait to explore them

Is anyone here self trained and a beginner?

I would be working on python, R and machine language later on.

Any tips or resources for a beginner would be appreciated

You are doing well. Python is beginner friendly, so I would advise you start with it. From there, you can learn the accompanying libraries like Numpy, Pandas, Matplotlib, Seaborn. Master these then get back here for more tips....My other bosses like Ejiod, EvansPaul, Toppytek are on ground to answer any more questions...God bless...

whizqueen:
I’m new here. Learning my first language SQL and it’s been fun so far. I see lots of information in this thread, I can’t wait to explore them

Is anyone here self trained and a beginner?

I would be working on python, R and machine language later on.

Any tips or resources for a beginner would be appreciated

Wow So you're here too, I follow your YouTube channel and watch most of your videos

Emmagenius:

You are doing well. Python is beginner friendly, so I would advise you start with it. From there, you can learn the accompanying libraries like Numpy, Pandas, Matplotlib, Seaborn. Master these then get back here for more tips....My other bosses like Ejiod, EvansPaul, Toppytek are on ground to answer any more questions...God bless...

Me? Boss keh... Abeg oo, Mesef never sabi much oo

noob03saibot:
thanks for the immediate response. However bro, I might stress you abit, but not to worry, answer when convenient for you. First question : please what steps did you take in cleaning the data? Then another question I want to ask, I actually downloaded the finished covid 19 file you uploaded here and tried studying it because I was confused on how to tackle the analysis. But did you select the countries individually from the picture 1, then create a chat for them individually on different worksheets. Was that how you did it for each and every country? I. E, selecting each country from picture one and moving them to a worksheet to analyze each of them separately? Don't know if you understood me. Thanks in advance.

I don't know if I understand you perfectly. Nevertheless, one method I used in cleaning was using the IF statement in Excel. After manually inserting the missing continents of the countries, I used "If the adjacent cell next to the country = "Africa", return the country next to it" It'll return all countries with Africa and aggregate them together while the remaining will be Nan values, then I copy and paste to another worksheet to analyze the African continent. That's how I did for all the continents. Sorry for the late reply.

whizqueen:
I’m new here. Learning my first language SQL and it’s been fun so far. I see lots of information in this thread, I can’t wait to explore them

Is anyone here self trained and a beginner?

I would be working on python, R and machine language later on.

Any tips or resources for a beginner would be appreciated

Self training and still very much a beginner. I'm also on SQL. Started two days ago though I already have a little knowledge using python and it's libraries. Would love to connect too if possible. I watch your YouTube Videos.

Raxxye:

Sent you a pm, Bro.
Will appreciate a response.
Thanks.

Already did.

Kaycee54321:


I don't know if I understand you perfectly. Nevertheless, one method I used in cleaning was using the IF statement in Excel. After manually inserting the missing continents of the countries, I used "If the adjacent cell next to the country = "Africa", return the country next to it" It'll return all countries with Africa and aggregate them together while the remaining will be Nan values, then I copy and paste to another worksheet to analyze the African continent. That's how I did for all the continents. Sorry for the late reply.

Thanks man! I sincerely appreciate. This has made me see things in a different light. Better late than never, thanks again.