₦airaland Forum

Philantropists:
The fact is that Okocha didnot lose money to Société General Europe, Sariki and his cohorts ran a local game and that is most likely the answer to your misinterpretation.

Sariki has nothing to do with Société General Europe, he is no where in the history of Société General Europe, here are some facts.

Bro you are the one that brought Societe General Europe into the talk.

You must have been 2 years old in 2005 when it happened, that is the only plausible reason as to why you are arguing about this.

ositadima1:
Same guy, the two events are not mutually exclusive I guess.

Bro once you are alive then there is hope. Sharing it here you are on the right track. Open up discuss your situation with people close to you and random people. Filter their feedback take action on the ones that make sense the most.


One more thing stop blaming your dad. You are in charge of your life now. There are people that did not know their dad or parents and they are very successful. What if you are still in Rome and now a drug addict? Or you think every abroad story is juicy and sweet?


I am not a fan of "Dont leave Nigeria" but if you are still in Nigeria make the best of it.

Things are hard, things are hard. Go to Lekki axis see the number of buildings and estates coming up and are available for sale. Where is the money coming from?

There is a lot of opportunities despite the hardship

Dont give up

Hello Guys,

Do i need to install curl on windows 8.1 before i can use it with Git Bash?

I keep getting this error message Bash: curl: command not found when i use the command

wisemania:
Or if you want a higher pay,
Immerse yourself in MSSQL (Data warehouse tools)
I.e
Learn


T-SQL (Microsoft customized SQL)

SSRS (pretty deprecated, but many companies still use it for reporting. To be frank, modern visuals like PBI, Tableau are taking over.dont spend too much of your time here)

SSIS -makes your life easier, as it reduces the amount of dml you need write. It's very easy.

SSAS - same.


Spend your time learning the above and you'll begin to earn a lot.

Because if you spend your time going though the Forever learning path, you're gonna be a jack of all trades yet a master of none.

If you need to feed, get a job with excel,powerBI/tableau,SQL,Python/R
then learn the remain (Statistics, ML-DL) on the job as required.

Else, you go HUNGRY


This is barely my [b]3rd month into data analysis and I've gotten some interviews already... No time to waste, as you need to survive...
[/b]
My 2cents

This is awesome.

That means you must have a solid CV. Can you share a template for a data science CV?

I believe it is the first step to getting a Data Science job after all the learning a good CV will help too.

Where is everyone?

Hello All,

Please i want to ask , now that interest rates are down to single digits and low, that is mean that mortage loans will also be low too?

Chemistdavy:
If they can pay the interns, it would make sense o

My own view is to get the job first and get hands on experience.

Interns should not work for money now. Just an opportunity to practice what they have been learning and have something to add to CV.

They can even do it for 6 months and decide on whether to continue or not

For those that might be interested. Find this opening

https://ng.indeed.com/job-description?jk=a9dfa3ada88bf489&q=power+bi&tk=1ef77lt5f3j7t800&from=ja&alid=5eb01ee6408edc4e7c0a11b6&utm_campaign=job_alerts&utm_medium=email&utm_source=jobseeker_emails&rgtk=1ef77lt5f3j7t800

Junior Business Intelligence Analyst
SmatData
-
Lagos

Location -Logos
We are a growing software firm that provides Enterprise Data Warehouse Projects implementation services for businesses across major industries. We are looking for a Business Intelligence/Data Warehouse analyst with good programming skills to support our existing clients on front end BI tools (QlikView, Microsoft Excel Pivot Tables, Reporting Services) and backend Data Warehouse tools (Microsoft Integration Services, Microsoft Analysis Services) onsite and offsite.

Interns and recent graduates are welcome to apply. Trainings will be provided. The screening process will involve mini training sessions and take home assignments.

Why work for us:
This is a great opportunity for interns and recent graduates to develop their skills and grow with us.
Free trainings will be provided.
Competitive salary for top trainees.
Opportunity to work at the convenience of your home on some days of the work week.
Opportunity to develop into a more senior role.



Responsibilities:
Onsite and offsite client support
Generate analytic reports and Dashboards
Generate new Microsoft Integration Services (SSIS) packages, modify and optimize existing ones
Make presentations to clients on BI tools
Generate end user manuals
Assist with or conduct end user training

Required skills:
T-SQL programming
Microsoft SQL Server Integration Services (SSIS)
Should be a good logical thinker to be able to translate complex business processes into appropriate visualizations and reports
Excellent written and verbal communication skills

Desirable skills:
QlikView Design & Development
Programming Skills: VB .NET, C#, VBA
Database modeling
Microsoft Excel - Pivot Tables, Power Pivot, Excel Formulas

If interested please send
your resume to careers@smatdata.com
SmatData - 6 days agoreport job

Shepherdd:
When you echo export, you don't need to surround your address with another quote. The first one before export will do and make sure you close it.

And to avoid errors why not edit the bashrc directly with a text editor and remove the need for echo. Your bashrc will be in your user directory.

Bro thank you for responding.

I have not really looked at it yet. I have been busy.

I got an Excel job on Fiverr, i have been cracking my head on.

