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.

Hinokami:



I'm at this stage too.. Currently I just scour freelance sites, register with them and see what sort of jobs available that matches your skills to an extent.. Customise your profile to fit those jobs and apply for them.. I'm registered only on upwork tho and so far no jobs yet but mainly because I am not that serious. I hope this helps

Graspad:
Guys,
I just finished my machine learning course.
I learned regression and classification algorithms like SVM, Linear/logistic regression,Random forest, Decision Trees,k nearest neighbor, gradient boosting and co.
Also I learnt unsupervised learning too, and also cross validation,grid search and com
I've also practiced on kaggle too.
Pls Which course did you take on Machine Learning? Is it still open?

Please, what next??

Graspad:
Guys,
I just finished my machine learning course.
I learned regression and classification algorithms like SVM, Linear/logistic regression,Random forest, Decision Trees,k nearest neighbor, gradient boosting and co.
Also I learnt unsupervised learning too, and also cross validation,grid search and com
I've also practiced on kaggle too.


Please, what next??

mcemmy0z:

https://covid19.ncdc.gov.ng/

Toppytek:


I guess your system is a 32bits type.

mentro:

Which course? How practical is it?

Graspad:

Not one course though.
I used IBM data science course and University of Michigan data science course (both on Coursera) and I also used Jose portilla's machine learning course on Udemy.

mentro:

@Mcemmy I sent you a dm. Please reply.

Blesser28:

Exactly
Anyway work around about this

Graspad:
Guys,
I just finished my machine learning course.
I learned regression and classification algorithms like SVM, Linear/logistic regression,Random forest, Decision Trees,k nearest neighbor, gradient boosting and co.
Also I learnt unsupervised learning too, and also cross validation,grid search and com
I've also practiced on kaggle too.


Please, what next??

Toppytek:


Grounded in Excel, SQL, Pandas, and Power Bi or Tableau?

Graspad:

I Know pandas though, but because I'm learning from my mobile device, I can't learn the rest.

Graspad:
I have an issue with this dataset.
I am working on predicting bank loan default.
The dataset consist of three different csv file.
The first one contains the demographics of the data, the second contains previous performance on loans and the third gives information on the loan I'm predicting on.

The issue is that the customers have taken many loans previously and the information of all the previous loans are in the second datasets.

When I merged it, it only took one previous loan information from the second dataset.


How would I merge them such that my new merge would have information on all previous loans?

Thanks in advance.

PS:I'm using PANDAS.

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.

noob03saibot:
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.

Graspad:


In order of first, second,third

Graspad:


In order of first, second,third

Graspad:


In order of first, second,third

Hinokami:
Chai God...People are really super motivated...Amazing that you use a phone

mcemmy0z:

Replied you already

brashear:



It's .txt and it works! Thank you.

Graspad:

Not one course though.
I used IBM data science course and University of Michigan data science course (both on Coursera) and I also used Jose portilla's machine learning course on Udemy.

BoleAndFish:
To think that you're doing all this with just a phone!! What's your motivation if I may ask?

mcemmy0z:

Do you use join, concatenation or merge
If join, you have specify the columns it will join along with.
df = first_data.join(second_data["specify each colunms it will bring along to the table])

kvngbright:

please can i see the certificate issued, i want to apply through financial aid.

Graspad:

I didn't pay for any of the courses though,
I audited them on Coursera and used www.freetutorialsus.com to access the Udemy course for free.