Welcome, Guest: Register On Nairaland / LOGIN! / Trending / Recent / New
Stats: 3,171,205 members, 7,880,745 topics. Date: Friday, 05 July 2024 at 05:36 AM

Noob03saibot's Posts

Nairaland Forum / Noob03saibot's Profile / Noob03saibot's Posts

(1) (2) (3) (4) (5) (6) (7) (8) (9) (10) (of 27 pages)

Programming / Re: Chronicle Of A Data Scientist/analyst by noob03saibot(m): 3:13pm On May 23, 2020
Zabiboy:

After inputing them, click on check first...
Then Next
thanks bro, thanks for being there to respond, I really appreciate it man. Though it didn't work. Had to redo the whole steps again. Thanks
Programming / Re: Chronicle Of A Data Scientist/analyst by noob03saibot(m): 3:11pm On May 23, 2020
Klechman:

Have you found solution to it, I had same issues too. This what I did, first make
Sure you downloaded the MySQL installer the offline package about 400mb not the web package. Secondly uninstall any sql and download the 400mb own, thirdly while downloading make sure your internet connection is on throughout the installation and follow the instructions. Try this out first
dude! Thanks for this. I have been battling with it all morning, Finally had a little break through not to long ago. Firstly, It was the web version I downloaded. I uninstalled every f*cking my sql on my system, except for the raw file I downloaded on my system. Then I had to re install and rerun everything again, I made sure that my internet connection was frigging strong. Because I noticed that the first time I did it that came with that error, my data bundle exhausted, so I had to resub and then continue. This time around I wasn't taking chances o. Subed mtn 1,5 gig and ran the stuff. It went well, only that this time it was the my sql server that was now posing a problem, it came back with reconfigure. Had to do battle for almost 3hrs thanks to Google and YouTube and a huge deal of luck. Even had to go to control panel and admin tools to start changing things. can't even explain what I did. The new head ache now is, updating the start menu link coming back failed during configuration in the installer. Biko I have left it, because I noticed that the mysql editor is working fine at least for now I can log in with a password I created and get busy. And that's what I need. jeeeeeeeeez! Sorry for my bad language and long post. This stuff really messed with me. A huge thanks to you, might eventually try out what you suggested later.

2 Likes

Programming / Re: Chronicle Of A Data Scientist/analyst by noob03saibot(m): 1:00pm On May 22, 2020
Zabiboy:

After inputing them, click on check first...
Then Next
OK thanks, will let you know what happened later. Presently not with my laptop. So I can't try it. Thanks again man
Programming / Re: Chronicle Of A Data Scientist/analyst by noob03saibot(m): 11:50am On May 22, 2020
Zabiboy:



Input any username and password you like in the space below
One you can remember
brotherly! Nothing happened after I typed them in
Programming / Re: Chronicle Of A Data Scientist/analyst by noob03saibot(m): 9:53am On May 22, 2020
Zabiboy:


One or two pics would help
then this is what happens when I click OK. Should I go ahead with this new page by filling out the username and password? Or I have to download and install something? Please help

1 Like

Programming / Re: Chronicle Of A Data Scientist/analyst by noob03saibot(m): 9:51am On May 22, 2020
Zabiboy:


One or two pics would help
this is what pops up when I click on the blue word"reconfigure". Please help

Programming / Re: Chronicle Of A Data Scientist/analyst by noob03saibot(m): 9:48am On May 22, 2020
Zabiboy:


One or two pics would help

Programming / Re: Chronicle Of A Data Scientist/analyst by noob03saibot(m): 9:37am On May 22, 2020
Zabiboy:


One or two pics would help
OK let me try uploading
Programming / Re: Chronicle Of A Data Scientist/analyst by noob03saibot(m): 3:49am On May 22, 2020
Hi guys! Please I am having some issues installing mysql, when I try to run it, under product, samples and examples it shows reconfigure which is click able. When I click it, it says: No compatible servers were found. You will need to cancel this wizard and install one. Please how do I solve this burning issue? Thanks