Ejiod thanks again for creating this thread.

Hello Gurus in the house. I need your help here.

I am trying to work Git Bash to run python commands

I already have Git installed but when i ran these commands

echo 'export PATH="$PATH:/c/Users/Nelly/anaconda3:/c/Users/Nelly/anaconda3/Scripts"' >> .bashrc

echo 'alias python="winpty python.exe"' >> .bashrc


I get the errors below:

bash: export: `=': not a valid identifier
bash: export: `:/c/Users/Nelly/anaconda3:/c/Users/Nelly/anaconda3/Scripts': not
a valid identifier

Whenever i launch Git Bash, i get the error below:


bash: export: `=': not a valid identifier
bash: export: `:/c/Users/Nelly/anaconda3:/c/Users/Nelly/anaconda3/Scripts': not
a valid identifier
bash: alias: python: not found
bash: alias: =: not found
bash: alias: winpty python.exe: not found

Nelly@Nelly MINGW64 ~
$


What could be the problem?

I have searched stackoverflow, but the solutions i saw there did not help me to resolve the fault.

I am wondering if anyone has experienced it

Ejiod:
Python is on Champions League while PowerBI and Tableau are on Europa League.
Excel is like AC Milan of Seria A

For basic level analysis Excel is good. Not everyone understands python and rigorous path in becoming fully fledged in it. Python runs deep analysis than you would with other tools. But imagine your boss tells you to send list of customers to team leads, are you gonna be using Python...., or you were asked to do referencing shey you will call python or power bi to the rescue.. definitely NO.., Excel comes in.
For visualization just throw EXCEL to trash can! Tableau and PowerBI are boss once it comes to visualization. Infact analysis these 2 comes ahead of Excel. To automate report sending that’s when you even call Tableau and Power BI. For me the only time I use Excel is if I’m doing XLOOKUP or after exporting from powerBi or Tableau.
I only use python when I wanna do advanced analytics or machine learning. Funny enough machine learning model are now integrated to these tools. Excel is cool but if you wanna be taken serious please drown yourself in Python,Tableau/PowerBI and SQL.


P.S
PowerBI and Tableau are on Champions League. See teams below.
SQL
Python
Tableau
PowerBI


R now is on Europa League
Excel still playing Seria A

Okay, thank you so much for this response.

First when i said Excel, I meant Excel in combination with Power BI as power BI is an extension of Excel as the come from the same source.

The reason I asked was as i was working on an analysis project (Sales Data) using python.

I noticed that most of the operations were similar to what you would do using Excel Power Query and Data Model.

Things like dropping Null values, adding columns can be done using Dax function in Power BI. I saw so many similarities especially in the pre-processing stage

Ejiod:
Hey guys.... just finished reading Medium this morning and felt like sharing. There’s currently a new revolution by tech giants now regarding content learning. Please guys try visiting Grow with Google

Welcome back Ejiod. Thank you for the link

We have been waiting for your response on some discussions. Specifically on how Python is better than Excel Power Tools and Power BI in the work place.

Na wa ooo.

Where is everyone?

It seems the ogas are enjoying Sallah break

ibromodzi:
As a matter of fact, df.describe() just gives you an idea of the data you are dealing with. Like a statistical summary. Although, there could be more than a way to carry out in-depth inferential analytics, scipy library in conjunction with researchpy and pandas should always give you what you want.

[b]Modified:
Steps in determining what tests to use in a statistical analysis;
1. What type of variables are you dealing with? Numerical or categorical?

2. What type of analysis are you doing?
a. comparison (mean,median,proportion); this is where you use t-tests, ANOVA, etc.. depending on the distribution of the data(parametric or not)
b. Relationship between two variables (say gender and smartness); this is where you use correlation (Pearson or Spearman rank)
c. Predicting one variable from another (say exposure to smoke predicts the risk of lung cancer); this is a Regression task

3. Number of groups involved (say the effect of Chloroquine in Covid 19 and non Covid 19 patients - 2 groups)

4. Distribution of your data (Normal or not); there are different ways to determine this.

I believe you now understand the point I was talking from when I mentioned theoretical knowledge of statistics.

[/b]


Thank you for this

BelieverDE:
I have been learning Excel for close to 4 months. Everything you described above can be done with Excel.

If you load your data to the Data Model or convert the table to an Excel Table, you can perform calculations to a column.

You can also design the graph to your preferences described above.

Excel is very powerful and graphical at the same time, you are seeing results as you go.

I know @Ejiod said he outshined does using Excel it will be great if we get his thoughts and other ogas on this.

[quote author=KlausMichaelson post=92136556]Thats very good. Keep it up sir. Yes you can check out *CS DOJO* and *Keith Galli* on YouTube. Check for their Videos on Intro to Data Science and Visualization, pandas, pyplot, Matplotlib, etc. They will open your eyes.

Modified
I use my book to take down every step about just any of the tools I'm learning from any of the videos. I literally have a jotter where I took down every steps. I do this cos I'll still go through my jottinngs whenever I'm not on my system. So It requires patience.[/quote


