#voice-chat-text-0
1 messages · Page 859 of 1
i'm dead 
She gets so much mileage out of that emote
it me. das y
Happy Eyeballs (also called Fast Fallback) is an algorithm published by the IETF which can make dual-stack applications (those that understand both IPv4 and IPv6) more responsive to users by attempting to connect using both IPv4 and IPv6 at the same time (preferring IPv6), thus avoiding the usual problems faced by users with imperfect IPv6 conne...
@frail aurora Apparently I have to go change a light bulb in the office and then take a ladder to the office next door to us
Sooo, I'll be back in a bit
thats fine
ill be here vibing to some music 


Thrash Unreal, Against Me!, New Wave
thanks, I don't think I will
icannot stream
!
i want to dirnk
@dense ibex so turns out that crabs are like, evolutionary ideal body shape: https://en.wikipedia.org/wiki/Carcinisation
Carcinisation (or carcinization) is an example of convergent evolution in which a crustacean evolves into a crab-like form from a non-crab-like form. The term was introduced into evolutionary biology by L. A. Borradaile, who described it as "one of the many attempts of Nature to evolve a crab". Most carcinised crustaceans belong to the order Ano...
Can't wait to become a crab

hello
Hoe gaan dit ?
Needs to be called hairy eyeballs.
ican't talk
okay
so i need to verify my voice
by sending 50 message
😭
@paper tendon ???
@mystic kernel i'm noobie i took kaggle course
still on progress
Oh I see
Im into computer vision
and Im having a small doubt
have you every worked with point annotations?
@mystic kernel never heard of it , but did you searched in google and other engines
I tried and I didnt find what I was looking for
Ive been suffering tears and sadness for days not understanding how point annotations work
I'm doing their python +ai course
@keen shell Do you mean spoken or programming language?
Programming
Python, JavaScript/TypeScript, C#, Java/Kotlin, and to a lesser degree Elm, Rust, and a few others
@icy axle Explain yourself, you beautiful man
@hexed lily hi
djWjfzlql z
ni ga ga ra ha wai
view : Model -> Html Msg
view model =
div []
[ button [ onClick Decrement ] [ text "-" ]
, div [] [ text (String.fromInt model) ]
, button [ onClick Increment ] [ text "+" ]
]
!u
!server

Created: 1 year, 5 months and 12 days ago
Profile: @dense ibex
ID: 670802831678373908
Joined: 6 months, 3 days and 22 hours ago
Roles: <@&542431903886606399>, <@&463658397560995840>, <@&764802720779337729>, <@&764245844798079016>, <@&854107452243968040>, <@&585529568383860737>, <@&267630620367257601>, <@&787816728474288181>
Total: 2
Active: 0
Hello @rugged root
Please subscribe to my new channel!
http://www.youtube.com/user/xDuliS
thanks for the likes on the video guys your all awesome :D
cheese
Is delicious, yes
yup
why are car prices increasing tho?
cuz of semi conductors i dont think so
i dont think thats a good idea
even on electrical vehicles
Agreed
@rugged root I am back
I am struggling with writing C programs
I'm learning C
I am being haunted by something called segmentation fault.
why does everyone like rust?
what can you use it for ?
so like python but for desktop apps and stuff?
soory i am really stereotypical with languages
that makes sense why people like rust then
Discord is (mostly) written in Rust
oo damn
damn
did not know that
lol

