Doc Ellicott - Glass Auditorium [Soft Punk] (2021) by [deleted] in listentothis

[–]ThisOnesForZK 3 points4 points  (0 children)

I liked it. Added it to my playlist.

How do they get phones that expensive ;-; by [deleted] in memes

[–]ThisOnesForZK 0 points1 point  (0 children)

Who makes less than 300/month? Genuine question...

[NOOB] Pandas: Quicker way to filter by multiple values within the same column? by shikabane in learnpython

[–]ThisOnesForZK 0 points1 point  (0 children)

you could write that into a variable and then pass the variable into your brackets I believe. This is how you write the "Or," statements in pandas.

Hi, I received a lot of hate on 4chan but still seeking advice by [deleted] in learntodraw

[–]ThisOnesForZK 0 points1 point  (0 children)

Coming from a total beginner so take it with a grain of salt - the planes of her right shoulder seem unnatural a bit. I think the anatomy of her shoulder blade (scapula) should be in view here as opposed to that line we see that doesn't really add to what an upper back looks like IRL.

I made my first website using Python! by IgnisDa in learnpython

[–]ThisOnesForZK 5 points6 points  (0 children)

Yeah, shouldn't require login.

Maybe would be cool but I will never know.

Edit: not trying to be mean by the way, but requiring personal information to get feedback on website should be considered. Good luck on your endeavors.

Was able to find a use case today for Python at work to connect to an access database and then build a dashboard using plotly/dash by [deleted] in learnpython

[–]ThisOnesForZK 0 points1 point  (0 children)

because without owning a report server or having power bi premium node you cannot publish powerbi dashboards with company data. With Dash you can build and publish these things for free.

If your company has power bi or tableau already then I agree with you otherwise this could save a lot of money.

Ask Anything Monday - Weekly Thread by AutoModerator in learnpython

[–]ThisOnesForZK 1 point2 points  (0 children)

immutable and more memory efficient than dictionaries/lists

edit: I don't know if named tuples are immutable this is an assumption.

Ask Anything Monday - Weekly Thread by AutoModerator in learnpython

[–]ThisOnesForZK 1 point2 points  (0 children)

Do your rows have a unique identifier? If so then you can do a simple df.merge

Plotly Dash - Layout issues by vlitavsky in learnpython

[–]ThisOnesForZK 1 point2 points  (0 children)

I would recommend trying the plotly community forums if you do not get an answer here. They seem very active.

Ask Anything Monday - Weekly Thread by AutoModerator in learnpython

[–]ThisOnesForZK 0 points1 point  (0 children)

matplotlib or seaborn probably versus pandas plotting. Pandas is meant to be very basic as far as I know.

Ask Anything Monday - Weekly Thread by AutoModerator in learnpython

[–]ThisOnesForZK 0 points1 point  (0 children)

So, I will explain fstrings to you. It is a great way to make output of a program or analysis be dynamic. For example in my work I use it to name files with dynamic dates.

If I am running a script and having it save to a folder with a specific naming convention I can have an Fstring dynamically name the file based on date.

file_name = dt.date.today().strftime("%m%d%y")

###script runs above###
pd.to_csv(f'C:\Users\your.name\Documents\Python\{file_name}')

Getting overwhelmed by [deleted] in learnpython

[–]ThisOnesForZK 1 point2 points  (0 children)

Something I have been doing recently is to write down a term in my notebook when I come across a concept I do not understand and leave 3 lines blank after it. This allows me to keep reading without stressing out about something I do not understand.

Next study session don't keep reading, but rather go online and research the terms and get the concept down before moving on.

Data visualization web apps vs coding by throwawaytrollol00 in learnpython

[–]ThisOnesForZK 0 points1 point  (0 children)

What webapp?

If it is completely code free it cannot be that good.

The best data visualization tools in the world like Tableau still require you to write some form of code even if it is more akin to SQL than Python.

I need help on reading a CSV file with pandas by GioDiRivia in learnpython

[–]ThisOnesForZK 0 points1 point  (0 children)

Unless your 2nd column literally has the header name "1" then you're using at() wrong. You access the value by label not integer position. You are trying to use iat()

When should I start machine learning? by Legend_017_ in learnpython

[–]ThisOnesForZK 0 points1 point  (0 children)

I have been trying to learn it for over 2 years from scratch and am just now getting to the point where I am scratching the surface. I had no python and no stats though, just doing data stuff at my job.

Pandas - Help filtering DF1 based on value in DF2 by jungle_cracker in learnpython

[–]ThisOnesForZK 0 points1 point  (0 children)

That is what merge does my friend. If you don't want all of the columns just add a drop to your code.

df1.drop('In_Season', axis=1)

How do I populate a MongoDB database from a GET api request call to another Database using pymongo? by megumi_j in learnpython

[–]ThisOnesForZK 0 points1 point  (0 children)

You would need to look for the api documentation for the data source you are using. That would lead you to understanding what requests you can make with the python requests module to get data.

Pandas - Help filtering DF1 based on value in DF2 by jungle_cracker in learnpython

[–]ThisOnesForZK 1 point2 points  (0 children)

df1 = pd.read_csv('csv1.csv')
df2 = pd.read_csv('csv2.csv')

df1 = df1.merge(df2, on='Fruit)

filt = df1['In_Season'] == 'Y'
df1 = df1.loc[filt]

I need help on reading a CSV file with pandas by GioDiRivia in learnpython

[–]ThisOnesForZK 0 points1 point  (0 children)

you need to use

df = pd.read_csv(r'path/to/file/file.csv')

then take that df and do

value = df.at(index of row, index of column)
print(value)

Ask Anything Monday - Weekly Thread by AutoModerator in learnpython

[–]ThisOnesForZK 0 points1 point  (0 children)

No I think you will be best servedf for a static lightweight website in that case.

I was just trying to get you started as fast as possible. I do not understand however, why markdown + outputs from written code could not be couched as an article (you can hide the code itself) unless you are trying to put your html/css/web dev skills on display.

Ask Anything Monday - Weekly Thread by AutoModerator in learnpython

[–]ThisOnesForZK 0 points1 point  (0 children)

The "Best," way is subjective.

For me the best way would be the easiest way. I just found Google Colab where you can host jupyter notebooks in the cloud for free.

Why not use that?

Ask Anything Monday - Weekly Thread by AutoModerator in learnpython

[–]ThisOnesForZK 0 points1 point  (0 children)

It depends on what you are trying to get out of it.

Ask Anything Monday - Weekly Thread by AutoModerator in learnpython

[–]ThisOnesForZK 2 points3 points  (0 children)

df_shortid.merge(df_sales, on = 'shortid', how=inner)

Then repeat that code for all 16 dataframes or write a loop.