so i have less then 50 chats in this sevrer
#voice-chat-text-0
patent otter
vocal basin
as was recently found out about those tests, there is some amount of reading and English-to-English translation skills required too
I'm thinking of publishing this at some point; but probably should add a Cancellable: Future first, since that's a related concept
https://github.com/parrrate/closable
open moth
@wind raptor have you watched Severance series?
wind raptor
<@373121697957543946> have you watched `Severance` series?
OMG loveeeeee this series!
open moth
OMG loveeeeee this series!
yeah ending was kinda of frustrating
wind raptor
yeah ending was kinda of frustrating
Greenlit for another season
somber heath
!resources @jovial dirge
wise cargoBOT
somber heath
Avoid w3schools.
peak depot
wind raptor
Facts
open moth
ML
wind raptor
IOT things are usually very vulnerable, if not now, then in a year when they stop supporting it
vocal basin
how to train aim in valorant: just use workshop maps in CS:GO/CS2 instead
calculators are AI
open moth
π
vocal basin
AI is kind of a buzzword
open moth
lemme ask AI if it's AI or not
vocal basin
LLMs are much of AI as things like YOLO
there is nothing making it more "intelligent"
vocal basin
doing deathmatches in CS:GO without a crosshair was fun
just learning where the centre of the screen is
open moth
SHE's so used to ppl not replying back π
vocal basin
oh, I know what other thing people could think is AI
vocal basin
oh, I know what other thing people could think is AI
@peak depot will send in DMs because it's very doxxing
somber heath
@misty nimbus π
misty nimbus
vocal basin
maybe someone knows Python 1
supple swan
Who Can Teach Me Python Fully π¦
vocal basin
maybe someone can tech you Python 1 fully
prisma basin
i can
prisma basin
Plz Teach me
how much you know about python
supple swan
Come In Dm In Vc
prisma basin
Come In Dm In Vc
instead of that you should watch some videos on youtube
supple swan
Only this much
supple swan
instead of that you should watch some videos on youtube
tysm btw from whom do u learn ?
wind raptor
!resources
wise cargoBOT
supple swan
python ?
vocal basin
@peak depot also they're playing a pirated version of Minecraft, specifically the one which has a history of being malware lmao
wind raptor
check out our resource site @supple swan
supple swan
Tysm
prisma basin
tysm btw from whom do u learn ?
freecodecamp.com(on youtube), Datacamp , and code code with Mosh
supple swan
https://youtu.be/UrsmFxEIp5k?si=GuTmHnSK-KBAloKY Anyone Knows About this is this good for start ?
prisma basin
so you're form india
supple swan
Yeah
supple swan
Hm
prisma basin
you can check that playlist
prisma basin
!voice
wise cargoBOT
dire ridge
@supple swan do you have any experience with other programming languages? it would be easier to transfer concepts between langauges than learning from scratch
wind raptor
prisma basin
dire ridge
crystal fox
prisma basin
yeah
supple swan
I Have Created This Code
Username = " RIPxBEAST"
print("I Am Proooooooooooooo In Minecraft Pvp My Username is" +Username )
supple swan
hm
crystal fox
supple swan
what does f do in this ?
prisma basin
use leamon
crystal fox
prisma basin
it will fixi
prisma basin
what does f do in this ?
formatted
supple swan
oh
crystal fox
dire ridge
oh
f-strings are great, between { and } you can use expressions so you can even use something like:
num = 2
print(f"Formatted string, check this expression: {num * 5}")
# -> 10 is the number printed
no, I am not, in fact programming in Python is a hobby - just developing small applications for personal usage
dire ridge
my profession is more commercial customer facing sales related, for a technology company of course
on my profile description to customers I generally say that I am a weekend programmer π
prisma basin
are you working as a freelancer ?
dire ridge
no, in fact I work for Oracle
prisma basin
on my profile description to customers I generally say that I am a weekend progr...
great
prisma basin
no, in fact I work for Oracle
ohh
somber heath
Trend toward what is simplest. F-strings are often simpler at scale and are fantastic to use, but say you have something like```py
a = 'a'
b = 'b'
consider
c = a + b
vs
c = f'{a}{b}'```There are cases where string concatenation is easier and simpler. It's about choosing the right tool for a given job.
str.format also has skin in the game for some things.
prisma basin
Trend toward what is simplest. F-strings are often simpler at scale and are fant...
perfect
prisma basin
str.format also has skin in the game for some things.
yup
dire ridge
without rehearse we went from the simplest usage of f-strings like modifying the print statement provided by the learner
addition of expression usage
completion by OpalMist covering Pythonic approach and wrapping up with alternatives
that was great guys
wise cargoBOT
wind raptor
I'm stoked for these!
wise cargoBOT
vocal basin
there is also original Celsius
typical v0.1
300K is roughly room temp
somewhat warm room but still
vocal basin
typical v0.1
ice melting at 100
water boiling at 0
prisma basin
guys check my profile picture
wth
everyone in vc , i want you guys to test my project , can you guys help ?
and please give me reviews , and feedbacks
@somber heath
its a website
lol
no no
oh my god what i asked for π€£π€£
peak depot
We will not click random websites. You can post your Git repo here.
prisma basin
no its is same
somber heath
Or screenshots.
peak depot
We_will_not click websites
supple swan
yeah fast
supple swan
U Made This ?
prisma basin
or something
prisma basin
U Made This ?
yeah took me 3 month
prisma basin
@peak depot it is for developers
prisma basin
Can U Gimme File Or Source Code ?
sorry bro
supple swan
Okey π
prisma basin
its not open source
supple swan
okey i will try to make better than this in future
prisma basin
ok
wind raptor
Awesome site! One recommendation would be to use a gray (like your get started button) for this button, instead of a white. It should contrast quite a bit more.
prisma basin
Awesome site! One recommendation would be to use a gray (like your get started b...
yeah my team is fixing it
some of the things need redesigning
still in development
but yeah we're improving the UI
anyway thank you for the feedback
chilly wolf
somber heath
wise loom
I've managed to finally choose the laptop π π .
I've defined a formula cinebench_score/price and picked the highest on that π
somber heath
bbl
wise loom
@wind raptor the lenovo with the highest cinebench_score/price ratio.
it stands out in the 2nd image, see the column "bang per buck".
finite karma
I like to cook seeds usually idk, beans, rice etc etc etc, I'm usually pretty good at this.
DID SOMEONE SAID ALCOHOL?
π€€
Hewooo
Haiiii
Tail?
peak depot
regal summit
Hello!
craggy vale
hellooooooooooooooooooooooo
somber heath
!voice
wise cargoBOT
regal summit
!voice
-__- im aware of that... i cant at least not in the next 24-72 hours
somebody said my name so i was responding to them
thank you though
well hello then!
working up in #1392875462623232022
somber heath
@obtuse axle π
regal summit
nom
noms your arm
ree
whats good
@obtuse axle
yah ngl not having mic perms by defult sucks.
wind raptor
yah ngl not having mic perms by defult sucks.
working on something that might help ;P
obtuse axle
i from poland
wind raptor
It will be quicker to go through the regular gate at the moment though.
vocal basin
idk about "nicest"
very contextual
like "higher-definition" stuff isn't inherently nicer
@novel inlet what is the output and the command you're running?
somber heath
@spark warren π
vocal basin
no stdout is expected result
if you're printing anything, it should be ignored
@novel inlet what is your test file named like?
it might depend on that
somber heath
@cinder flax π
wind raptor
!stream 214319743082037248
wise cargoBOT
β @novel inlet can now stream until <t:1752165696:f>.
regal summit
...
add this in there why not XD
import sys
def global_duck_you_handler(exc_type, exc_value, exc_traceback):
print("duck you", flush=True)
sys.excepthook = global_duck_you_handler
@rugged root π
uv all the way
even if astralsh goes under, we have enough Rust people to continue the project anyway
let uv worry about venvs for you
wind raptor
!resources
wise cargoBOT
wind raptor
vocal basin
I don't really do programming exercises for anything other than entertainment
.wa sh 54kg to lbs
viscid lagoonBOT
vocal basin
π₯
who exploded
nvm, I see I think
okay now I get the answer to which of the two my ideas was that one
vocal basin
@wind raptor also needs moderator role not moderation team role
regal summit
@wind raptor
vocal basin
<@373121697957543946> also needs moderator role not moderation team role
as another indicator of willing to put up with people
regal summit
god we are bad...
we as in thee mutes
im just a little mute
in a little chat
anyway mind ful dev... umm so about the 3 day requirement...
what about account age??
like discord account age
like if your discord account is 5 years old then you get to bypass it
peak depot
No bypass, ever
vocal basin
@wind raptor UPS delivering Discord messages by mail
regal summit
<@373121697957543946> UPS delivering Discord messages by mail
no.
ip over carrior pidgeon.
vocal basin
IP over Avian Carriers
vocal basin
IP over Avian Carriers
why are there whole three RFCs for this
there was a meme which I unfortunately cannot find
regal summit
if mods are in the channel then we get to speak.
peak depot
All the claim are delivered with a trebuchet
regal summit
woot
vocal basin
there was a meme which I unfortunately cannot find
about UDP and new Russian laws
regal summit
so idea
when the channel has relaxed perms. they need to click a button.
that wont hit the server except for when a user needs to access
b r u h
@vocal basin you ever just feel ignored...
wind raptor
when the channel has relaxed perms. they need to click a button.
Button is an interesting idea, but I'd rather it be more auto
regal summit
Button is an interesting idea, but I'd rather it be more auto
im so sorry....
text hard
vocal basin
I have a good microphone I just don't use it on Discord
regal summit
anyway. i feel like users forget they have modderation tools as well.
in the form of blocks mutes and otherwise.
vocal basin
muting isn't a moderation tool, it's a self-defence tool
also, when speaking, don't mute people, put their volume to 0 instead
wind raptor
anyway. i feel like users forget they have modderation tools as well.
So true. Full mute can be bad though if they are constantly talking over that person after though
vocal basin
also, when speaking, don't mute people, put their volume to 0 instead
unless everyone else agrees on muting them
regal summit
yup...
hmmm
maybe allow users to make their own voice channels??
that way the channel creator has "mod" for their channel.
and if some troll wants to troll its far harder.
vocal basin
that way the channel creator has "mod" for their channel.
Rabbit would be first to join more often
regal summit
rabbit??
vocal basin
as for whether that's a benefit, a separate question
regal summit
so heres my proposal:
let users who are voice verified create vc channels.
as long as the channel creator is in the channel they can choose to unmute people.
as soon as the creator leaves, the channel locks and becomes unjoinable, if the last person leaves, channel gets deleted. channel owner can still join back.
vocal basin
creates unnecessary power dynamic between users
regal summit
hmmm true...
amber raptor
Sure, there is a cliche who would take over voice
vocal basin
Rabbit would be first to join more often
any coding question => kicked
amber raptor
any coding question => kicked
As it should be
regal summit
hmm... what about creating a leveling system?
the higher your level the more perms you get
amber raptor
No
amber raptor
Iβm highest level and everyone is voted off the island. For your own good
regal summit
ok.
how about setting a bar. the channel owner rotates randomly.
between the verified users.
call it a host refferendum.
only real problem i see with that is users who are afk.
vocal basin
I only bought a Pixel to f around with the OSes (since it's still not locked down on them)
regal summit
solved via button.
regal summit
I only bought a Pixel to f around with the OSes (since it's still not locked dow...
true.
vocal basin
incendiphone
regal summit
combustable lemon
vocal basin
:lemon_exploding_head:
regal summit
but i wanna splatter my brain
helmet uncomfy
wear shorts too
riddin a harly for fun
sc
vocal basin
@amber raptor at what scale does the shared-by-all-devs database usually become total disaster?
so I can plan when to quit
amber raptor
<@113304266269003776> at what scale does the shared-by-all-devs database usually...
Very quickly
When you have two dev teams with two different managers is generally when it goes off rail
vocal basin
we capped it at three people, where each single query goes through me to approve
amber raptor
we capped it at three people, where each single query goes through me to approve
That wonβt scale
regal summit
why not just have a server that assigns a database instance to each team and spin them up dynamicly??
vocal basin
"sir, this is Wendy's Voice Chat"
regal summit
its like the 5 people 5 chopsticks problem
amber raptor
why not just have a server that assigns a database instance to each team and spi...
Because itβs more difficult
vocal basin
why not just have a server that assigns a database instance to each team and spi...
completely unrelated point
it's not about instances, it's more about schemas
design unit, not a resource
amber raptor
Or have REST API/gRPC other consume
regal summit
ehh slightly more elegant...
vocal basin
I'm pushing towards domain-specific APIs rather than something generic/"""abstract"""
amber raptor
Just rest API will go really fair
regal summit
example?
vocal basin
I'm pushing towards domain-specific APIs rather than something generic/"""abstra...
(generic is often very much not abstract, that's why in quotes)
amber raptor
There is one way to help with chaos and that is stored procedures
regal summit
so what about encoding everything to a json object and passing that around...
amber raptor
But itβs not great
vocal basin
we capped it at three people, where each single query goes through me to approve
I really dislike this even with 1 person involved total
regal summit
hmmm...
amber raptor
Best thing to do is not to start
regal summit
give each their own.
amber raptor
but that slows down velocity
vocal basin
There is one way to help with chaos and that is stored procedures
yeah, I actually considered that as inevitable taping-over plan
amber raptor
The database problem is not "We don't have enough instances" but "Different groups are digging into different tables and when schema changes, all hell breaks loose"
amber raptor
yeah, I actually considered that as inevitable taping-over plan
The problem is they become APIs so you have to version them (so start) AND you don't know which stored procedures are used by who. Finally, alot of devs don't know stored procedures
vs Rest APIs where you can run metrics and so forth
regal summit
... share one db per team. have each team publish a schema for their use case. grant other teams read only access for intigration.
vocal basin
or just don't publish the schema
amber raptor
... share one db per team. have each team publish a schema for their use case. g...
Still does not work
any change to the schemas and other people query stop working, screaming starts, outages begin
gentle flint
regal summit
maybe shema as a service?
vocal basin
what does that even mean
regal summit
version each one. teams check out whatever version is needed for the project. translation layer abstracts it to the central db.
vocal basin
so, an API
regal summit
-_-
vocal basin
that pretends to work like a database
regal summit
thank you.
craggy vale
vocal basin
that pretends to work like a database
GraphQL likes to do that, kind of
but that has its separate issues
amber raptor
What is not modular
regal summit
GraphQL
amber raptor
Yes it is, that's why it's bad
regal summit
now im the one confused.
vocal basin
I don't really trust any existing GraphQL implementations
to get the performance part right
modest finch
@peak depot why i am cannot speaking in here
regal summit
ehh... GraphQL feels like it exposes too much. and fails when everybody wants everything.
vocal basin
vocal basin
regal summit
authorisation
vocal basin
for docs, I default to -sation, for code I try to keep it consistent with external context (defaulting to -sation otherwise)
regal summit
and that has isues
vocal basin
even the dictionary I have installed accepts it as valid
somewhat radically British dictionary, seems like
@jovial merlin real job or Telegram DMs type job?
regal summit
lmao. bro getting more programming work then me... \
vocal basin
I had someone on Telegram offering me a job for >2x my current salary
I half-ghosted them
and now their account is banned
regal summit
ehh i just work on my own apps in my cave
const int sendPin = 7;
const int receivePins[] = {
2, 3, 4, 5, 6,
8, 9, 10, 11, 12, 13,
A0, A1, A2, A3, A4, A5
};
const int numPins = sizeof(receivePins) / sizeof(receivePins[0]);
unsigned long lastSend = 0;
const unsigned long interval = 10; // ms
void setup() {
Serial.begin(9600);
pinMode(sendPin, OUTPUT);
digitalWrite(sendPin, HIGH);
for (int i = 0; i < numPins; i++) {
pinMode(receivePins[i], INPUT); // no pullups pls
}
}
void loop() {
unsigned long now = millis();
if (now - lastSend >= interval) {
lastSend = now;
Serial.print("{");
for (int i = 0; i < numPins; i++) {
bool connected = (digitalRead(receivePins[i]) == HIGH); // HIGH = foil intact
Serial.print("\"");
Serial.print(receivePins[i]);
Serial.print("\":");
Serial.print(connected ? "true" : "false");
if (i < numPins - 1) {
Serial.print(",");
}
}
Serial.println("}");
}
}
^ outputs a json object over serial
lost sage
100%
regal summit
ehh i just used C
regal summit
ehh kinda.
vocal basin
afaik it's their dialect of a limited C++
regal summit
works great as a way to map arduino pins into python
even better to trigger somthing like a pishock device.
vocal basin
funny how some of these are broken links
I'm considering getting an nRF52833 to have the same board that Comprehensive Rust course uses
(to teach it properly)
vocal basin
I'm considering getting an nRF52833 to have the same board that Comprehensive Ru...
@jovial merlin formal contracts only
no trust-based deals
never
vocal basin
<@1319370380078743584> formal contracts only
even when dealing with friends
same goes for loaning a big amount of money to friends
twin gull
hello
vocal basin
mass-non-reply happening
something broke in the dpi bypass software
had to restart it
vocal basin
https://google.github.io/comprehensive-rust/bare-metal.html
was unable to open this for some reason
vocal basin
had to restart it
^
byedpi entered weird state
I'm using separate tunnels for HTTP(S) and WebRTC
the one for HTTP(S) died
maybe in the future we'll see TLS 1.4 fix DPI even working at all
because currently domain names are sent in plain text
Cloudflare has some taped-over mechanism to mitigate that
but not all Cloud hosting is Cloudflare
DPI usually attacks Cloud traffic specifically
because otherwise you can just IP-ban
craggy vale
as i saw u in vc
yeah idk why?
frosty holly
i wanna ask somethign actuallydo u know how to automatically messages in dm
i tried in this video but the delte icon is not appearing
craggy vale
idk
somber heath
i wanna ask somethign actuallydo u know how to automatically messages in dm
Your question would fall within the province of Discord bots. See #discord-bots and its pins for more information.
You might also avail yourself of the help system. #βο½how-to-get-help
frosty holly
Your question would fall within the province of Discord bots. See <#343944376055...
done
somber heath
@main elbow π
main elbow
Hey, Opal, do you remember me?
You helped me with method's the other day
I have a question about languages in general. Why learn a low-level language when you could use a high-level language and then run a program that turns it directly into machine code, then just run that straight to the processor?
somber heath
@dusty jacinth π
dusty jacinth
<@822524918092660746> π
hoelaaa
main elbow
ok
main elbow
Would you recommend reading the py docs as the best way to learn Python? I read an entire book on Python, "around 150 pages long," and I still feel like I don't know much about the language; it only went as far as OOP, and then some basic programs and interview questions.
btw, thanks for the other answer.
somber heath
@rotund fjord π
main elbow
String name = I_Like_forge_of_empires; Console.WriteLine($"Hello" + {name} + ".");
It's in c#
rotund fjord
for a second I thought my understanding of python was wrong
yea the space in the variable name
import math
def solve_quadratic(a, b, c):
# Check if the quadratic is valid
if a == 0:
print("This is not a quadratic equation. 'a' must be nonzero.")
return None
# Calculate the discriminant
discriminant = b**2 - 4*a*c
# Check the nature of the roots
if discriminant > 0:
root1 = (-b + math.sqrt(discriminant)) / (2 * a)
root2 = (-b - math.sqrt(discriminant)) / (2 * a)
print(f"The equation has two distinct real roots: x1 = {root1}, x2 = {root2}")
elif discriminant == 0:
root = -b / (2 * a)
print(f"The equation has one real root: x = {root}")
elif discriminant < 0:
real_part = -b / (2 * a)
imaginary_part = math.sqrt(-discriminant) / (2 * a)
print(f"The equation has two complex roots: x1 = {real_part} + {imaginary_part}i, x2 = {real_part} - {imaginary_part}i")
else:
print("The quadratic equation cannot be solved due to unknown reasons.")
Example usage
print("Quadratic Equation Solver: ax^2 + bx + c = 0")
a = float(input("Enter the coefficient a: "))
b = float(input("Enter the coefficient b: "))
c = float(input("Enter the coefficient c: "))
solve_quadratic(a, b, c)
This code is a simple quadratic equation solver that takes coefficients
a, b, and c as input and calculates the roots of the equation using the quadratic formula.
It handles real and complex roots based on the discriminant value.
main elbow
x = I_Like_forge_of_empires print(f"hello {x}!")
That be wrong, i am new to python...
rotund fjord
can someone review this
wise cargoBOT
can someone review this
Please react with β
to upload your file(s) to our paste bin, which is more accessible for some users.
rotund fjord
need help changing this to where it solves from all 3 forms of quadratic equations: standard, vertex, and factored form
not just standard
somber heath
!code
wise cargoBOT
rotund fjord
My teacher told me that I can't write it where there are 3 functions (one for each way). that was the challeneg
main elbow
I will be back later
rotund fjord
oh yea
I could try to make the program check which values are inputed (a b or c) and based on that it will solve
will try
instead of having to provide a full equation with a b c filled in
yes
yes
one problem can be solved in 3 different ways
that is why no making this 3 functions is hard
function one - determines
function 2 3 4 - the ways to solve
we did that last time
the next challenge was to do it with less function
that is where I sturggled
kind of
will try that but I don't know if that is what he is looking for.
just a minute
pulling up my friend's code
here it is
wise cargoBOT
here it is
Click here to see this code in our pastebin.
rotund fjord
that is his code
how do I do that
it redirected me to a website
I pasted it there
it doesn't show there
here
do you see it?
like try and except?
ok
one thing
I looked at his code
and saw that the function is not even ran
it imports then defines the function but nothing to run it
will tell him that
complex?
let me look that up on w3 schools
don't go there?
somber heath
!e py print(1+1j) print(abs(1+1j))
wise cargoBOT
!e ```py
print(1+1j)
print(abs(1+1j))```
:white_check_mark: Your 3.13 eval job has completed with return code 0.
001 | (1+1j)
002 | 1.4142135623730951
what does that do exactly?
somber heath
!resources
wise cargoBOT
rotund fjord
I ran it in VS Code and it printed pi
ok
thanks
i think so
not sure
ohh
my bad
somber heath
!e py import math print(math.pi)
wise cargoBOT
!e ```py
import math
print(math.pi)```
:white_check_mark: Your 3.13 eval job has completed with return code 0.
3.141592653589793
what does "abs" do?
oh. because it is not just an integer or 2 digit decimal like coordinates
complex numbers
ok
nice
somber heath
!d complex
wise cargoBOT
rotund fjord
do I need that in my quadratics code?
somber heath
!e py print(complex(1, 5))
wise cargoBOT
!e ```py
print(complex(1, 5))```
:white_check_mark: Your 3.13 eval job has completed with return code 0.
(1+5j)
if the number is irrational I will try to display it as an error or ask the user for a valid input
will use the try and except thing
I thought irrational numbers would be considered a complex data type
I know that pi is displayed as a float
one more question
what about imaginary numbers,
is that what you meant by the x and y example
oh
that makes more sense
thanks
ok
appreciate the help
I ask my teacher if we need to include complex data types int he quadratics code (we might have too but I don't see why)
ok
I will try and get back to you with the results
thanks for the help.
bye
somber heath
@narrow palm π
narrow palm
hi
wise cargoBOT
!e
print("Hell WOrld")
:white_check_mark: Your 3.13 eval job has completed with return code 0.
Hell WOrld
forest gorge
<@1393097445323444285> π
KimTong btw
new acc
what problem are you facing @jovial merlin
somber heath
@lucid sail π
lucid sail
Give me perm
somber heath
!voice
wise cargoBOT
lucid sail
Ok
somber heath
@ember ferry π
obsidian dragon
nya~
ember ferry
pardon
obsidian dragon
how are you, what projects are you working one
somber heath
!voice
wise cargoBOT
peak nest
I have to wait 3 days for the permision
somber heath
@unborn valve π
somber heath
so I can't really talk until maybe tomorrow
You're still welcome to hang out.
versed heath
somber heath
@young cargo π
somber heath
@raw hedge π
somber heath
@slow mountain π
somber heath
<@317279909112446976> I'm not able to unmute
!voice
wise cargoBOT
tender hamlet
Didn't hear anything before minute ago. Audio issues happened.
peak depot
odd hollow
hello
odd hollow
@somber heath@peak depot sorry guys anyone of u know about pandas and csv files ??
i start learn it foe two weeks and its just seems wierd like i did this this morning and i asked gpt aboout it and he said its too good that what companyes need
import pandas as pd
df = pd.read_csv("CSV_File.csv")
#1
print (df.shape)
print (df.columns)
df.info()
#2
df.rename(columns={
'id':'ID',
'full_name':'Name',
'years':'Age',
'grade':'Score'
},inplace=True)
#3
df.fillna({
'Age':df['Age'].median(),
'gender':'Unknown',
'Score':0
},inplace=True)
#4
df.drop(columns='country',inplace=True)
#5
df[['Age','Score']]= df[['Age','Score']].astype(int)
#6
print (df[(df['Score'] > 80) & (df['gender'] != 'Unknown')])
#7
df.to_csv('students_cleaned.csv',index=False)
#bonus
print (df['gender'].value_counts())
@somber heath@peak depot what do u think !
i am i in the right track
vocal basin
What is the semantic significance of those comments?
odd hollow
@somber heath is this how its work is this how people work with pandas csv file
ill take a screenshot and show u
wiat
sorry
wait hh
vocal basin
What is the semantic significance of those comments?
that sentence sounds way too much like something Maroloccio would ask
somber heath
@urban ledge π
vocal basin
What is the semantic significance of those comments?
I guess it can make sense if the original task has stuff numbered like that
- do this
- do that
bonus) do else
odd hollow
wait its uploading
@somber heath@peak depot its a small file but ive work with a larg file like 5k rows and 20 culomns
peak depot
You still have not given us 'what is the issue' with your code
odd hollow
i know m a bigenner and the question is i am in in the right way to learn is this how its work ?
odd hollow
You still have not given us 'what is the issue' with your code
no not issue i ask if is this how people work with pandas csv in reallife
their's no issue
odd hollow
i know m a bigenner and the question is i am in in the right way to learn is thi...
that the question
my goal is to be a data enginner
vocal basin
Rust is relatively fine for ad-hoc CSV processing, as I recently learned
especially if you want to turn a JSON into a CSV
or inverse
vocal basin
especially if you want to turn a JSON into a CSV
it's, like, a nearly braindead task of just overusing serde
with the only slightly tricky part being flattening on the CSV path
peak depot
my goal is to be a data enginner
It's a university degree
vocal basin
also https://pola.rs/
odd hollow
It's a university degree
i do self study
peak depot
And again: working with datafiles, I recommend Jupyter Notebook
vocal basin
@somber heath classic
peak depot
'Engineer' is a degree
odd hollow
so ill try to get a degree from any website like coursera or aws
vocal basin
<@317279909112446976> classic
alongside the seasoned veteran joke
odd hollow
And again: working with datafiles, I recommend Jupyter Notebook
why jupyter
peak depot
Check youtube videos about it
odd hollow
okay ty guys for ur time π
vocal basin
'Engineer' is a degree
very regulated qualification in some countries afaik
as in no paper => legally not an engineer
Wikipedia's opinion on data engineers
peak depot
brb
somber heath
@willow quest π
stuck furnace
Hey
Join and the first thing I hear is Rabbit saying "everything sucks" π
Ah right
somber heath
@twin gull π
vocal basin
printerfighter
stability
some weather really happening around kiwiland
@midnight birch are you interested in doing that as an extension for Redmine?
I'm currently trying to convince the CTO to make the one we haven't yet started making be born open-source
Redmine has great data model and terrible UI
terrible-looking UI
(but kind of usable)
power-
vocal basin
power-<:flag_bisexual:585954608346824731>
this is now part of the usual joke repertoire
vocal basin
where do i showcase?
do you have a public repository for your project?
and what kind of project is it?
lethal rune
do you have a public repository for your project?
yes if u have instagram u can search it up
astrixesql
lethal rune
and what kind of project is it?
im trying to build an sql from scratch using python as the background language
im also using pandas to get the data in a structured form
vocal basin
normally projects would be published on GitHub
vocal basin
im also using pandas to get the data in a structured form
so, SQL adapter for pandas?
lethal rune
normally projects would be published on GitHub
yea but im not that courageous i guess
lethal rune
so, SQL adapter for pandas?
an sql which works with pandas
i think i have a video of it hold on
yep
vocal basin
normally projects would be published on GitHub
I highly recommend to look into how to use Git and publish code either on GitHub or GitLab
#databases as some general information on databases
#data-science-and-ml is usually where pandas-related discussions are happening afaik
lethal rune
<#342318764227821568> as some general information on databases
<#366673247892275...
ohhh
vocal basin
I highly recommend to look into how to use Git and publish code either on GitHub...
or Codeberg if 1) it's ideological open source rather than just happens-to-be open source 2) doesn't require CI for most of its life
lethal rune
oooh
i do a lot of projects when i get free time
i also made a tic tac toe which you can play on the output screen
no extra modules NOTHING
vocal basin
i do a lot of projects when i get free time
generally, it's worth uploading those to GitHub even if they're not yet finished/not entirely in the best state
it's more about not uploading stuff that shouldn't be in Git to begin with
for example, venv should be .gitignored
there are some pre-defined .gitignore examples for Python, JetBrains IDEs and other stuff
lethal rune
generally, it's worth uploading those to GitHub even if they're not yet finished...
im planning to start a community named astrixe so does posting the code there will help?
lethal rune
pandas itself has sine SQL too
<https://pandas.pydata.org/docs/reference/api/pan...
wow
vocal basin
im planning to start a community named astrixe so does posting the code there wi...
you can make a GitHub organisation for it
lethal rune
you can make a GitHub organisation for it
if i want it as a discord server too?
vocal basin
I think there are ways to two-way link those
if there isn't such integration yet, you can make it
lethal rune
ooh
vocal basin
infrastructure for this server is open-source too, and there is some linkage between staff members and GH org members afaik
lethal rune
i started with this project by myself but now i feel like i want to work as a team
vocal basin
working as a team is useful for preventing a project from dying
lethal rune
working as a team is useful for preventing a project from dying
true the thing is like IDK why this idea came into my head THIS YEAR
vocal basin
ZeroMQ has a contribution model where each change needs to go through at least two people each time
lethal rune
this year is very important for me like i need to focus on myself and yea i wont really be able to get back on this sql thing
so if possible i need a team
vocal basin
true the thing is like IDK why this idea came into my head THIS YEAR
I highly recommend focusing more on learning how to find such ideas/solutions rather than getting locked into implementing a particular idea
ideas individually are cheap, but being able to come up with one when its needed is valuable
lethal rune
I highly recommend focusing more on learning how to find such ideas/solutions ra...
probably the thing is
vocal basin
@peak depot it's the second time you misheard it that way today
lethal rune
i have python in school to learn as a subject
so this year only i learned stuff like file handling and all
soo no wonder why this idea came this year
vocal basin
i have python in school to learn as a subject
do you have code style/quality enforcement at school?
lethal rune
do you have code style/quality enforcement at school?
wdym
vocal basin
I guess a more important question is:
do you have some automated system where you submit solutions which then get tested?
lethal rune
I guess a more important question is:
do you have some automated system where yo...
we have a project to do at the end of the year so yea
vocal basin
I mean more like individual exercises
vocal basin
back when I was at school and then university we had that
lethal rune
back when I was at school and then university we had that
were u in CBSE syllabus?
vocal basin
I have no idea what that acronym stands for
vocal basin
I studied at a mathematics-centred class in the last 4 years of school
then did 4 months of (unfinished) programming engineering degree
lethal rune
CBSE is central board of secondary education
this is the syllabus in india
4 years ago before covid they chose c++ for computer science students
after covid
they switched to the best language
python π
vocal basin
back when I was at school and then university we had that
usual process there was:
- send a solution into the system => reject on syntax or compilation error
- it gets style checked and linted => reject on lint issues
- it gets tested => reject on wrong answer or runtime error
- it gets sent to the educator for approval => reject on manual review issues
- it gets accepted
reminiscent of CI
vocal basin
usual process there was:
1. send a solution into the system => reject on synta...
@peak depot do you have something like this where you study?
lethal rune
usual process there was:
1. send a solution into the system => reject on synta...
woww
so u guys are in college doing computer science?
vocal basin
I dropped out of the university some years ago
lethal rune
I dropped out of the university some years ago
ooh whys that
vocal basin
lethal rune
https://discord.com/channels/267624335836053506/412357430186344448/1319290582916...
im really sorry for u
hey @vocal basin be honest
vocal basin
CREATE TABLE in SQL normally means just making the table itself without populating it with entries
special characters/syntax looks a bit too esoteric
lethal rune
uhhh
what is esoteric?
intended for or likely to be understood or enjoyed by only few people with a special knowledge or interest
vocal basin
specifically these parts
lethal rune
*intended for or likely to be understood or enjoyed by only few people with a sp...
yea thats exactly how its supposed to be
lethal rune
specifically these parts
thats because of the name
the name astrixe is derived from asterisk *
and then i went to google searching up asterix symbols and i found that asterisk in a square soo i used that
vocal basin
you also probably don't need the build info pop-up if it's a Python package rather than a compiled program
lethal rune
you also probably don't need the build info pop-up if it's a Python package rath...
like the startup message?
vocal basin
not entirely sure what this is either
vocal basin
like the startup message?
the first part of it (not the help part)
lethal rune
i asked chat gpt to generate a sentence for tht π
vocal basin
not entirely sure what this is either
(there is MSSQL and Access, no WindowsSQL afaik)
vocal basin
yeah, write what you actually find useful rather than just trying to imitate
the purpose of a built-on-that-date-and-that-toolchain line is to specify where the build comes from
vocal basin
to more easily track bugs and other differences which happen
if you're including a code license, copy it from the actual source not from ChatGPT output
because it can make mistakes
lethal rune
if you're including a code license, copy it from the actual source not from Chat...
actual source?
vocal basin
lethal rune
https://opensource.org/licenses
what do we do here
vocal basin
for example,
https://opensource.org/license/mit
lethal rune
ooooh
vocal basin
the top part you can just drop if you have it written elsewhere in the codebase
but you can also fill it in
year is optional
vocal basin
the top part you can just drop if you have it written elsewhere in the codebase
I usually drop that part entirely because I have copyright and authorship information stored in the package files instead
vocal basin
SQL is a specific standard, which that program does not look like
so it maybe better to make a different name for it
lethal rune
SQL is a specific standard, which that program does not look like
so where did i mess up?
vocal basin
where did i go wrong?
I'll go back to describing soon, currently answering another question
lethal rune
okay
vocal basin
are we in the kernel or userspace?
do we know struct sizes upfront?
-# actually slab allocator shouldn't entirely care about that
so, we can't allocate a single struct or just all of them in a single go?
there is a very wrong way of how to do it I think
which I wouldn't do but it's funny
lethal rune
THE GREAT LEGEND
vocal basin
so where did i mess up?
SQL normally looks something like:
CREATE TABLE users (
id,
name
);
INSERT INTO users (
id,
name
)
VALUES (
123,
'Alice'
);
except the formatting , I wouldn't format it like this
mmap null at a specific location and hope it doesn't return E_BAD_IDEA
vocal basin
yeah that option make sense
sleek otter
Hi
vocal basin
my default voice pitch is very random
true bane
btw its good
sleek otter
How do I get permission to talk in the voice channel?
lethal rune
SQL normally looks something like:
```sql
CREATE TABLE users (
id,
name
...
oh yea i made it a bit more easy i think
wind raptor
How do I get permission to talk in the voice channel?
!voice
wise cargoBOT
lethal rune
that >>>* is where u specify a function
weather to create a table
alter
modify
insert
etc
im working on alter rn
like RN
im only 17 bruh
vocal basin
my default voice pitch is very random
wide range, even when not on-purpose
wind raptor
vocal basin
CV can be done without ML
AI is just a buzzword
LLMs are ML
even trivial gradient descent is indistinguishable from ML, so you can probably count it as such
true bane
again
vocal basin
@wind raptor what if it's a philosophical question
lethal rune
alright guys i gotta go
it was AMAZING talking to u all
@vocal basin accept my friend req?
true bane
okay thanks for coming
vocal basin
even trivial gradient descent is indistinguishable from ML, so you can probably ...
there is deep learning, which is basically all ML people usually refer to as ML
sharp summit
even trivial gradient descent is indistinguishable from ML, so you can probably ...
lol gradient descent in comparison to other algos is CHEAP
vocal basin
lol gradient descent in comparison to other algos is CHEAP
most ML is just a different flavours of gradient descent
optimised differently
vocal basin
there is deep learning, which is basically all ML people usually refer to as ML
iirc deep learning is just "there are hidden layers"
true bane
r u joking
vocal basin
Arch enemy
Debian-man, the enemy of Arch
sharp summit
> Arch enemy
Debian-man, the enemy of Arch
π
true bane
vocal basin
CV can be done without ML
for a long time, cameras' face recognition algorithm was an actual algorithm
true bane
pprobably no i think
vocal basin
@midnight agate this:
fn stack_leak<T>(value: T, f: impl FnOnce(&'static T) -> !) -> ! {
f(unsafe { std::mem::transmute(&value) })
}
bro u can practice operating system
vocal basin
though ig it can take by-ref already
fn stack_leak<T>(value: &T, f: impl FnOnce(&'static T) -> !) -> ! {
f(unsafe { std::mem::transmute(value) })
}
never return => never hits UB
fluid wagon
he
vocal basin
https://tenor.com/view/the-phantom-entrance-pentagram-arch-enemy-phantom-gif-199...
Alissa π₯
vocal basin
Alissa π₯
vocal basin
@wind raptor allegedly, several hundred
but that's not necessarily all devs
like devs and non-devs likely is around couple thousands
as in most of Epic's employees
meanwhile PUBG is just ArmA with mods
upper basin
lethal rune
hi im back
vocal basin
the time has come
starting to play BG3
oven integrated into the car
cook it while driving
9 am or pm?
wind raptor
oven integrated into the car
Just keep the box ON the engine
vocal basin
yes
wind raptor
Hot pizza
vocal basin
now you not only have car smelling like pizza, but also pizza smelling like car
lethal rune
now you not only have car smelling like pizza, but also pizza smelling like car
hows that even possible...
vocal basin
petroleum fumes seasoning
wind raptor
According to the marketing department, we can call this "smoked"
vocal basin
According to the marketing department, we can call this "smoked"
lead-enhanced
high-octane pizza
wind raptor
I use unleaded fuel. so maybe unleaded pizza
wise cargoBOT
Created: <t:1483877013:R>
Roles: 130
Member status: 
46,318 
356,548
vocal basin
odoo-meter: measures how many odoo ads were in the video
oh wait they're open source
didn't expect that
Fluent
the what
wind raptor
Never heard of odoo
vocal basin
only heard of them through ads
wind raptor
do u guys like pizza?
Yeah! Soo good
lethal rune
Yeah! Soo good
bro like dominoes in india is actually REALLY GOOD
like even if they take some time to bring it to ur home u would still get that cheese pull
wind raptor
like even if they take some time to bring it to ur home u would still get that c...
Best cheese pull = cut pizza, then melt the cheese onto it
lethal rune
Best cheese pull = cut pizza, then melt the cheese onto it
have u tried deep dish?
wind raptor
have u tried deep dish?
Oh yeah. depends on the type of deep dish you mean though...
lethal rune
Oh yeah. depends on the type of deep dish you mean though...
like the one in yt shorts and all
chicago deep dish
wind raptor
this is a thing apparently
We don't have it in Canada as something from the chains here
We keep the cheese on top here
lethal rune
We keep the cheese on top here
woww
its actually delicious but tbh a bit too much cheese for me
like i prefer everything with a limit
wind raptor
I've tried it from a local bbq place and it was really good
This is what we usually get though if we get "deep dish"
exotic loom
hi
vocal basin
I have codewars configured to use Vim keybinds
vocal basin
the time has come
starting to play BG3
doesn't seem to run at 60fps
can I have this but without the extra difficulty part
fierce sail
wassup guys!
wind raptor
> < - unhinged x
fierce sail
howz it goin?
wind raptor
howz it goin?
Good, how about you?
fierce sail
cool!
wind raptor
yo lowk i didn't realize i was un-mute
No worries. Happens to all of us haha
sharp summit
No worries. Happens to all of us haha
lol
vocal basin
by 23rd time that opinion might turn into action
rugged root
Also I want to apologize. I feel like when I show up I overtake the conversations, which isn't really my intent. Sorry
wind raptor
Also I want to apologize. I feel like when I show up I overtake the conversation...
You were on topic (pizza) when you joined
rugged root
Nice
sleek otter
I have codewars configured to use Vim keybinds
nice
vocal basin
@wind raptor from what I understand, it's more of a general-high-quality game for general audience rather than for people who are really into the genre
I'm not doing any mods early on in games usually
ah
hmm
@wind raptor okay, found it, yeah, will do that
@buoyant loom being fluent in C++ is kind of impossible, so ig that
wind raptor
<@373121697957543946> okay, found it, yeah, will do that
It's one of those things that's easy to miss and affects the entire game
vocal basin
@buoyant loom so those people just like do to ceremony instead of programming
they aren't dissing Python, they're dissing themselves
vocal basin
<@1266770377238118402> being fluent in C++ is kind of impossible, so ig that
it's way too much knowledge for one person to handle
why not C++: it's a bad language
it's not hard because you need to learn it first, it's hard because it's wrong
I've never read books on algorithms
raw hedge
hi guys
vocal basin
I just read Wikipedia, source code and other random places
whatever comes up in the moment
STL is a good source for learning algorithms
rugged root
(making a character currently)
Which class?
sleek otter
which book?
wind raptor
vocal basin
Which class?
ranger (not really based on anything)
randomly choosing kind of
you can't "follow" a road map
you can follow a road