Pandas (Python) tips and tricks | in Urdu/Hindi

[@shafiullahmarwat7165]

57:55 , The append function is not working in pandas version 2 or greater, so you have to use concatenation (concat) function For example: pd.concat([ kashti_1, kashti_2])

[@razaqureshi5286]

Love this style of teaching then previous one bcz in this style you are telling different techniques to do a same task

[@ihsanulghafoor]

@9:00 error is due to the list of column tags you have mentioned. when you change the dimension of the matrix , the list of column tags are not changed according to it, that why it give error.

[@razaqureshi5286]

Love this style of teaching then previous one bcz in this style you are telling different techniques to do a same task I saw this thing missing In chilla 1

[@Muhammad.Kashif31]

58:01 the function df.append(df1) has been changed to df._append(df1)

[@the34thStudent]

Getting complex. Do we need to memorise all these commands or follow the GitHub copilot? Thanks

[@EnglishJourney-u4e]

JaZakaAllah for this effort

[@Aftab_Ajk]

Video no. 8 and 9 are very important for learners. I recommend watching minute by minute.

[@info-cv8tg]

when i execute pd.clipboard() , it says Pyperclip could not find a copy/paste mechanism for your system. Why?

[@sunilnaser6218]

Sir jab main drop function k sath split karta to ak error a Raha axis is not found kindly tell me about it

[@Hijabfatima188]

Sir float64> yeh change hai just greater than ki

[@afnansandhu4297]

Very informative video

[@shujabinamjad7159]

At 58:15 append() function is depreceated in new version of python use concat method instead

[@MurtazaKhosa-pu3jv]

4,81 mn ap ny column k name kaam deya howa tha sir g baghair column name k chal jay ga

[@jhnmn52]

Append has updated to: df1 = pd.concat([kashti_1, kashti_2], axis=0)

[@BeatifulandFunnyCats]

Assignment: error=coerce is a parameter that is often used in functions that involve reading in or converting data. When error='coerce' is passed as an argument, it tells the function to try to convert any invalid data to a valid form, and to replace any invalid data that can't be converted with a missing value or special value (such as NaN for numerical data). This can be useful for handling data that may contain errors or inconsistencies, and can help to prevent errors from being raised when the data is processed.

[@saeednagaria6912]

@Codanics: I am getting following error at 6:38 Please help. TypeError: unhashable type: 'list'

[@MuhammadAli-ir5zo]

jazakAllah Aammar bhai

[@munZzza]

it's very helpful sir ❤

[@muhammadwalid6626]

sir ye github copilot kya cheez hain please.

[@amadali6566]

love you hogaya sir ❤

[@umesalmahyder8529]

When errors is set to 'coerce', it means that if there are any errors encountered during the conversion process (such as encountering non-numeric values), those problematic values will be replaced with NaN (Not a Number). This allows the conversion process to continue for the rest of the values in the column without being interrupted by errors. Here's a breakdown: errors='coerce': It means to replace errors with NaN. errors='raise': It means to raise an error if any errors occur during conversion. errors='ignore': It means to skip errors and leave the original values unchanged. In summary, setting errors='coerce' is often useful when you want to convert a column to numeric type but are not sure if all values are convertible, and you want to handle non-convertible values gracefully without raising an error.

[@yousuf_shah_1]

hats you for your effort

[@irammunir7769]

sir dataset load krne mein jo problem a rhe ha apke pass mre pass b same problem a rha ha can you help me to resolve this problem ia m using macbook

[@aneeqriaz7091]

JzakAllah sir g❤❤❤

[@muneebhassan1355]

I'm usiing Pandas 2.1.3 and in tip 13 "Join two datasets" we can't use df.append() function anymore. Found that we can use _append(). Don't know if they changed the name or this private function to do same task. Thanks

[@AreebaBushra-ef5he]

why my GitHub copilot is not giving code suggestion in code cell like the way it is giving in this vedio

[@AnasKhan-y7q5l]

dll load failed while importing _cext the specified module could not be found

[@UmarFarooq-ht9mc]

57:50 For Joining two Datasets new command is use that is "concat" : df1 = pd.concat([kashti_1 , kashti_2])

[@Cryptodany21]

thanks for the effort

[@abdullahsajid9373]

error = coerce In the context of a DataFrame in Python's pandas library, the error='coerce' parameter is typically used in conjunction with the pd.to_numeric() function. When you apply pd.to_numeric() to a column or a DataFrame, it attempts to convert the values to numeric data types (e.g., integers or floats). However, if it encounters a value that cannot be converted to a number, it will raise an error by default. By specifying error='coerce', you instruct pd.to_numeric() to handle such situations differently. Instead of raising an error, it will replace the non-convertible values with NaN (Not a Number) values. This allows you to retain the structure of your DataFrame while dealing with invalid or incompatible data.

[@raohammadraza]

thanks you so much sir

[@afnansandhu4297]

Sir next video kbb aye gi

[@LifeAsASoftwareEngineer]

What happened to other classes?

[@kiddienotes733]

errors='coerce') what it means to convert errors to coerce If the error argument is passed as coerce, then invalid parsing will be set as NaN. If the error argument is passed as ignore, then invalid parsing will return the input.

[@muhammadsaadshaheen7059]

Sir video quality ka issue araha hai😢