i thought discord also used js
ooo
whats your guy's hatest language?
mine is java
I don't really have one
Java was my first language, so I'm used to the quirks
Granted I haven't used it in.... probably a decade
well it was mine first language too but i almost quite programming by itself
u know what i only know one language
yup
python
lol
no i am not mod
but like i dont get why java has complex syntax than c but still slower
does the create hate humans?
but that isn't a technically the trait of it i could build a language better than it and people would like that better if it also ran on almost everything
Hehe, my first language is Pascal
It sucks
now like even if people dont like it they are stuck at it if they want to develop android apps
same
i would love that although ngl i never even got past printing hello world
i think you do it likejava system.out.println("cheese");
?
Sounds right
There's more boilerplate to it
And there are good reasons why they do that stuff the way they do.
But it is stupid verbose
Kindling Projects
The Kindling projects page on Ned Batchelder's website contains a list of projects and ideas programmers can tackle to build their skills and knowledge.
you can do project euler from question 35
No no, I mean if you click the link, the bot has there, it'll take you to a crap ton of stuff
And you have to read. Hell, you're reading right now
Dude, Euler breaks my brain
So much focus on algorithms
12851 feel old yet hemlock?
?
If your age were 30, the program would think you are 69420 years old.
90, not 51
your age is 12851 it said
Hey mina 
Ah, gotcha
I still have a long way to go...
hallo
The IT dude still incompetent?
the PC is ordered 
The right one?
i think its better to buy a rasbery pi than like buy server hosting
@whole bear Depends on your needs
add to cart > checkout
<@&267628507062992896> C is really a challenging language. C++ makes things easier, but I still have to start with C before I can play with C++, even if it means getting pissed off by the compiler.
the only thing i told him to change is remove the keyboard & mouse
But yeah, for just starting out, a Pi is a great choice
True, there's some benefit to the rage
? Did you mean to ping Admins?
@hollow haven Hi Kat
Katsumi, please don't ping Admins unless it's for a legitimate reason
There are times when Admins need to be pinged, Beautiful
And people who abuse it receive infractions as needed
Hey Kat, wanna see your real age?
Did it hurt?
HA
hello
Who?
As your guy's IT?
okay but it will be still be....
IT expert extraordinaire
Eh, we're used to it
hi
"Expert"
i love opeining different files in a folder with vs code and after 1 week just sit and croos all of them out
🙂
the bar is not high here. you'd definitely raise the bar
Still important to look back and see much how you've improved
you'd not get away with being on vc tho :(
i bet the pay is shit, but i'm curious. i'll try to poke my nose around
And to compensate with cost of living
i doubt lmaoo
Yeeeeep
what abt more sysadmin type work?
i'm fairly certain network guy is paid ~75k as of a couple years ago
Well that's like
i don't like him either lmao
once you compensate for COL idk how much it'd be
hi furyo!
no i'm mina
call me mina
lmao
it's colemak homerow keys
arst neio
asdf jkl;
#include <stdio.h>
#include <string.h>
int main() {
struct info {
char name[0xff];
unsigned age;
} user;
char n[0xff];
int a;
printf("what is your name bro? ");
gets(n);
printf("how old are you? ");
gets(&a);
strcpy(user.name,n);
user.age=a;
printf("your name is %s\nyour age is %d\n",user.name,user.age);
return 0;
}
What it outputs:
i thought it was the same because the position of q,w and z,x,c,v,b and a
bc it's a different layout, called 'colemak'

idk the full history but apparently the currently universal qwerty layout was designed to be inefficient, back in the typewriter days
ohh
why whats wrong wih you
i dont use it i am just saying that people that use these are strong or something
January 1, 2017 isn't just New Year's Day… it's also the Internet's 34rd birthday. On January 1, 1983, all the computer systems on the ARPANET, created by the Department of Defense in 1969, were required to switch over to the TCP/IP network protocol that it still uses today, giving birth to the Internet as we know it. But how well do we know i...
tl i'm not gonna read
agreed
Of course
damn
Good luck typing anything with this keyboard layout
i felt that i had better alternate usage of hands for common letters when i used colemak
though it was literally 1 hour maybe
can anyone recommend me a good datastructures and algo course?
video format would be nice
i really dont like reading
@rugged root Good luck
🙂
There are many alternative layouts for keyboard even for a single language, but the largest hindrance to finding a unified ‘best solution’ is the lack of empirical evidence showing that certain factors (i.e. hand alternation versus consecutive close di/trigraphs) are preferable to others. For instance, the alternation versus combination debate (as well as pandering to QWERTY users) is the cause of split between Dvorak and Colemak, the two most popular alternative options.
Dvorak emphasizes hand alternation, meaning that in a given word, hands will alternate typing each subsequent character. This has been shown to increase accuracy and decrease hand strain, as contortion of the hands are unnecessary, and there’s greater time provided between keystrokes to move the hand to the necessary position.
On the other hand, Colemak emphasizes placing commonly used letter combinations close to each other, allowing ‘rolling’ of the hands which also severely reduces strain. This causes issues with words using less common combinations, and the lack of alternation leads some to anecdotally state that it’s easier for slower typists to operate.
However, Colemak also took the controversial step of preserving most of QWERTY’s modern keyboard shortcuts to lower the transition time, though this is a large negative for fresh learners or those willing to put in extra practice time. QW and ZXCVB and all the punctuation are all maintained, which reduces switchover time/muscle memory failures at the cost of being overall less efficient than possible.
all this being said, i use QWERTY lol
I've got a better keyboard layout than @vivid palm's Colemak.
Check this out...
i am a faker. i use QWERTY
after qwerty azet is the most used i think
Guess what layout this is, and I'll give you a thumbs up.
AZERTY is a specific layout for the characters of the Latin alphabet on typewriter keys and computer keyboards. The layout takes its name from the first six letters to appear on the first row of alphabetical keys; that is,. Similar to the German QWERTZ layout, it is modelled on the English QWERTY layout.
Because he once spammed too much, everybody could not bear this.
So they muted him...
uhhhhhhhhhhhhh
but like he is the owner that does not matter?
How about this one?
i think its awesome i get to learn coding more
Trypanophobia
it depends person to person
hello @keen shell

