[-] 3rr4tt1c@programming.dev 1 points 3 months ago

I don't fully understand the technical aspects, but I get the gist of what you're saying. Overcomplicating code is something I'm sometimes guilty of. I will try to make the code as "flexible" as possible to allow for changes later down the line if needed. Also, I've never done anything in Lua besides making stuff in Roblox Studio ๐Ÿ˜…. You really know your stuff hus?

[-] 3rr4tt1c@programming.dev 2 points 3 months ago

Well, then I guess I'll worry about it if it becomes an issue.

14

I'm trying to make my first API with an accompanying website, and I'm using tutorials. I decided the MERN stack was the way to go, since it seemed popular and easy.

I have some experience with SQL itself, but have never connected a database to an actual application.

So I got to the point of making my database in mongoDB when I saw some stuff about how mySQL is more secure than noSQL, and how noSQL has some disadvantages.

The api/website I'm making is just a pet project, but if it ever does become popular, would I have to move my databases? Or is this a "cross that bridge if/when I get there" situation?

Alternatively can I have the same database in multiple places at once? As in, bot mySQL and noSQL?

[-] 3rr4tt1c@programming.dev 1 points 3 months ago

Thanks, it's mentioned in the link that u/Sten gave me as well.

[-] 3rr4tt1c@programming.dev 3 points 3 months ago

Thank you. This seems very helpful.

15
submitted 3 months ago* (last edited 3 months ago) by 3rr4tt1c@programming.dev to c/cs_career_questions@programming.dev

I'm trying to join some... not entirely sure what they're called. Like those projects where a group of people all work on a single community project. I hear discord is a good place for stuff like that. And beginner hackathons too. Any advice would be super helpful. Edit: Open Source Projects is what I meant ๐Ÿ˜…

[-] 3rr4tt1c@programming.dev 20 points 6 months ago

AI can be ethically used in writing. This is not an example of that. People need to get into the "AI as a tool" mindset. And capitalism causing greed is part of the issue of course.

[-] 3rr4tt1c@programming.dev 2 points 7 months ago

If this is for a job interview, Iโ€™d err on the side of verbosity. Break it all into distinct, easy to read steps: load, process, output, logging, exception handling, comments, etc.

I turned it in days ago so there's nothing I can do about it. But I'll keep that in mind for the future.

[-] 3rr4tt1c@programming.dev 2 points 7 months ago

Thanks, I set inplace=False like you suggested. I thought setting it to true meant that it modified the original dataframe. Why does it work with false?

[-] 3rr4tt1c@programming.dev 2 points 7 months ago

Currently working on the responsive web development course. I like the guitar sounds. ๐Ÿ˜…

15
  • I was applying to a job, and then I had to answer a question about web scraping, which I'm not familiar with. I answered all the other questions with no issue, so I decided might as well put in the effort to learn the basics and see if I can do it in a day.
  • Yes, it was *somewhat * easier than I expected, but I still had to watch like 4 YouTube videos and read a bunch of reddit and stack overflow posts.
  • I got the code working, but I decided to run it again to double-check. It stopped working. Not sure why.
  • Testing is also annoying because the "web page" is a google doc and constantly reloads or something. It takes forever to get proper results from my print statements.
  • I attached an image with the question. I haven't heard back from them, and I've seen other people post what I think might be this exact question online, so hopefully I'm not doing anything illegal.
  • At this point, I just want to solve it. Here's the code:
from bs4 import BeautifulSoup
import requests
import pandas as pd
import numpy as np

def createDataframe(url): #Make the data easier to handle
    #Get the page's html data using BeautifulSoup
    page = requests.get(url)
    soup = BeautifulSoup(page.text, 'html.parser')

    #Extract the table's headers and column structure
    table_headers = soup.find('tr', class_='c8')
    table_headers_titles = table_headers.find_all('td')
    headers = [header.text for header in table_headers_titles]

    #Extract the table's row data
    rows = soup.find_all('tr', class_='c4')
    row_data_outer = [row.find_all('td') for row in rows]
    row_data = [[cell.text.strip() for cell in row] for row in row_data_outer]

    #Create a dataframe using the extracted data
    df = pd.DataFrame(row_data, columns=headers)
    return df

def printMessage(dataframe): #Print the message gotten from the organised data
    #Drop rows that have missing coordinates
    dataframe = dataframe.dropna(subset=['x-coordinate', 'y-coordinate'], inplace=True)

    #Convert the coordinate columns to integers so they can be used
    dataframe['x-coordinate'] = dataframe['x-coordinate'].astype(int)
    dataframe['y-coordinate'] = dataframe['y-coordinate'].astype(int)

    #Determine how large the grid to be printed is
    max_x = int(dataframe['x-coordinate'].max())
    max_y = int(dataframe['y-coordinate'].max())

    #Create an empty grid
    grid = np.full((max_y + 1, max_x + 1), " ")

    #Fill the grid with the characters using coordinates as the indices
    for _, row in dataframe.iterrows():
        x = row['x-coordinate']
        y = row['y-coordinate']
        char = row['Character']
        grid[y][x] = char
    for row in grid:
        print("".join(row))

test = 'https://docs.google.com/document/d/e/2PACX-1vQGUck9HIFCyezsrBSnmENk5ieJuYwpt7YHYEzeNJkIb9OSDdx-ov2nRNReKQyey-cwJOoEKUhLmN9z/pub'
printMessage(createDataframe(test))

My most recent error:

C:\Users\User\PycharmProjects\dataAnnotationCodingQuestion\.venv\Scripts\python.exe C:\Users\User\PycharmProjects\dataAnnotationCodingQuestion\.venv\app.py 
Traceback (most recent call last):
  File "C:\Users\User\PycharmProjects\dataAnnotationCodingQuestion\.venv\app.py", line 50, in <module>
    printMessage(createDataframe(test))
  File "C:\Users\User\PycharmProjects\dataAnnotationCodingQuestion\.venv\app.py", line 30, in printMessage
    dataframe['x-coordinate'] = dataframe['x-coordinate'].astype(int)
                                ~~~~~~~~~^^^^^^^^^^^^^^^^
TypeError: 'NoneType' object is not subscriptable

Process finished with exit code 1

16

I know this seems like a very obvious question. But I mean with regards to job searches. Even internships seem to require a variety of skills these days. I'm interested in both web development and just recently have considered data analysis. Should I work on tutorials and personal projects for a single skill or framework at a time? Or make small projects across a wide variety of things so I can put those skills on my resume?

[-] 3rr4tt1c@programming.dev 2 points 8 months ago* (last edited 8 months ago)

Sounds like they're still very relevant and very important. Python isn't a language I've used a lot but I'm still surprised I've never heard about docstrings till this tutorial. Thanks for the info.

26

Was going through a Python tutorial, but it seems kinda dated. Wanted to know if people regularly use docstrings in the workforce. Or are they somewhat irrelevant because you can convey most of that info via comments and context? Do jobs make you use them?

3rr4tt1c

joined 9 months ago