Learn Python Pandas #2 - Data Selection, Viewing, & Indexing

[@nickarrigo5540]

derricks instruction gets right to the point. He doesn't over talk and tells you only what you need to know. His channel is an awesome resource!

[@TeverRus]

Thank you, man! I got a job where I have to work with pandas... and until I saw your videos I hadn't had a clue what to do about it! You are a life saver :)

[@kevinwonart]

I recently started a job where I have to manage a ton of data files. This is what I've been wanting to learn how to do. Thank you for your easy step by step videos and explanation!

[@CodeWithDerrick]

Glad they're helpful! Let me know if I can make any specific tutorials to help you out! Happy coding!

[@William_sJazzLoft]

Hey Derrick; it's another outstanding video. Just a note of caution for anyone doing this in the venv of repl.it ( as I did ) make sure to install the xlrd dependency.

[@kumargautam9428]

Thanks Derrick, as usual your tutorials are apart from the crowd ...

[@DequanHarrison]

Excellent videos! I like how you give the diagram/chart and show the multiple ways of using a function.

I dropped a nice MIT lecture on differential equations in order to gather info to solve a problem in my pandas lecture, so this better be good teacher derrick

[@NeetaYatender]

Nice one brother.... Keep it up

[@nasser-eddinemonir8443]

Excellent ! I've never seen such a presentation of dataframe's selections. *applause*

[@deepaksaikumar5178]

great tutorial, But watch this at 0.5x for better understanding

Very very nice amigo

[@qwerasdfhjkio]

Very nice!

[@nathalielink3869]

Thank you Derrick, your tutorial is helpful!

[@caiopjv]

Great video. Thanks

[@maxbart1353]

really good explanation, thx. Now I understand that I need this knowledge.......

[@englishtagalog3994]

Hey Derrick, i was wondering where was the excel file? in your other tutorial the workbook was included

[@thingstoknow3641]

All videos are useful..can you please make some tutorial on CSV file with pandas..like if there are 1000 lines in a CSV ..now if the data reperesets no of students, University, coures, in row by row..( that are in not in coloumn wise) then how we can create new CSV in different tab representing students, University, coureses

[@Learnaction3173]

Thanks Derrick

[@robertcliffort2354]

great.

[@jenniferhedgecoth9577]

Very Helpful!

[@karthikkanna2618]

Very useful for me thanks bro

I converted a numerical column into index, but it has repeated values????? Am I doing wrong? You skipped this feature.

[@duaafatima3564]

where do I download the excel sheet? :/

[@dennisasamoah2213]

great

[@aajadsingh8050]

Nice

[@adeyeyetemitayo7383]

Wonderful video. Really enjoy your videos. Do you have a video on how I can read Excel files, write into another Excel file and automate it if there's a new update on the Excel file we are reading from. Thank you

[@FrankenLab]

@Derrick Sherrill, I like your videos, but this one felt *really* rushed, like you had too much caffeine, lol. There were parts where you didn't elaborate and were going so quick there wasn't time to extrapolate what you meant. So far this the only video where I've noticed you've done that. Otherwise, great stuff!

[@faizanarain3080]

Can anyone tell me what environment does he use? I having difficulty using Jupiter note book

[@William_sJazzLoft]

He's apparently working on his desktop. From the first video in the series, I use Atom Text Editor for all my tutorials Atom Text Editor: atom.io/

[@hardikpatel6324]

hey mate nice and useful video. i am trying to get table from 4 diff. wiki pages and want to club them in single page. i can get that 4 page individually but unable to club them in single page. can you give me any video link or ref. where i can learn it ? thanks in advance.

[@CodeWithDerrick]

Thank you for your kind words! I'm working on the Pandas #4 video right now which will be about how we can concatenate multiple dataframes into one. I'll get the video up soon but if you want to check out the documentation for concatenating before, you can find it here: pandas.pydata.org/pandas-docs/stable/reference/api/pandas.concat.html

[@saqibrauf2191]

U r great bro

[@camarojay7027]

I got a new boss at work and he wants me to learn Python and Tableau asap. Any recommendations for me?

[@Rodourmex]

Thanks for your tutorials man, do you know whye if there is a parenthesis "()" the entire column is hiden in the terminal?

[@alvaroalfonso8754]

thanks

[@bazareta6936]

I guess that loc and iloc is more convincing and updated as per version 0.25

[@baophan6246]

thanks, can you give me take that excel file?

[@aajadsingh8050]

,👍❤️

Bueno amigo hice esta simulacion con tu interesante video (yo hablo ingles, y tu hablas español?) #SELECCIONANDO combinando los dos DF #SIMULANDO BUSQUEDA POR INDICE USANDO LOC E IAT #posicion numerica de ambos parametros #para accesar a campos especificos del registro print('LA CANTIDAD DE REGISTROS ES : ',len(df2.index)) numero_maximo=len(df2.index)-1 print("-"*10) mensaje="Ingrese numero de registro : maximo "+str(numero_maximo)+ " ? " registro=int(input(mensaje)) if registro < numero_maximo: print(df.loc[registro, "Nombre"]) print(df2.iat[registro, 0]) print(df2.iat[registro, 1]) print(df2.iat[registro, 2]) else: print("Numero fuera de rango")

[@robertcliffort2354]

great.

[@quantum7401]

Nice