Python Pandas Tutorial: Pandas Date_Range and Period_Range Tutorial #18

[@ravikumarreddy3773]

Hi Sir, I am following your channel regularly, Your content is very useful and learned a lot from your videos. Thank you so much ....

[@victor_yahoo]

Excellent, thank you

[@Al-Ahdal]

How to take mean of positive numbers only in the series or in dataframe?

[@AbhisheakSaraswat]

df[df[columnName]>0].mean()

[@Al-Ahdal]

@@AbhisheakSaraswat, I did this and get true, false but unable to get average of positive numbers.

[@Al-Ahdal]

It is series, not df

[@Al-Ahdal]

@@AbhisheakSaraswat
[1, 2, 3, 0, -1]
how to get average of positive numbers only in the list or series?

[@ravikumarreddy3773]

I have a 10 gb csv file , While reading the file taking too much time, Could you please help , how to read the 10 gb file ?
which module is better to read 10 gb csv file [ pandas or any other module ] ?

[@ProgrammingIsFunn]

Use PySpark instead of pandas

[@ravikumarreddy3773]

@@ProgrammingIsFunn Thank you.

[@ravikumarreddy3773]

@@ProgrammingIsFunn Could you please suggest me any tutorial for learning pyspark.

[@godbhaigod]

Sir in the beginning when you used Freq°=M or 2M, you provided date 01-01-2022
But in output it begins with 2022-01-31, Why, we want 01-01-2022 then what to do