₦airaland Forum

scave:
https://scave222.github.io/covid19statistics/

check out my covid19 stat

This is beautiful. Nice work

Afoskalex:
Please, can you share the link or the name as you typed on YouTube because when I typed Bucky Roberts, it was bringing channel not relevant to programming. Thanks

Here is a example
https://www.youtube.com/playlist?list=PL6gx4Cwl9DGAcbMi1sH6oAMk4JHw91mC_

So just testing this racing barchart on Covid 19 .
Thanks to flourishApp.Though replicating on Tableau soon

https://app.flourish.studio/visualisation/1911216/

Toppytek:
@ejiod and others here, have you ever considered working remotely for foreign based companies? Though am a baby data scientist but am looking forward to working remotely with those kind of companies for I believe their pay is good compared to what one might be getting here.

Combining remote work with my office duty is something I can’t cope with. Office work is mental tasking.

mcemmy0z:
Please can you give more insight on gretl , I saw a dude using it for data analysis and machine learning, haven't gotten much information on it from Google.

Use it once but that’s like 2 years ago.
It’s a light weight statistical tool. Rapid miner is way ahead of it

For enthusiasts and newbies on data science.
Rapid Miner is a fast tool for analysis. You can download a free trial or use the web app for fast explorative and fast ML.

javaRookie:
I learnt java from that guy! What in the world happened to him? He actually gave me the beginners steps in programming. Although he is a little bit playful, once I grabbed the basic concepts which he thought I upgraded to a more technical YouTube channel.

He’s a big dude now...

Evanspaul:
A programmer that doesnt know bucky haven't started programming. the guy has tutorial on every course.

The guy is damn too good.
He’s a director @ LH Ventures.
I’m sure he had to give up his YouTube channel.
The dude made JavaScript look simple back then.

How many of you guys missed Bucky Roberts. The newboston dude? To me he’s the greatest tutor on programming languages

Evanspaul:
sir @ Ejiod I have been following this trend since last year,
am inspired by your work and what you are doing in this trend
am a data scientist and also analyst, but am finding it hard to get a job, am an undergraduate @ UNN. Most companies I have applied for said that u have to be working there full time and are not remote.
I need your advice on what to do.
If one have a skill and is not using it to make money its discouraging.

I understand your point.
Dear now you understand the in and out of data science. My advice is for you to complete your program 1st. Add web development skills to it. Try learning JavaScript,HTML or CSS. Use the web development skills and apply too. Most firms wants full time not part time or remote. It’s only startups that would give you a remote option.


Lastly apply to upwork.