Bro thank you for this. I am really gaining some insights and understanding the use of Python in Data Science. I am going through the Keith Galli video on "Solving Real world data science tasks with Python". It looks cool.

But i observed that what is being done using Pandas and Matplolib can be done comfortably with excel(Power Queries)

To me Excel is less cumbersome than typing lines of code in Python

So i want to ask ogas in the house why they say they prefer Python.

Looking forward to the discussion

Hello Guys,

As i mentioned earlier. Below is another one from fiverr. The budget is $108. My objective is purely for us to discuss and for people to see real life data science problems that people pay for to be solved for them

I do not even know how to solve this one. I hope out gurus in the house can use it to teach us. Just give us an idea of how to approach it.


>>>>> hi Everybody, I looking for someone for Machine Learning sequence prediction models who are not afraid from numbers & big numbers, So the work will be analyse a file with more then 32000 results of raffles. Each raffle is include 4 cards, Heart, Diamond, Clubs and Leaf. So in each raffle there are result for each cards, means 4 results. Now I think that on this file there is something that return and based on old results new result is coming. There is not pattern or something, you should find something like that. After we success to predict the next raffle, I need it automate, so every time I will load the new CSV it will predict the next results. Do you think you can handle this big file and try to found some algorithm or solution to get high accuracy of the results in next raffle? I've attached here the CSV file with the results. I also know the next raffle result, so let me know if you can predict the results. What I need from you is a "demo" or predict the next raffle results and we compare the results with the real results. Regards.<<<<<

Ejiod:
Shout out to everyone for their contribution on this thread.. Thumbs up. To all experts, intermediate and enthusiasts. Thanks for your inputs..
Been awhile...Hope you all are having a good time..

Shout out to you too for creating this thread.

Gods blessings fill every aspect of your life

noob03saibot:
Had to re-download it on my phone, [b][/b]the 32bit version. Selected it to be downloaded on my phone then transferred it to my system where I installed it. Whereas this morning, i used my system and it automatically downloaded the 64 bit version, it didn't give me an option to choose.

Wow on your phone.

Just keep it up, God will reward your hustle. You are just showing that no one has any excuse to succeed.

I hail all the people contributing here and helping out. God will reward us all.

yemyke001:
Yes

Okay thank you i do appreciate.

This python when does one learn it enough self?

I thought i have mastered this concept before now.

yemyke001:
The '%' sign is the modulo function in math. The remainder zero means the dividend is an even number for it to divide 10(divisor) and remain zero. If it were to be any other number aside zero, it means the remainder will be that number, indicating maybe odd number or something

So if i understand it well, it should pick the values in rowID that when divided by 10 the remainder should be "0', if the remainder is not "0" it should not be picked?

yemyke001:
It means when you divide data['rowID'] by 10 the remainder will be 0

Thank you bro.

What is i replace it with another number? What is the impact/

I replaced the "0" with 1,2,3,4,5,6,7 to 9 there was change in the result, when i put 10 there the result was "0"


I am just curious

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


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

Try the_raw_csv = pd.read_csv('Absenteeism_data.csv.csv')


The file name has to match what you have inside the brackets

nwele2017:
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

He did not share any Excel file. He posted that and was asking for people to bid to do it.

He shared the attached image though.

Can you explain the steps for on how to approach so we all learn

[quote author=lymelyte post=91284395][/quote]Based on your code ensure the .pnyb file you are using for your code is in the same folder where your Absenteeism_data.csv file is.

the_raw_csv = pd.read_csv('Absenteeism_data.csv')

From the above pd.read_csv is looking for the Absenteeism_data.csv file and cannot locate it.

so within the ('Ab...') you need to specify the file path.

For example if the absenteeism file is in your desktop you can do something like this:

pd.read_csv('C:/Users/Documents/Desktop/Absenteeism_data.csv')

The key is to specify the right file path.

What i do is to make sure the file i want to read is in the same folder as the .pynb notebook book i am working with so i will not type a long file path within ('......') the brackets

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.

[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.

Hello All,

Is anyone taking the Edx course Probability and Statistics in Data science using Python and Python for Data Science course?

Maybe we can connect to share ideas

RabbiDoracle:


All global markets must go up. No exception.

Oga Oracle,

Are you still optimistic about a rally when nigerias debt compared to income in first quarter income is almost 100%

Who will want to bring in money into such an economy or who will want to keep money in such an economy?

I am just a learner oo.

I think the future is bleak

Zabiboy:

Why not learn them sequentially ( one after the other) ??...so while learning the next course, you can take time to practice the one's you are done with...
Anyways i'll advice you to learn python as a whole first before going into its data science libraries ( i.e learn both python for web dev. And Data analysis..)...Add Tableau to the list too..
Also, Remove ML from the list till you are grounded in python data science libraries( numpy , pandas and co.)....
Finally, save up and get a system to enable you practice alot....DONT JUST LEARN, PRACTICE PRACTICE PRACTICE
GL

Bro can you throw more light on the bolded?
There are some courses that introduce Python and their libraries and then apply it to Data Science.

Do you mean it is not a good approach?