₦airaland Forum

Manchester Vs Southampton Manchester wins +over 1.5 @ 1.73 Stake your inheritance now

Davidv12:
hope u have staked yours

Sweet nonsense

Oga if you have upto 10k stake this game,you will soon regret that you didn't stake

stop dashing alabi your hard earned money bet ion this:
Sheffield United Vs Chelsea
Draw full time @ 3.95
Stake your future.

nwele2017:
Liverpool Vs burnely next goal Burnley @13.45 odd. stake your family now. Don't say I didn't tell you

oga am not alabi agent. Stake now

nwele2017:
Liverpool Vs burnely Burnley. wins a@12.25 odd stake your entire saves bow

Liverpool Vs burnely next goal Burnley @13.45 odd. stake your family now. Don't say I didn't tell you

Liverpool Vs burnely
Burnley. wins a@12.25 odd stake your entire saves bow

Karleb:
Foreign are the primary key of related tables.

Let's say a Users table and Posts tables has a one to many relationship i.e. A user can have one or more posts. In the post table, you'll have these columns.

Posts
id - primary key
user_id //this refers to the id on the user.
text
pictures

In the users table, you'll have.

Users
id - primary key
name


The work of foreign key is to reference that a particular user is the owner of certain post(s).

When you insert values into the posts, it'll be in this format:

Posts
id - 1 //the ID of the post also the primary
//in posts table
user_id - 1 //this is the primary key on users
// table which refers to the user of
//id 1, but in posts table here it is
// called the foreign key.
text - "SQL is SQL"
pictures - "/pictures/sql.jpg"


So now, a user has a post.

There's a bit more to this though.

this your explanation is quite confusing.
A primary key is unique key
while a foreign key is not a unique key. A foreign key of one table is used to reference a primary of another table when there is reletionship between this table.
This kind of relationship is called one to many relationship.
for example, taking from Data analysis perspective, if we have two tables, customers table and sales table. The customers id column in the customers table shows the unique customers that make purchase everyday, this column has a unique entries (no entry appears twice) and it's called the primary of the costumers table.
now in the sales table we might have a column called customer id or any other thing ,not necessarily costumer id, with entries that are not unique, which can be used to match up the customer id column of the customers table, this column is called the foreign key.
The foreign key is not unique. Its entries appear many times in a column.
For you to better understand it well, just imagine that we have 3 customers in our online store database, and we give them customer id of 1,2,3. This customer id will be unique in the customers table but in the sales table of the customers id this numbers will appaer many times since a customer makes transaction many times, customer 3 might make 4 transactions in a day and in the costumers Id column it appear like this 3,3,3,3. so are

job specification for data analyst role in this country is becoming scary.
A job postingfor role of data analyst has all these Spark, Hadoop, Hive, Pig, SQL, Neo4J, MySQL, Python, R, Scala, Tensorflow, A/B Testing, NLP, anything machine learning ,Bi tools.
These people are looking expertise in everything under sun.
guys please share your experience about job hunt as data analyst or data scientist

look at how this news is generating traffic.
This is Nigeria and everything is scam or intial gra gra.
Tomorrow now he be released on condition that he is the current chairman of EFFC ,and could not be arrested on any ground whatsoever because he has some privilege and case should not be actionable.

Dum20:
Python gurus. Please what is the function of the "0" (Zero) in this command


sampled_df = data[(data['rowID'] % 10) == 0]

You want grab data's where the rowID /10 gives reminder 0.
All the data with RowID's of multiple of 10 (10,20,30...) will be in your new data sampled_df.

ghettokid1:
May Her soul RIPP.....ignorance is a very big disease

Oga, she is not died yet, try to read before spewing thrash with your mouth.
We pray for her quick recover

judedwriter:
Anything pornography is destruction.

Pornography was designed to destroy many destinies physically on earth and spiritually in hell fire.

The reason many still indulge in it is because they are blinded to its destructive tendency. Pornography will destroy you, if not now, later.

Pornography will destroy your finances, your marriage, your peace, your joy, your ministry, your productivity, your progress, your success, your prayer life, your anointing, etc.