KunSegzy100:
Experts in the house please help see to this issue, I just pip installer Numpy, Pandas and jupyter so as to start learning using Pandas for analysis, I opened a new folder stores the file to be processed, navigated to the folder through the CMD prompt and launched jupyter from there. But to my surprise I was not able to import the file until I went on YouTube and saw a video where he added (encoding, "Latin" nrows=(number of rows) I tried it and it worked but I don't understand jack about what I did and why I had to add the encoding in order for the file to be imported on jupyter notebook.

Secondly have been going through some Pandas videos online and 80% of the analysis have seen can be done using excel it Dax function in PowerBI, can someone highlight the important and unique things used during preparing a file for analysis in platforms like PowerBI.

Also, I have been seeing videos where they use Pandas for analysis where they extract useful information from a file for example determining countries with over 5000cases of Corona virus from a dataframe, after getting this separate info, how can this information be stored separately?

Also I'd like to know for those using matplotlib, after getting the visuals what next? Do they export the graph? Generally I just want to know how they gather findings together in Pandas for purpose of reuse or continuation of analysis in other platforms.

Pardon my questions I am inquisitive by nature at things I don't know. God bless you for answering

Most time it’s advisable to point your pandas to the directory so it reads it not via the cmd. Press Tab + I to see the documentation of the read_csv

So true

KunSegzy100:
please help rate and review the visual report made through PowerBI. I am still a learner with just two weeks of self training. Thanks

Awesome but modify the coloring

Using Spectranet and Airtel. To be fair they have been shitty. Just don’t understand why after paying for a service you don’t get what you paid for.

Blesser28:
hi guys
this of topic

im having issues installing and activiting ms office
esp the activitng part of it


help pease
anyone who gat idea if crack file will work

Google kmspico and download it
When installing turnoff your windows defender

Sulele04:
I have opened jupyter notebook in my browser but I don't know how to use it can u pls guide me on how to use it... Also I have checked the conda activation documentation the truth is I don't really understand what it is saying

On your command prompt or terminal type

jupyter notebook


To open the anaconda studio type

anaconda-navigator

Sulele04:
Hello everyone... I downloaded anaconda framework and installed it yesterday... I integrated it with pycharm...I can load libraries like scipy,numpy etc but some are not loading Eg matplotlib ... So I decided to go to anaconda installation folder I clicked on the python interpreter that came with it.. It opened but showed "this python interpreter is in a conda environment but the environment has not been activated"... Pls can someone tell me the step to take to activate it ... It anaconda 3 by the way
Cc Javanian Ejiod

Run source activate on your environment....

Take a look at the documentation
https://docs.conda.io/projects/conda/en/latest/user-guide/tasks/manage-environments.html


Lastly why not do Jupyter notebook than pycharm...
Try importing the library with notebook let’s see if it works

RealTrump:
Please oh, gurus in the house. I am stuck with that covid data challenge.

import pandas as pd
import numpy as np
import seaborn as sns
import matplotlib.pyplot as plt

covid = pd.read_csv('c:\\users\\bola\\desktop\\covid19-april-4.csv')
covid

filter_for_cases_greaterthan_5k = covid.TotalCases > 5000
covid[filter_for_cases_greaterthan_5k]

question
How can I plot the variable filter_for_cases_greaterthan_5k against in the countries. I have tried severally, learned a lot about data cleaning in the process but I think it's just my syntax that is wrong.

I can find my way around seaborn, I can filter the data (as seen in the screenshot). I don't know how to plot the data. I am desperate to complete my first data science challenge. I don tey for this python thing small.
@ejiod, ibromodzi, mcemmy0z:

Use groupby then cast your country column.
After that save it as a variable and plot it.

lymelyte:
looks like it is for undergrad..especially the comp science

Yup

For newbies wanting to get a degree in computer science. I believe this link below is helpful. It’s a tuition free online university based in United States. I implore enthusiast wanting to get a foreign degree should apply.

PS: I’m not their advocate. In fact 2 of my dear friends just got admitted. Once applying you will be asked to make $65 applications fee. If you don’t have be sincere and tell them you don’t have.

Meanwhile google the school and do your research before going ahead with it.

Also you need internet and Laptop as a requirement too.


https://www.scholars4dev.com/3630/free-online-education-at-university-of-the-people/

If you have been working on Tableau lately. This resource will be helpful to you.
Would have attached the Tableau file but the limit here is 200k. So follow the link here
https://www.tableau.com/covid-19-coronavirus-data-resources

I find the link very useful for newbies or expert on Tableau

DAY 1: GET DATA

Task one was to pull the data directly online rather than downloading.
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 = {'user-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've been working on the data I downloaded 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.

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

Please can we shift away from PC or laptop requirements or big data or small data and try not detailing this thread.
Was thinking newbies or intermediate folks would come out with some solution based of the data. Just few though . Let’s keep this thread on data related issues

tescoman90:
Bro I want to get a laptop too and my current laptop is HP but I saw some lenovo product but I want to know if lenovo is cool cuz I have only used HP .

Thanks

I’m not a PC fan but will prefer Dell to Hp

damtan:
Honestly, I'm a bit confused. There seem to be too much to learn before one can become a data analyst.
Is it python programming first?? Excel?? Visual tools like tableau sql Pandas
Where do I start from Is there a step by step guide??
I have already downloaded almost all the tools needed to start learning. I am currently learning the basics of python (simple coding). Currently using anaconda (spyder(I love the interface) and jupyter mostly ) a pdf book on python I downloaded online with some videos too. ;I haven't even gotten to the data analysis part.
I have reasonable previous knowledge of excel and zero knowledge of tableau (though I have also downloaded videos on this but I haven't started learning).
Where exactly do I start from?? Am I on track?? Biko, help me!!!

Yes python n sql are programming languages

iCode2:
I'll soon get an 8gb ram hp, core i7. Hope that's okay? Ps: it's not brand new.

Awesome!

Kaycee54321:
OK Boss. Please which Mac exactly do you recommend?

MacBook Pro

Kaycee54321:
OK Bro. Will upgrade once and for all to that 16GB when the time is right.Thanks again.

Mac is better

tescoman90:
Bro can you give me specification for PC to use?

Get 8Gb RAM.
Using 4Gb RAM will be slow.

Kaycee54321:
Thanks Boss. I tried downloading Power BI but it slows down my system badly and it doesn't load at all after installing.Please is there any fix? I will try Tableau today.

It’s a RAM consuming app same as tableau.

lymelyte:
please i need help from all the gurus here.. I have a problem learning and understanding the logic on programming language(python). Memorizing and learning the syntax is no problem for me but the logic.. Please i need a solution to this. How do i go about this.. I need help. Any recommendation would be appreciated..

I was once like you .
Tactics to learn(Triple P): Play the video for 10mins.Pause it and Practice for 30mins.

Meanwhile don’t force it but key in determination. Don’t cram it. Understand what you are doing.