1 Like

Programming / Re: Chronicle Of A Data Scientist/analyst by noob03saibot(m): 2:17pm On May 20, 2020
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.

1 Like 1 Share

Programming / Re: Chronicle Of A Data Scientist/analyst by noob03saibot(m): 7:43pm On May 15, 2020
brashear:



It's .txt and it works! Thank you.
we thank God
Programming / Re: Chronicle Of A Data Scientist/analyst by noob03saibot(m): 4:30pm On May 15, 2020
brashear:
Please guys, I am using Microsoft Excel 2010 with no power query add-in and I have data in a text file I want to transform and import to excel. How do I go about this?

PS. I have a Power BI desktop installed on my laptop and I have queried google if I can export to Excel but it seems one can only export dashboards.
is the text file in csv format? And you want to work on it in excel. If so, go to data ribbon, from text, import text file, leave it on delimited ( characters such as commas or tabs separate each field), next: it will ask you to qualify your delimiter, unclick tab and click the delimiter in your document ( the delimiter could be tab, space, comma, semi column) then click on finish. I guess this is what you should do, if it doesn't work bro, the senior men in the house will have to help you out.

2 Likes

Programming / Re: Chronicle Of A Data Scientist/analyst by noob03saibot(m): 7:25pm On May 14, 2020
Kaycee54321:


I don't know if I fully understand your question but I hope this helps.

I didn't use a pivot table. I simply cleaned the data from 1st pic then decided I wanted to compare cases in Italy and US so I created a cleaner data (pic2) containing only US and Italy from all the other countries in pic 1.To get that graph, I simply highlighted the new data set and selected a graph from "recommended charts".

I mostly use pivots when I want to select maybe "Top Ten Salesmen" from a hundred sales men then add slicers to select by region,by product or any other category. I hope this helped. Apologies for the unclear pics. I was in a rush.
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.
Programming / Re: Chronicle Of A Data Scientist/analyst by noob03saibot(m): 5:50pm On May 14, 2020
Kaycee54321:
Timeline series below showed Death rate increased dramatically from the 12th of March in Italy with a relatively gentle upward curve.
However in U.S., it increased from 18th March at a very sharp upward curve showing that as time progresses, U. S. would overtake Italy in number of COVID-19 deaths.

With time, U. S. would possibly overtake Italy in number of deaths. Hoping a cure is found soon for all of us.

Modified: It's even on front page. They did so today. May we overcome this. CASES please. Not Death oh. Num of CONFIRMED CASES. Erroneously used Death instead of Cases while working with the data.

good day, please how did you go about arranging the dates in the pivot table? I have never come across a dataset with dates set horizontally, most of the ones I have tackled are all arranged vertically. So it's very easy for me to handle them by fitting them into rows. Here the dates are arranged in columns, almost 40 columns, and that is looking really impossible to fit into my laptop screen and pivot table. Please how did you go about it? The first thing I did was remove blank rows, searched for duplicates after that, tried creating the pivot table. But the dates were messing me up. Please Note! I am using excel too

1 Like 1 Share

TV/Movies / Re: Who Is Your Favorite Film/Series Character Of All Time? by noob03saibot(m): 4:24am On May 10, 2020
Kingluqman:
Any day
It is Wentworth Miller (Michael Scofield)

I remember one of his quotes “Preparation will only take you so far. After that you gotta take a few leaps of faith”.



White boy... you a king.
I wish I could like this post of yours 10 times

1 Like

TV/Movies / Re: What Movie Are You Watching Now? by noob03saibot(m): 6:25pm On May 04, 2020
Beorn:


You've just awoken some deep memories within me. I watched this movie circa 2005 and loved it to bits back then. Used to vibe to Hardball by Lil Bow Wow Ft. Lil Wayne, Lil Zane and Sammie which was its OST.

Hard to dive deep into my music archive in my HDD to fish out the song and blast it in my room tonight. Good memories. When "you know who" (let me not mention name to avoid spoiling it) died towards the end, I cried silently back then. It really touched me.

