Tutorial 10- Pandas Read CSV File ,StringIO Tutorial In Hindi- Part 2

Pandas is a software library written for the Python programming language for data manipulation and analysis. In particular, it offers data structures and operations for manipulating numerical tables and time series. It is free software released under the three-clause BSD license.
----------------------------------------------------------------------------------------------------------------
Please donate if you want to support the channel through GPay UPID,
-----------------------------------------------------------------------------------------------------------------------
Recording Gears That I Use
---------------------------------------------------------------------------------------------------------------------------
#krish #pythonbusted
Connect with me here:

[nirajkumar]

Agr aap jasa log na ho to jo free m knowledge date h wo vo intni easy way m, ya coaching centre wala to logo ki kidney nikalna k liya ready h fee k name pr. Thanku sir, heads off to you

[alisquest]

I can always rely on your videos to help me break through my blocks! thanks Krish for all your videos!

[sidnoga]

This channel helps me a lot in my revision. Thank you for the free materials. Now students are safe from some education marketing giants who sales useless materials in a very high price and loots their money and destroys there future

[vikashprasad]

this might be free lacture but for me it is priceless thnkyou sir..

[sacchetyagi]

Thank you very much. It is very helpful to me as I just started to learn Python

[aarizmobin]

you are onre of the best tutor... very informative video... Thank you for this

[Intradaytradingviewtoday]

I love you bro i am very happy i learn alot from this video please upload more video of python for data science and artificial intelligence

[the_witcherr]

Thanks for such informative videos on pandas and numpy.

[jagdish_soni]

Sir, ham apki or apke free lecture ki ijazat krte h . This videos very very helpful for me and hundreds of people like me who can't afford these courses. Thanks 🙏

[writeruby]

#Converts any string into 'In Memory' file format.
from io import StringIO

data=('col1, col2, col3\n'
'x, y, 1\n'
'a, b, 2\n'
'c, d, 3')

# 'In Memory' file format object
StringIO(data)
pd.read_csv(StringIO(data))

pd.read_csv(StringIO(data), dtype='object') --> Converts all datatypes to object (Dictionary can be passed too)

[Vptheboss]

Problem occurred at 24:00 solution is:
pd.read_csv(StringIO(data), index_col= 'a', usecols=['a', 'b', 'c'])
make sure the column specified in index_col is not excluded by usecols

[shubhamhundet]

Please uploads more videos sir frequently

[ayshasaniya]

Regarding the index_col and use_col, I think initially we just give as use_col=['b', 'c'], but the next part .ie., index_col=0 is given which is the 'a' column. Inorder to perform the index_col=0, operation, we have to specify that we also need column a . Therefore use_col =['a', 'b', 'c']. It would be kind of you if u can let us know why we r getting NaN though.

[neeraj]

sir jupyter me automatic function name suggestion kaise aate hai

[muskanmalik]

@krishnaikhindi Sir marcedesbenced wali file to do sir

[Anmol.singh.]

Sir Usecols aur indexcol sath mein use kiya to a column include nhi hua because it was not present in usecols.

[biovision]

In my computer and in my frineds computer the usecols function is not working

[yashchoudhary]

Hey Krish my problem is that ki mujhe problem hoti dataset ko load karne me abhi apki mene python tutorial 10 hai isme apne mercedesbenz.csv dataset hai to is load kese karu and importanat problem of mines is that ki mujhe kese karu yeh mujhe yh Btao ki mujhe dataset kaha se load kar pau easliy

[ShivprasadShreshthi]

where did you get CSV file from please reply

[yashjajoria]

pd.read_csv(StringIO(data)) - show parser error