It's easy to identify men and women who indulge in porn; they appear depressed, unsociable, irritable, bitter, tired, worn out, lonely, etc.

If you see a poisonous snake, do you pat it on the head? This is what many do to pornography, instead of fleeing for their precious lives.

It is never appropriate to make generalisation from experience. I want put it you that in Nigeria there are more people suffering from depression, irritation, bitterness, tiredness, loneliness caused by poverty than from porn.
In as much as Pornography should be outrightly commended in any sense, it is never appropriate to say that the reason why people suffer from depression, loneliness is because of pornograhy
Pornography over years has envolved and many people consume it like food , and it's negative effect on the society, marriage can not be measured, but I can't jump to conclusion that it's the only reason why people are suffering from depression.

Dips04:
Please I need help with installing MySQL
I tried installing MySQL but it's saying I need to install Visual Studio 2015-2017-2019 redistributable, I searched online but the size is huge 7gb. Please who can help me with this.

The visual studio u trying to download online is different from the one required by mysql. go Microsoft website and download the required visual studio for your system. it's a mere 12mb package

op, you are confusing with your English. change topic to: ''saplat to build" please

lymelyte:
Please check out this double dot csv.is it right?

This is not right, little wonder Pandas could not see it. Have you tried opening it with excel, I doubt it will but try, you should try to download the data again or try opening with winrar to extract the exact CSV file.

Dum20:
[quote author=lymelyte post=91270518]Please I need una help.. Have been trying to import a csv file on a folder in my desktop to python via jupyter notebook but I keep getting errors.


FileNotFoundError: [Errno 2] File Absenteeism_data.csv does not exist: "Absenteeism_data.csv"