Damn, I love this movie. For old times sake, I'll look for it and download it again. Don't care about its low rating.
when lil bow wow was actually lil bow wow. That kid could flow Sha. Then Lil wayne hadn't dropped da Carter three. Used to hear that hard ball song back then every Sunday afternoon on radio. Ha! Good times.
Health / Re: 14 New Cases Of Coronavirus In Nigeria. Total Of 288. 7 Deaths. 51 Discharged by noob03saibot(m): 3:36am On Apr 10, 2020
Angy55:

Yes
just want to get this straight, was it the udu person that died? And was it at udu or oghara he finally died? Abit worried cause I have folks in udu. And please, the other case, that is the other person being isolated now, do you have any knowledge of what part of the state he was discovered before he was taken into isolation? Sorry for my many questions.
Music/Radio / Re: What Music Are You Listening To Right Now? by noob03saibot(m): 4:43am On Apr 06, 2020
JaceBlaze:


Which one is that?
Cradle to the grave soundtrack, the song came on at the end of the movie when the credits were rolling. Try and hear it if you haven't. And my second best from him, I miss you ft faith Evans. DMX was fire abeg
Music/Radio / Re: What Music Are You Listening To Right Now? by noob03saibot(m): 5:38pm On Apr 05, 2020
JaceBlaze:


That came out in 1998.

"We right here" is my favourite.
Right or wrong.

1 Like

Programming / Re: Chronicle Of A Data Scientist/analyst by noob03saibot(m): 4:44am On Mar 28, 2020
voraz:


Since you have it already, could we link up and I get it from you?
15gb isn't beans tongue
I tried downloading it, but I couldn't. It kept redirecting me to another page. I spent the whole day trying but to no avail. Didn't want to post about my plight cause the op said its like we are derailing and hijacking the thread. So I kept mute.
Programming / Re: Chronicle Of A Data Scientist/analyst by noob03saibot(m): 5:06pm On Mar 26, 2020
quote author=Shepherdd post=87788878]

Nice starving yourself from PyCharm it will really help you. Remember when I had to abstain from IntelliJ and I was using Notepad++ for my coding although it was a pain in the beginning but it cemented the little basics.

Jupyter also performs little code completion by pressing the tab key like when you want to access a method from an object or reference a declared variable and it is less Ram hungry compared to PyCharm. wow! I never knew this, I will try it right away, that's a plus, a really big plus in my books to jupyter. Thanks man.

And yeah! I feel you in that area of abstaining. I feel it's the only way, though at first it won't be easy, like what I am experiencing now.

[/quote]

1 Like

Programming / Re: Chronicle Of A Data Scientist/analyst by noob03saibot(m): 11:47am On Mar 26, 2020
Toppytek:


Udemy Dey para lol.
guy, dem no get choice. Lol
Programming / Re: Chronicle Of A Data Scientist/analyst by noob03saibot(m): 11:46am On Mar 26, 2020
javaRookie:
If you need where to download programming torrent files visit this link freecoursesite dot com
Download everything you need before udemy sues them like they did to the others.
thanks for this. It's posts like this that makes me smile. If you see the speed at which I used in opening it, usien bolts dey learn for where I dey. Keep dropping posts like this. Thanks.

1 Like

Programming / Re: Chronicle Of A Data Scientist/analyst by noob03saibot(m): 4:16am On Mar 26, 2020
Abcruz:


Pycharm was described as the most intelligent IDE and that's what I prefer to use compared to others.. The colorful coding gives you an exciting view of programming I advice you to stick with Pycharm if you're not finding Jupyter enjoyable.
I agree with you wholeheartedly with this. What I intend doing is to starve myself of pycharm for a week or two and force myself on jupyter. Pycharm is like driving with an automatic whereas jupyter is like driving with a manual in terms of punching out the codes. If after a week or two and I am not still feeling it, then would learn how to and start importing and working with libraries on pycharm. But for now will endure.
Programming / Re: Chronicle Of A Data Scientist/analyst by noob03saibot(m): 3:05pm On Mar 25, 2020
Abcruz:


