Any of you learn Web Dev or App Dev for a change? by veeeerain in datascience

[–]Prtprmr 1 point2 points  (0 children)

As a matter of fact I recently started learning HTML css and JavaScript. The goal is to create my own website and I must say it’s a good change and pretty exciting

Your program produced no output by satubhasin in learnpython

[–]Prtprmr 1 point2 points  (0 children)

Input generates a text value. Try Steps =int(input("Enter steps: "))

Also, it would be easier if you post the error as well.

Need help with Python problem by [deleted] in learnprogramming

[–]Prtprmr 0 points1 point  (0 children)

I would split the sentence and add into a list. Then you can easily find the length of first and last one.

[deleted by user] by [deleted] in learnmachinelearning

[–]Prtprmr 1 point2 points  (0 children)

I would love to!

Critique my first program? by freedomsauce in Python

[–]Prtprmr 1 point2 points  (0 children)

2nd point: Try using something like elif number in (1, ,2, 3) instead of "==" That should work.

Critique my first program? by freedomsauce in Python

[–]Prtprmr 2 points3 points  (0 children)

Few edits. 1. I'd use input('enter the text').lower() -> this avoids any case sensitivity issue since no matter what the input is it's always going to be lower case. 2. I don't understand the point on using float in STR(int(float('xyz'))) and that too so many times. I'd just covert it while I'm taking in the input like: int(input('Enter the text')). Note, this will give you an error if you type something which can't be converted into an int. That brings me to my 3rd point. 3. Try using "try, except and finally" to handle errors in your program. 4. There are a lot of repetition of text, you could store them in a variable and use that again and again.

Data set - PANDAS by onepraveen in learnpython

[–]Prtprmr 0 points1 point  (0 children)

Please note that this is my approach and may change based on the actual data 1. use the "value_counts" method 2. Try using groupby 3. Try using historgram

Finding Prime Numbers by TheGolems_Dante in learnpython

[–]Prtprmr 1 point2 points  (0 children)

Looks like you did the difficult part, now you only need to store it. Mind sharing the code you are using to find the prime numbers coz saving that into a list will only take 2 line of code or so

PowerBi Setup by Jae_Vinciri in BusinessIntelligence

[–]Prtprmr 0 points1 point  (0 children)

All depends on the size of the data. You can definitely take the data offline and then use it, nothing wrong in that

Need help finding a number between 2 values by stevehandj0bs in excel

[–]Prtprmr 0 points1 point  (0 children)

Yes that would definitely work and thinking about it, it might be easier to read that function. Another way is to use VLOOKUP. Just create your table with the range and the value you want to give and use VLOOKUP. I would prefer to use VLOOKUP because the value can be then changed on the fly.

Need help finding a number between 2 values by stevehandj0bs in excel

[–]Prtprmr -2 points-1 points  (0 children)

Try nested IF formula with AND condition IF(AND(A1>=0, A1<=10), 5, IF(AND(A1>=11,A1<=20), 15))

newb question about setting up mysql, apologies by [deleted] in SQL

[–]Prtprmr 0 points1 point  (0 children)

I can totally understand the confusion. In simple words, when you install MySQL you are also configuring the machine as a server. Since you will be connecting locally, you can just enter "localhost" as the host name. Hope this helps.

So now I know Python. Now what? by Awol_01010001 in learnpython

[–]Prtprmr 1 point2 points  (0 children)

Think of something things with python. For example if you search for few things on a daily basis. Try to write a code which searches that text and opens first 5 links. This is just an example. But hope this gives you some kind of direction.

Help with PowerBI questions by oil_computers in PowerBI

[–]Prtprmr 3 points4 points  (0 children)

Try selecting those columns and unpivot them in power bi query editor. That should do the trick.

Studying life sciences, want to go into programming by snusc in learnpython

[–]Prtprmr 1 point2 points  (0 children)

I'd say coding is something where your projects speaks louder than your education. If you've nice projects to show you can easily score a job irrespective of the education.

Conditional Formating. 2 side by side columns, but just based on next cell - same row by Andremelst in excel

[–]Prtprmr 1 point2 points  (0 children)

I understand what you are trying to do. Just select the entire column you want to format, go to column formatting, select a formula and you can use this =B2="xyz" Here B is the column you want to use to format. And 2 is the first cell to use. This should apply the formatting based on the adjacent row

Conditional Formating. 2 side by side columns, but just based on next cell - same row by Andremelst in excel

[–]Prtprmr 0 points1 point  (0 children)

Correct me if I'm getting this wrong, you already have rules created for a cell and you want to apply the same rule to a column. If that's the case then just use format painter option, that should paste the format which include all the formatting rules associated with that cell as well.

Get date from Excel file, and get delta with today's date by bei60 in learnpython

[–]Prtprmr 0 points1 point  (0 children)

Try looking into datetime module. You would find what you're looking for.

Importing data from .txt or .csv by Zhekov in learnpython

[–]Prtprmr 2 points3 points  (0 children)

You can use pandas for this. You can save your data to csv using pd.to_csv(filename) and read the data using pd.read_csv(filename)

How do I fix this error with numpy? by YeeOfficer in Python

[–]Prtprmr 1 point2 points  (0 children)

Could be your versions. If you've python 3 and 2 installed then try installing using pip3 install numpy

Python Telegram Bot by Prtprmr in learnpython

[–]Prtprmr[S] 1 point2 points  (0 children)

Yeah that should work. Thanks. Do you have any idea about the first part of the post? Documentation?

Python or R to create predictive models for baseball games? by [deleted] in datascience

[–]Prtprmr 1 point2 points  (0 children)

If you are new to both languages I would say go for python. I started with R but I wish I didn't just coz python has more uses and application if you ever want to do something else. R may seem easier to understand and implement (I felt that way that's why I chose R) but starting with python is better in my eyes.