[@sadiaali1999]

if the error argument is passed as coerce , then invalid data will be set as NaN . it can help to prevent errors when data is processed.

[@shaykhatifanclub12]

col(4,81) giving error because sir only had given 8 columns name(ABCDEFGH).. we have to name all 81 columns .........or we cannot apply columns name because 81 is a large number to give all columns name.

[@Reality11075]

jb data excel ma save kr rahy han to csv q likha ha xlss likhna tha

[@asadullah8970-j1t]

asi tar kar sakta ha ham sir titanic['class'].value_counts()

[@QuizQuest1]

sir apke code mn suggestion aag rhe hn code ke hmare mn nhe aa rhe hn

[@Codanics]

Install github copilot

[@razaqureshi5286]

4 and 81 ka data frame is Lia nhi bana ta bcz hma fir columns names 81 dene hoga

[@Reality11075]

first we check the version second import the data third check the head and tail fourth make the csv and excel files fifth read the scv or excel files

[@yuxrazafar8532]

1:41:01 its unstack, not unstack()... kaam kr rha h but koi changes nh hn

[@mehdihussainseo]

what does this (random_state=1) mean? and what if i set it 0 or 2 or 4 will there any changes in output result?

[@crazymunna2397]

it basically means if u want to use random genreator for something else later in the function and u want it to generate same random numbers then u can fix the way of generating random number by mentioning state that can be 0,1,2 etc and later if u mention the state of generating number it will generate same numbers

[@mahwishbukhari628]

Itny sary codes yaad kaisy rakhny hain 😮 ye tw bhool jayn gy

[@aneeqriaz7091]

Object has no attribute append in order to rejoin kashti_1or kashti_2

[@HamzaAli-bb8cx]

you use space instead of underscore which is against rules(53:10/2:05:24)

[@UltimateSaif]

Baba Aammar was unable to explain this part. [::-2]: This part is a slice notation for selecting every second row in reverse order. The [::-2] slice selects rows starting from the last row and moving backward by a step of 2.

[@Codanics]

Thank you for stating it

[@hubgaming_tech]

12:06, baba g inplace=True ke baghayr bhi update horaha hai name columns ka

[@Codanics]

Agar ap object update karen gay tu ho ga

[@shafiullahmarwat7165]

11:27 , Hello everyone, I am not getting the auto suggestion but have to write the whole line by myself. Pylance( intelleecense) is working?

[@Codanics]

Use github copilot or codeium

[@muneerahd]

@1:32 #key kiya

[@AbdulManan-jf6ql]

first line was the error while loading phool , iris dataset

[@rafiasalah1688]

21:52 I received ssl error what to do? using vs in Mac

[@Codanics]

This is a terrible answer (not very secure), but appears to be the current Microsoft official answer. Use "http.proxyStrictSSL": false in your settings.json file. This should work to get around the issue of installing extensions inside a corporate network, but I'd recommend disabling the setting if you are going to be working from home/coffee shop and not connected to the corporate VPN. github.com/Microsoft/vscode/issues/3492

[@shahneelraza3030]

9:23 because the mentioned columns are not matching the number of columns

[@fazlurrahman5017]

either delete the column or provide the column with the alphabet or any nomenclature equal to 80,81 or whatever number. Correct me if anything is found wrong. Thanks

[@UltimateSaif]

df.info(memory_usage='deep')

[@muneerahd]

@52:51 # _ should be used instead of spaces .

[@MhassanKhan01]

great job keep it up. i am looking for mqtt broker system please help

[@hashirahbar7323]

1:41:21 unstack() used to convert into frame

[@hammadalamsiddique3730]

sir tamaam tricks samajh agaen bas last trick me confusion arahi

[@hassnainabbas8094]

1:39:02 (unstack) function is running

[@Atif-h6j]

1:13:41, df['class'].value_counts().nsmallest(3)

[@umermirza27]

*correction 1:11:36 24.00 walay 30 22.00 walay 27

[@Reality11075]

# location changing df[['city', 'country']] = df.location.str.split(' ',expand= True) df

[@razaqureshi5286]

Mgr Apne columns names nhi dia te itna zada

[@UmarFarooq-ht9mc]

es Video ko daikny mai mujay 6-8 hours lagay

[@muhammadsaadshaheen7059]

Video quality kasy teek ho sakti hai

[@Aimanshah110]

you are right. muje 2 hours ho gye aur abi 19 minutes pe hon. hehehe. even I am studing python from 1 years. his style is very good and very detailed.

[@SanwalMasaud]

unstack is working in my machine

[@Khanacade]

unstack is working

[@iamhiuh]

1:32:36 keee kiya Punjabi 😄😂

[@StarGazeUniverse]

**kashti.groupby('who').sum()** is not working. as it is showing me the error of "category type does not support sum operations"

[@shahneelraza3030]

1:40 do not add parenthesis to it

[@Reality11075]

ki kia

[@muhammadnouman3175]

ADD KILL THE FOCUS🥵

[@Codanics]

and give you a chance to support our cause.

[@muhammadnouman3175]

@@Codanics OK

[@iffatjabeen4205]

Adding splits into columns is not working

[@hashirahbar7323]

53:09 _misisng

[@shahidaman9665]

df.groupby('who').sum( ) is not working