You can install both of them there'll be no issues as for the second question, when installing anaconda dont choose "add to my path environment" also choose "install only for me" else you wont be able to install python libraries.
alright thanks man, already done exactly what you said. Thanks. Currently trying to get used to the jupyter notebook, it's learning curve isn't as fun as "darling" pycharm. Thanks again
Programming / Re: Chronicle Of A Data Scientist/analyst by noob03saibot(m): 3:06am On Mar 23, 2020
emoboy4u:
As s programmer, you should learn to search for answers online. StarkOverFlow should be your next best friend. just type some keywords from your question in google, 100% chance your question has been asked before.
thanks. Will do
Programming / Re: Chronicle Of A Data Scientist/analyst by noob03saibot(m): 3:05am On Mar 23, 2020
Oddy16:


You can. I installed both of them, and they are working fine. I suggest you go look up FAQ on anaconda site. They have all the answers to your questions, in fact, I was looking at the guide while I was downloading Anaconda.
thanks for this, I am grateful.

1 Like 1 Share

Programming / Re: Chronicle Of A Data Scientist/analyst by noob03saibot(m): 6:25pm On Mar 22, 2020
Toppytek:


Jupyter Notebook
please bro, I will like to ask two questions, is it possible for me to download anaconda, jupyter notebook on my system while I have pycharm installed too without having any issues or I should first uninstall pycharm ? The thing is, I started with pycharm last month and I will like to switch over to jupyter. And in the advanced option page when installing anaconda, should I click on add anaconda to my path environment variable, or leave it as it is? Thanks in advance

2 Likes

Programming / Re: A Python Program To Check The Risk Of Corona Virus. by noob03saibot(m): 3:41am On Mar 14, 2020
Want to ask, in the risk variable, why were you multiplying fever, cough and sob by 2 and then leaving out the rest? Please Would like to know
Jobs/Vacancies / Re: Strictly For Those Interested In Teaching Jobs by noob03saibot(m): 11:52am On Feb 29, 2020
ONNYX:


No need to quarrel with the guy.

You guys have a divergence of views. Thats all there is to it. No need to quarrel bro.

I tend to relate with his position. I disagree that the economy is the cause of the problem.
Several factors including but not limited to the poor quality of products being churned out by the system.

Business owners including School owners should be regarded as heroes because keeping the school or business running is no easy feat in this economy.

I propose that people should just use the schools as a stepping stone to greater heights.
OK brother. I won't argue with him no more. Exactly what I did, I used them as a stepping stone. Thanks
Jobs/Vacancies / Re: Strictly For Those Interested In Teaching Jobs by noob03saibot(m): 9:39am On Feb 29, 2020
ASPIREX:


Another very ungrateful fellow here.

You joined the staff. The pay was bad even from day one....yet you still joined. No dignity whatsoever.

You used their paltry money to fund your search for something better. You also gained some experience in teaching or maybe in human interaction.

And after all said and done you did not benefit anything from working there. Not even a friendship or association.

Wow!
you are in no position to judge me. I don't remember mentioning you, so why mention me? You can go ahead and employ staff and pay them 18,000 a month if you so wish and be tagging friendship and experience to it. Good luck

2 Likes

(1) (2) (3) (4) (5) (6) (7) (8) (9) (10) (of 27 pages)

(Go Up)

Sections: politics (1) business autos (1) jobs (1) career education (1) romance computers phones travel sports fashion health
religion celebs tv-movies music-radio literature webmasters programming techmarket

Links: (1) (2) (3) (4) (5) (6) (7) (8) (9) (10)

Nairaland - Copyright © 2005 - 2024 Oluwaseun Osewa. All rights reserved. See How To Advertise. 67
Disclaimer: Every Nairaland member is solely responsible for anything that he/she posts or uploads on Nairaland.