hlo can you hear me
can you explain soory i lost you
Pastebin.com is the number one paste tool since 2002. Pastebin is a website where you can store text online for a set period of time.
Ban @whole bear
@round beacon is my friend
lol same
@sand kayak how long it took to learn a language??
but like i quite like in hello world kind of thing
java is really not a beginner friendly language
i say 1
1
14
10
69
python
i think a fast majority of people who use discord are teenagers
ohh
yep
same
which one is easiest one??
true
😦
langugae?
yup
i would say python
yes
hmm
and no its not scratch its garbage
Scratch is good for kids starting as a bare beginning
@keen shelland then there server crashed
just automate it @keen shell
but not at a very stable base.
i think if the kid is even at 6th grade i would rather recommend python than that
i think
ok then i guess thats good
but like the difference in scratch is huge
it will be hard to understand it

life is about suffeing
awwwww
nvm
you know what does not make sense tho that they chose to teach us scratch rather than python in 10th grade 🙂
10th grade SCRATCH really?
and its weired cuz we learnt php at like 8th grade
and 7th grade html
lol
i think u got scammed ngl
2.1k rupee hmm
i got for free
jk i think nitro is a waste of money
sad
its 12+
if they claim they are 12
in a serious way you might get banne
d
ya
i have met
one
i think like if they think you seriously are 13- then you wlll get baned
cuz its against there terms of service
@rugged root your voice
||sorry for ping||
I don't mind pings. And thank you

@flint hill What's up?
better version of a rick roll -> https://youtu.be/TzbiaTTLItw
Yea see i told u it wasn't a "Rick Roll" but close enough lmaoooo. Anyways 500k subs for the full version 😏!!!
Follow my Instagram: https://www.instagram.com/jrzl7/?hl=en
Follow my TikTok: https://www.tiktok.com/@jrzl?lang=en
portugal?
same for me too
it just says how much power he has
like kinda ridicules tbh
yea thats one reason they are also called celebrity/influencers
what if i want to call it tall coffee?
i dont like the empact they have
idk i just hate 1 person having all the power i guess
hes not a dictator

