Ejiod:

Awesome but modify the coloring

Bawsse:
can someone please advise me on where to download the ms excel online without any hassle?

Bibitayo2:
Sent

RealTrump:
I beg o, I have a question.
How can I group countries by continents? Mind you, I created the excel file myself and I used sublime to convert the csv file to unicode-8. My suspicion is that my code is right but my formatting is wrong.

However, when I run a groupby code: covid.groupby('continent').TotalCases()
it generates a KeyError: 'continent'

mcemmy0z:

The result you posted shows that the error is not from the code, but from the continent, try changing the continent to "Continent" capital letter C.

Ejiod:

Awesome but modify the coloring

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.

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

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.

Ejiod:

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.

Ejiod:

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

Ejiod:

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.

gargoylern:


different files have different encodings, due to the way they are prepared. The encoding for that file apparently is not the default in pd.read_csv. Sometimes you have to guess the encoding, sometimes they tell you so you know. You shouldn't be too worried about encoding at this stage.
Thanks very much bro



You store it in another dataframe. You can create as many dataframes as you want as you go along. As a beginner, this may not be a problem. But as you advance, you'll realize the importance of saving memory or managing memory, so you'll be able to work better with dataframes.


Yes, you export the plot. After importing Matplotlib.pyplot as plt, you can use plt.savefig() can save your plots and export them as pictures to other platforms.

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

gargoylern:


different files have different encodings, due to the way they are prepared. The encoding for that file apparently is not the default in pd.read_csv. Sometimes you have to guess the encoding, sometimes they tell you so you know. You shouldn't be too worried about encoding at this stage.



You store it in another dataframe. You can create as many dataframes as you want as you go along. As a beginner, this may not be a problem. But as you advance, you'll realize the importance of saving memory or managing memory, so you'll be able to work better with dataframes.


Yes, you export the plot. After importing Matplotlib.pyplot as plt, you can use plt.savefig() can save your plots and export them as pictures to other platforms.

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

KunSegzy100:

Thanks boss I knew I would get answers here

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

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

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

Evanspaul:

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

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.