I have even gone to stack overflow and try out Solns but the problem still persist[/quote

You are not referencing the right folder where the "Absenteeism_data.csv" file is located.

Share your complete code, we will be able to guide to the problem. But make sure the .csv is in the correct folder you are referencing in your code.

it's either you did not get the exact spelling of the CSV file or it's not in the current Folder where Pandas is looking for it. try to check if you got the spelling correctly and if it's in the current Folder where Pandas is searching for it. These things are the only reason why you could get FileNotExist error. Another reason could be, though it's same as the first reason I gave, the file might not be a CSV file. try and check all these things I pointed out.

Dum20:
So guys i am still a learner. I believe that practice makes perfect.

I am a seller on Fiverr and created a gig related to data science. I plan to share some of the problems that clients submit that they need solved.

We can use it for practice to prepare for actual job interviews and to have an idea of the problems in real world.

So below is the first one i want to share:


I am setting up a spreadsheet to measure lead and lag measures for my staff I have started it but thought it would be better if an expert get it done for me. The nurses will input patient names and then the spreadsheet will count the number of patients The count will then be compared to their target This will occur each workday Each staff member will have two sheets The first spreadsheet will be a record of patients they have invited to care plans for patients with chronic disease The second sheet is for patients that they have actually done the plan on Data will be entered by the responsible nurse For both sheets they have targets to achieve For invitations 9 per day For plans 3 per day Some of the staff work part-time. I put a column in so the nurse can say if they were at work that day or not. The spreadsheet to automatically exclude weekend days The column that counts the number of patients invited/seen should change. If they meet or exceed the target then I would like the cell to be green, if less than the target I would like red If the cell has no data I would like it to be blank I would like the targets to be easily modified so that I can change the target in one cell and that would be reflected across the whole spreadsheet for every nurse For every spreadsheet I would l like two graphs It should display where they should be and where they are at, like the picture below One for the current week and one for the month This should be a template so that we can reset the numbers each month I would then like a dashboard that displays all of the graphs on one page so that the nursing team can compare themselves to their peers. Please don't waste time give me proper answer if you can work.[b][/b]


His budget is $45

I do not understand what he wants self.

This job requires the use of Data validation in Excel spreadsheet. I have done something like this for pharmaceutical store in area. I would like see the copy of the Excel he or she

for me. I can't say I have any regret or not but one thing am sure is that achieved the exact goal I set during my university days. Though at times I do feel that I would been a millionaire if I had pursued the business opportunity I had then, but I realized that business wasn't part of the goal I set.

There is always a demand for people with skills set on these tools but you also need to equip yourself with other tools like:
Advance Excel, Sql, ETL, and also good communication and writing skills then start applying for roles of Data Analyst . the Job for people with this skills set falls into what is called Data Analytics and Business intelligence .this job makes exclusive use of BI tools(Tabulea,power bi , Qlik View)
:

please some body should help with a link of power bi 2018 November update. please I really need it. The recent update is not working on my system.it laggs.

Powerbi is damm slow. I just uninstalled my Tabulea to install powerbi just for me notice that it lags like mad and with poor graphical quality. I hate powerbi, infact, am uninstalling it immediately. tableau is far far better than powerbi in all ramification.

mcemmy0z:
You are so so right on this
They copy each other for their advert. They will be asking for a full IT department skills for a data analyst job

seriously,the situation is pathetic. I even saw an advert for data science where the say 10years experience, I was like, it is not up to 10 years since data science came into prominence.
my advice is that you guys should apply for data analyst job or even business intelligence .na surest way to data science field.

UnbiasedAnalyst:
Greetings,
I've been learning data science using python since February last year and I'm very comfortable using python (pandas, matplotlib, seaborn, sklearn and numpy) for data science related stuff. As a matter of fact, I've completed two online internships and two online courses and I've been apply for jobs online but haven't gotten any invitation for interview expect those from fraudsters. I've completed 4 ML projects where I used svm, decisiontree, randomforest and logistic regression with a very high accuracy

Please I'm wondering if anyone could advice where I can apply to in other to secure a job either as an intern or junior data scientist.

I graduated from a State University 2018 from department of Statistics. I started learning DS right from my final year.

my brother let tell you a little screet .
Most Nigeria employers don't know the difference between data analyst and data scientist. most data analyst jobs in Nigeria are actually data science job. Nigerians have not really understood the difference between this two terms. I will advice you to start applying for data analyst job , but you need to add advance Excel,SQL , tabulea or powebi and some understand of metrics and KPI of domain of interest to your arsenal.

Samzeal:
Please how can this dataset be arranged inform of table for easy access?

Tableau will arrange it automatically for you. Tableau is so powerful such that it can recognise all data that have common attributes and but them in on field for. Also the data is comma separated, it will be easy to read

manuel4real:
Good day nairalanders, I started learning Python some weeks ago and I'm kinda having problems in understanding 'loop'.

Like what is it used for
What situation do we need to use it

Pls can someone help me out, it's really drawing me back

loops are use for truncating iterable data structure. a perfect example is the for loop. It allows you to list all elements in an iterable data structure.
to illustrate this for you, A list is a perfect example of python data structure.
list=[a,b,c,d]
Now with the for loop (an example of loop) we can printout all the element(data) in that data structure (list) by doing the following:
for i in list:
print(i)
this print out all the elements inside list like this:
a
b
c
d

donproject:
Been following your topic for a while now. I can reasonably call myself a data scientist but I must confess that you are making big waves. I've been in programming world generally for a while but I never heightened my game not until recently, thanks to Corona virus.

I've read your every single update and I know plus I've earnt most of the tools you've mentioned so far. I started off with web development packages and I can categorically say I'm a developer considerably.

I started learning data science early this year but was slow with it because I'm an engineering student at my final year, project and fighting to maintain my 4 pointer. But the recent pandemic affords me enough time, so all I do now is learning one thing or the other.

I raise my eyebrow whenever I see you mentioning and emphasising that one needs to know excel for free-following ML life, I do this because I'm yet to be convinced as to its importance. I will love it if you can stress out its indispensable value that makes it one of the tools one needs for data science (especially ML).

Then on web scrapping, I crawl sites with every tool suitable for it but scrapy. I know scrapy is an advanced module created for web scrapping, but I want to ask if it is so important to add to the tools used for web scrapping, I've scrapped a lot of sites without scrapy.

Finally [this is personal to me], like I've said that I've been around for a while, though I'm not in a rush to start earning before learning, I ride on with the faith that one day will be one day for me. But your stories here and many more I've read about young techies make me wonder if I'm doing things differently because I've been all alone in my programming world. You mentioned how you got a firm that hired you shortly after you start your programming journey, I must tell you this has greatly helped in your development. My question is, how did you manage to get those interviews and even the jobs in a very short period? May be it's due to the connections you've had or you are just in the right environment. Please I need you to answer this particular question even if you decline to answer others I've asked before. Thanks.

I don't know why you guys like to compare beautifulSoup with scrapy. They are not comparable. Scrapy is a framework, comparing it with beautifulSoup is like comparing Django and Jinja ,that's if you know what that means.
All am saying is that you should learn scrapy if you want to do serious and systematic scraping

Ejiod:
1. For quick analysis.
2. Referencing. I suggest you add XLOOKUP & XMATCH to your arsenals
3.Communicating with your lower team. You send the excel spreadsheet
4. Your boss may be interested in only the information based on the excel and not python
5. Quick charts.
6. Infact learn Google sheet as well.
7. Financial modeling for those on accounting
8. Conditional formatting
9. Split text column. Try go deep on data validations then you understand.
10. There are so many things you can do on Excel but not with pandas.

A typical person like me daily
1. Tableau
2. SQL
3. Excel
4. Google sheet
5. PowerPoint because you must present at least a month
6. Jupyter notebook
7. Rapid miner


Hope I answered your question.

yes, you have.Thank you. am really grateful for all you have been doing here

When it comes to infrastructure no high institution in the east will ever make it to the top ten. I graduated from Federal university of Owerri and throughout my stay ,there at Futo,I always complain about the poor infrastructure in the school.
If you are visiting the university for the first time ,you might think that you have visited one kind of evil forest with abounded buildings scattering all the places.
The school lacks planning of any sort , building are scattered all over.

Ejiod:
I will answer your questions:
For the 1st question: Still hold on to your Scrapy tool even if you are doing BeautifulSoup
For the 2nd: I can’t be specific though. 4-5years ago there was a spike in Tech jobs especially once you are good with JavaScript. Then NodeJs and Angular were cute. ReactJs came to light but wasn’t fully functional. Web development role was the fastest way to land a job then. I did a lot of individual projects before applying for web role. Even up till today I get some full stack dev role that I never applied which I always decline cos I’m into DATA.
Would I say it’s chance? Maybe or maybe not.
Your CV/Resume matters. Some don’t mention their portfolio on their CV and expect to be called. While my 1st role as developer I still took nights to learn Python and data stuffs with all seriousness. I’m certain once you are done schooling and by then you build your portfolio getting an offer won’t be an issue.
I was versatile. Even to the point I learnt Automated Software testing and my chances of being called was like 70%. See, one thing I advise is when you get to any position.. don’t ever feel comfortable cos success can sometimes be a bitch that makes you not to climb the tallest building.
For Number 3: Yes Excel is powerful and I bet some that call themselves data scientist can’t do simple or complex computation on excel.
So add Excel to your arsenal.

Boss, you didn't do justice to the third question on excel. Please I will like you to answer this question properly, what exactly do I need excel for in data analysis when Pandas can virtually do anything excel can do and even more?
I know excel to some extent, at least I am very good at advance Excel skills like: vlookup, pivotable, pivot chart and many more, but the thing is, I don't see any use for all these stuffs since I can do all of them with Pandas,
Please, I will really like you to answer this question.

Graspad:
Kindly explain how it works, because I'm having issues working with csv files on the laptop.
If I try to import the csv,it's saying not found.

make sure you are in the same directory where the file is.
u can use is os.walk("." method to loop through all the files in the directory where you are getting not found and see if the file is really there.

vanity upon vanity

SKYQUEST:
what python code would you run on a table with data separated by spaces as shown in the image below to convert it in into a readable excel table; the raw data is also given in the attachment below (ben2):

Using Pandas read it in as CSV then convert it to xlsx using data name .to_excel.(ie. name of data .yo_excel("name.xlsx"