paul pogba also rejected coca cola
thats tea
how are you muted but not muted hemlock
coz he's admin
oh yea
i had a question idk if this is the same or not in us and stuff but at least in south east countries when you are at 10th grade you first are to choose a subject and like they are more serious about that exam then anything else like seriously your whole school life does not count if you dont get good marks is it the same in the us?
lol
: )
!stream 737321460435124285
@flint hill
✅ @flint hill can now stream.
.
Sorry, reading now
I think that happens in some places in Europe
Not so much in the US
thats so weired cuz the pressure here like is insane
you can choose which subjects you want to learn right? in your country
Him or me?
and like i dont think it makes sense like if you just get enough to pursue your subject i dont think it should mattter
subgame
yes but like you know parents want u to choose something else useally just become a doctor
and i guess you could see why they are so serious about exams since they have to get 80 above to choose science
nepal
i mean ya there aren't a lot nepalease people who use discord
wowwww
that wooof
he does not seem to happy
ya
no i think you can change paths
but like the grade is final
XD
also is it bad that idk what i have to study to become a software engineer 👀
i guess that makes sense
how old are you
Which
31 wow i am just the backwards
69
All good
buy a cat and see what happens
kick it
cat bad dog good
.catify
Your catified nickname is: BeautifulRequest | ᓇᘏᗢ
k bye guys
Just change your nickname
how does that analogy make any sense
well linux increased their market share by 2% in os after release of kali, and mac did like 5% so i might think in like 20 years windows(microsoft) might fell off the os market
not necessarily. even if they start supporting games, they have to do something much better to get people to switch
they don't care, the cost of windows is baked into the cost of the machiens
??????
the linux kernel is literally free
it doesn't sell your data
????????????????
windows is comfort ...people have gotten used to it
ive read that windows is more vulnerable to get breached
what's north carolina
A state north of South Carolina
what do you guys think about google when it will fall like yahoo
lol
when people stop depending on it
and duckduckgo will takeover it
not hapenning
DuckDuckGo will be popular for folks like us, but regular users don't care
Or know to care
;-;
even i dont know its full use case i just use google
This happened with me I told people at my org Duckduckgo was better
yes
One of my managers was afraid that Duckduckgo would get us all hacked so just told us to stick to Chrome
As it was trustworthy
category error?
well i turned full on duckduckgo
after this
Most people now know companies like Google and Facebook collect and sell your data. Yet some people still think, "So what? I have nothing to hide." Here's five compelling reasons to tell them why your privacy is worth more than you think!
If you're ready to take steps to protect your data, we're here to help. At DuckDuckGo, we think the Interne...
and one more video
He did a google search like this and told me to stop using Chrome, I just use Chrome for work stuff now
Yeah I said the same thing
So it was a political move
whats the source
Or supposed
pretty dumb move if you can verify it in like 30 seconds
eh we had some border situation heating up with china so government banned almost all chineese app but not zoom
Fear is more powerful
@rugged root the not joe constraint is off
I tried arguing then thought If Boss says its right, its right
Zoom is from China?
Don't say anything though
yes
Wait how
fear was in the french revolution that why it got so violent
Yea
It's a joe uno reverse card trigger now
lol
He's clever
I blame Chris because Chris showed him triggers
Zoom Video Communications, Inc. (stylized as zoom or simply Zoom) is an American communications technology company headquartered in San Jose, California.
Yeah that's what I thought
It now reflects the infraction to a random admin I believe, or maybe just me
HA
lollll
that's not how savings accounts work fyi lol
that's...really not good
that's incredibly volatile
no it was chinese wait
Well it's your turn to get back at him @hollow haven
Yes
I can't! It'll reflect the infraction back to me/an admin
and...stocks are
thus your stocks are not 'savings accounts'
yes it is
the lies. lol
gilly gilly
hmmm i thought it was chinese but it isnt
fite me, @dense ibex
for personal finance
For a some time I thought he was saying "satan's accounts" was very confused
oooooo
✊
yeah i keep hearing it from my peers as well. don't know where its coming from

Lmfao that emote
loll
it's my fave. lmao
that's disgusting
hello!!
did someone said fight?
you should stop, you'll summon rabbit
what's going on????
summon rabbit
and furyo
🐰
ffs

LOL
nOooOOooO gilly waee
bruh
bruO
wait rabbit
bruhhh
wait. 10 or 100 o.o
1000
i meant 100
OoOoOoOoOo
i didn't realize the stock was this cheap lmao
i have to go guys bye!
(i'm also not being f'real)
lolol
Breaking bad
What'd I do
your social credit is going down @rugged root
too bad, spoke bad words against the state
@rugged root @amber raptor fiance found the perfect crypto meme yesterday
https://imgur.com/v4JIJXw
BAHAHAHAHAHAHA
lemme get my shank

The International Phonetic Alphabet (IPA) is an alphabetic system of phonetic notation based primarily on the Latin script. It was devised by the International Phonetic Association in the late 19th century as a standardized representation of speech sounds in written form. The IPA is used by lexicographers, foreign language students and teachers,...
precisely.
unless you use latex
What, in Discord?
HAHAHAHAHA
i doubt discord has support for latex. but it does support unicode right?
@dense ibex watching stenography reminds me of:
yeah, but it won't render latex
$\LaTeX$
the way their hands bounce
isn't it stupid fast
@rugged root Yes so true, @somber heath You could say lets murder someone it would sound calm
idrk
i met someone that was in school for it
they're not typing every letter you know
No I think it was the one where they were curving the bullet
I can't remember the name
i think the person screaming and panicking would be the murderee not the murderer.
no,
@somber heath You're like a calm optimus prime ?
It has angelina jolie...
wanted
james mcavoy
wanted...?
wanted
ugh, that movie sucked
yum
its a comic book movie btw
this is what I always link to: https://drewdevault.com/2021/04/26/Cryptocurrency-is-a-disaster.html
ah
depends how he styles his hair
jesus h fuckin popsicle
At end of video 1:40
is james mcavoy the pug of the human world?
WHAT
LOL
bulgy eyed before all the fans start ganging up on me.
cant say it doesnt work on him tho
hotdogs aren't beef what.
You can get hotdogs that are just beef, but it's typically a bit pricier
!otn a generic-meat-object
!otn a generic-meat-object
:ok_hand: Added generic-meat-object to the names list.
I am but a vessel for your wishes Opal
there's 2 of us!
gambler don't you
make pcbs
that's super extra
i just buy them
hahahahahahahahaa
LOL
it can be stressful and overwhelming there's a lot of info
;_; when will lumber prices come down
What project did you have in mind?
@upbeat leaf have you hand-wired
is there a lumber shortage on going ?
I want to build an A-frame trellis support for my tomatoes
Probably when people start making more comfortable shoes.
They're getting too out of hand for my Florida weave trellis style of support
I really want silent reds
yes browns are shit tactiles
They are already dropping apparently
basically linears lmao
I heard the futures dropped, but I don't think the actual prices are coming down yet
Camo print keyboards.
Oh
I just saw this story this morning on NPR
Alternative thought: Bamboo.
@paper tendon If you want to know what's going on in the conversation, then type it, don't interrupt the conversation. Also please be conscious of background noise in your mic. Squeaking chair, coughing, etc. It's just being courteous to the other users. If you have a hard time keeping the sound suppressed, use push to talk.
9mm prices are still sooooooo high ;-;
.22lr for life
ooh alps
Always dirt cheap. If you just like target shooting or recreational, they're amazing
ammo is still so hard to get, it's impressive it's stayed scarce for this long
Alf switches.
It always seems to happen when a Democrat is elected into office
yup
There's a huge buy up
Flag or fan? You decide!
he's a FROG
mm eggs
fun fact: turtles are also reptiles. toads are amphibians.
well, good luck for the future ig jake.
@somber heath You can still pursue a career in voice actin, 10/10 wise man roles for you
what the hell
we disected a frog, crawfish, and roundworm
Hemlock.
Or...
No you, you really would be good read for children's books
"It was then that the wizard created ice cream for all the children"
and twas tasty
you'll
:3c
yes
you'll is an actual word lol
nah, I am gay though
@hollow haven In her pings and announcements when she says "y'all"
Wait what?
no one unironically says that tho
my boss uses it as you+all
Gays: "ooooH, a casual gender neutral term to refer to a group of people? it's ours now"
yas queen
Hey Hem and jake, how many dudes have you dated?
I guess it’s in revenge for heterosexual stealing Halloween
how about how many guys have you dated?
I always imagined @hollow haven as a racist 70 year old southern woman, when i read the word "y'all"
Which she wasnt
They even turned it boring ;_;
"How's that dude you're dating" <-- doesn't quite work as gender neutral
I just say how’s that guy your dating?
Assuming I know them well enough to know they are dating a guy
I wanted to be a grammar nazi but @vivid palm caught it i guess
I assumed it was a la Ru Paul's Drag Race >_>
that's terrifying
I prefer “how’s your partner?” For unknown relationship
How's your main squeeze
your homie
How's the other half
Significant other.
The douchebag you're dating
I dislike that
other half to the relationship?
hmmm I might do it.
lmao, I kept referring to my one coworker's then-boyfriend as her "future ex-boyfriend" because the dude was terrible and she was miserable with him
.io domains are not worth it
that's so expensive
literally anything is cheaper than .io
.dev is better than .io
Agreed
isn't io ethically ambiguous also
.io is shit, don't do it
I really want to get a .house domain so I can point my home assistant thing at it
Oh that'd be cool
you know the government can change the weather now
"and 20 the year after, 21 the year after that... funny how it works"
You wont fail
every year
@hollow haven remember when you took away my video role...
what video role?
Keanau
stupid fucking mic refusing to work ffs
Happens
The Mission impossible guy also
tom cruise
Perm Video roles is like fight club
Yeah
it's because of the child blood cells
Just like that classified bot
Oh! Rabbit!
This rarely ends well for me
Your idea for like... Dev Ops designated helpers for the code jam
Still something you think could work out?
george clooney
This code jam doesn’t really need them does it?
nah, not for this one. For the next
It'll be in like... January. I'm curious how much could be prepped ahead of time, or maybe do a small prepped workshop session of like "let's talk about containers"
If I get MicroMicro Public
It’s designed for that
what's mciromicro?
@rugged root Walter white won the aging thing I guess
oooh true, MicroMicro would be perfect for this
It comes with dockerfiles docker compose and hopefully Kubernetes scripts
You should tune in to our next stage event btw
you'll probably get a kick out of it
@rugged root Yeah Bryan
Linode is sponsor right?
Tudo bem ?
Yeah
Ok, I’ll target linode
But it doesn't necessarily have to target linode, it can be like... generic
maybe even azure
Except for container registry because WTF Linode?
ghcr is good for a container registry
But I could approach msft for it as a partnership thing where they could provide participants with some credits for the duration of the event
What are talking about???
All kinds of stuff. In voice chat we're talking about various dev ops stuff, also talking about actors that either look like they haven't aged or have aged very gracefully
I from Brazil
You can store and manage Docker and OCI images in the Container registry, which uses the package namespace https://ghcr.io.
@rugged root Asa butterfield ?
The GitHub Bootcamp went super well, I could probably justify a container/devops one that is sponsored
i'm following the steps to talk in voice chanel
Glad to hear it! Keep in mind you can still listen in on voice chat. And typically if we're in voice chat, we'll be watching this channel as well
actor
maybe in 3 days
oh ok,Ill do it
nice to meet you
Nice to meet you as well
could someone in this chat answer and pandas question for me?
Oii @half hemlock
I'm doing some copy commands from some pandas dataframes into a postgres table. The columns are exactly the same in both the dataframe and the postgres tables. The table has been cleaned, but I still get this error.
Error: extra data after last expected column
CONTEXT: COPY
I understand that the error is pretty self explanatory, but the columns align perfectly and I am unsure what the fix/issue is if I've confirmed a cleanup of columns
!vc
when you push it out of dataframe into pg, are you excluding the index? @timber vale
Pandas will sometimes include the index, but it won't show up as a column sometimes
I'am fine
there's usually an index=False option you can use to ensure it doesn't push it out
There is information available as to that in the voice-verification channel. :)
!voice-verify check the roles channel for info, if you are a new user
And you?
Ok
i'm doing fine,are you a python programmer
@somber heath Which animal are you talking about ?
You may not meet the criteria
Não, mas gosto do assunto vc ?
Did the Python bot send you a dm?
so I applied this and unfortunately still getting the same mistake. here's my copy method code
def df_to_table(conn, df, table):
"""
Here we are going save the dataframe in memory
and use copy_from() to copy it to the table
"""
# save dataframe to an in memory buffer
conn = sandbox_dbc()
buffer = StringIO()
df.to_csv(buffer, index=False, header=False) <-----
buffer.seek(0)
cursor = conn.cursor()
print(buffer)
try:
cursor.copy_from(buffer, table, sep=",")
conn.commit()
except (Exception, psycopg2.DatabaseError) as error:
print(f"Error: {error}")
conn.rollback()
cursor.close()
return 1
print("copy_from_stringio() done")
cursor.close()
return conn
@somber heath Could you write it down please, I cant understand the name
what honey?
King Parrot.
Oh
you're using psycopg2 as the db connector?
correct
Are you lieing
Can you share a snippet of what the buffer looks like when you print it?
yeah let me see if I can output that
Nossa q passarinho bonito (what a beautiful bird)
@rugged root Yeah right ! We got the context
I think they use it in terminal primarily
LInux has gdb also
But it was more focused on C++ and C i guess
If you're an entomologist, you can use cdb
Im glad Im in the era of debuggers with Visual Studio, where you hover over items and set watches
Code or proper
@hollow haven output from buffer <_io.StringIO object at 0x7fe488a6f820>
can you do print(buffer.getvalue())?
'0020200001,1610612755,PHI,Philadelphia,243,Aaron McKie,Aaron,F,No comment,37:24,86.3,89.3,92.2,90.7,-6.0,-1.3,0.263,1.0,20.0,0.0,0.162,0.08,20.0,0.583,0.649,0.227,0.231,97.14,96.24,80.2,75,0.186\n0020200001,1610612755,PHI,Philadelphia,1496,Keith Van Horn,Keith,F,No comment,38:50,98.7,101.3,100.2,101.3,-1.6,0.0,0.095,0.4,7.4,0.119,0.135,0.127,18.5,0.4,0.479,0.263,0.272,100.05,98.27,81.9,79,0.069
these are the first two rows
is it the \n that's causing the issue?
nah, how many columns is the table/are you specifying?
there should be 32
CREATE TABLE nba.player_bs_advanced (
"game_id" text,
"team_id" text,
"team_abv" text,
"team_city" text,
"player_id" text,
"player_name" text,
"nickname" text,
"start_position" text,
"comment" text,
"min" text,
"e_off_rating" text,
"off_rating" text,
"e_def_rating" text,
"def_rating" text,
"e_net_rating" text,
"net_rating" text,
"ast_pct" text,
"ast_tov" text,
"ast_ratio" text,
"oreb_pct" text,
"dreb_pct" text,
"reb_pct" text,
"tm_tov_pct" text,
"efg_pct" text,
"ts_pct" text,
"usg_pct" text,
"e_usg_pct" text,
"e_pace" text,
"pace" text,
"pace_per40" text,
"poss" text,
"pie" text
);```
table cols
df.cols
Index(['GAME_ID', 'TEAM_ID', 'TEAM_ABBREVIATION', 'TEAM_CITY', 'PLAYER_ID', 'PLAYER_NAME', 'NICKNAME', 'START_POSITION', 'COMMENT', 'MIN', 'E_OFF_RATING', 'OFF_RATING', 'E_DEF_RATING', 'DEF_RATING', 'E_NET_RATING', 'NET_RATING', 'AST_PCT', 'AST_TOV', 'AST_RATIO', 'OREB_PCT', 'DREB_PCT', 'REB_PCT', 'TM_TOV_PCT', 'EFG_PCT', 'TS_PCT', 'USG_PCT', 'E_USG_PCT', 'E_PACE', 'PACE', 'PACE_PER40', 'POSS', 'PIE'], dtype='object')```
What's the comment column supposed to have data-wise?
text
Does that text have commas?
The thing I would check is your data, if the data itself has a , that's causing the copy to split it into extra cols
no that I'm aware - it should not but i'll check right now
I cleaned up that column to where the blank values became no comment but I'll check the commas
I think I'm calling it a night @dark seal @rugged root have a good day !
You as well!
goodnight
lol, I sometimes force csvs to split on some weird separators just to avoid this. Like I think at one point I had it separated by + and that worked better than it should have
Way to be creative in your data quality methods 🙂
@rugged root https://pypi.org/project/dbf-to-sqlite/
"UPDATE table SET column=value WHERE condition"
update
for inserting
"INSERT INTO table VALUES ()"
for inserting
postgreSQL is also a good db
\🍉
juicy
Cucurbita (Latin for gourd) is a genus of herbaceous vines in the gourd family, Cucurbitaceae (also known as cucurbits or cucurbi) native to the Andes and Mesoamerica. Five species are grown worldwide for their edible fruit, variously known as squash, pumpkin, or gourd, depending on species, variety, and local parlance, and for their seeds. Othe...
!e
import sqlite3
print(sqlite3.sqlite_version)
@rugged root :white_check_mark: Your eval job has completed with return code 0.
3.27.2
C. maxima – winter squash, pumpkin; origin: Argentina, Bolivia, Ecuador
3.35.5
5
Hi
@vivid palm https://arrow.apache.org/
i need some inspiration any ideas for a begginer - intermediate projects
See ya
bruh
The granny knot is a binding knot, used to secure a rope or line around an object. It is considered inferior to the reef knot (square knot), which it superficially resembles. Neither of these knots should be used as a bend knot for attaching two ropes together.
The granny knot is also called the false, lubber's, calf, and booby knot. Patterso...

48083
176394

what is Q basic

