Hi, Very helpful video, just wanted to know if i want to apply all the functions like filtering, delete, v-lookup in the same file and have only one output file. How am i supposed to do it? like for every new function you made a new output file ...i want one
@@Python2020 sir i need to get selected data from selected column, not header or only data from column to different excel sheet, please if can help me ,🙏🙏🙏🙏🙏
i want to set my read_excel name(eg: pd.read_excel('deepak.xlsx',) to df.to_csv name (eg: 'deepak.csv'). now i am doing this manually and there is lots of excel file to do, how can i set this as dynamic.
Thanks for tutorial, I need to delete multiple rows from multiple columns ...like you have deleted France I need to delete multiple country ...how I can do that plzzzzzz help
you just have to repeat filter twice with different values in drop statement ... here is one simple example .. stackoverflow.com/questions/52456874/drop-rows-on-multiple-conditions-in-pandas-dataframe stackoverflow.com/questions/29017525/deleting-rows-based-on-multiple-conditions-python-pandas/29017731
Hi do you know how to check a particular value in a column as filter and if the search value is not present in the column then i will be a copying the new row with the data from another excel? I will be passing the filter condition for filtering the column im not sure how to achieve this data
@@Python2020 pandas lambda doesn't suit im trying to pass a filter_search value from source excel to the destination_excel file as a filtering criteria but after filtering if the filter_search value is not present in destination_excel file i want to add that row from source to destination currently im able to filter but im not able to paste when its not finding the filter_search value because of the criteria
@@dhanyajayaprakash8922 -- so data sheet in PANDAS means dataframe, so ifbyou have only one sheet for one dataframe new row from other sheet wouldn't be considered... You can consolidate sheets in single daraframe... Watch video 8.2...hope it helps
Hello! Awesome content! Do you know how to skip rows with Pandas before doing something? I’ve an excel file that contains two rows that I need to skip and then there’s columns headers in the row 3. And then from the row 4 starts all the data.
Hi Thank you , you can use pandas header to skip rows, or if you don't want to keep few rows find out some criteria to filter and the delete, video 8.4 might be useful on my channel...
@@Python2020 thank you so much. I’ll study more Pandas since I’m going to need it. Yes I just need to skip, not delete a few rows and then read columns headers. Then based on column name I need to fill data into the file from Airtable 😀
@@Python2020 i want to set read_excel name(eg:pd.read_excel('deepak.xlsx', engine='openpyxl') to df.to_csv('deepak.csv'). now i am doing this manually how can i set this as dynamic
YES.... MOST OF COMMON USGAGET ARE COVRED ... THANK YOU FOR GIVING SO LONG TIME FOR HELPING PEOPLE
thank you nice content
Fantastic job friend....Looking for such long time such kind of videos
Hi, Very helpful video, just wanted to know if i want to apply all the functions like filtering, delete, v-lookup in the same file and have only one output file. How am i supposed to do it? like for every new function you made a new output file ...i want one
Add sheet, there are other videos as well on channel hope you will get all answers
Complete Coverage... Thanks
very useful video
Thank you ajay bhai... Please ahare the link of video on your social media profiles that will help me 🙏
Thanks for the great vid
Your welcome
Excellent tutorial
Thank you Raj Bhai..
thank you so much sir,,, for making this video ,,
love your explaination.
Thanks
@@Python2020 sir i want to copy data from one excel sheet to another selected column wise, using python
can you suggest me any video please 🙏
1 create new data frame by selecting required columns
Then write new dataframe to excel.. You can search in Google
@@Python2020 sir i need to get selected data from selected column, not header or only data from column to different excel sheet,
please if can help me ,🙏🙏🙏🙏🙏
Do you want to filter within columns or you want complete data of column1, column3, column7...??
thankyouu so much
Your welcome
Nice explanation
How can I filter a date column which are having 3 different dates in different different cells?
Another video on my channel dedicated for filters
@@Python2020 thank you sir, i will be waiting for that video
It's already there - th-cam.com/video/xQwELKsskFU/w-d-xo.html
Hi in this if we wanted to save all csv in seprate dfs can you guide for that
You just have to give a saprate name when assigning
@@Python2020 how to do it
Df1 = pd. Readcsv(filepath)
Df2= pd. Readcsv(filepath2)
Check exact syntax in example or google
i want to set my read_excel name(eg: pd.read_excel('deepak.xlsx',) to df.to_csv name (eg: 'deepak.csv'). now i am doing this manually and there is lots of excel file to do, how can i set this as dynamic.
You have to use variable based on some value.. Hv a look on this th-cam.com/video/j4Cir9uj7gU/w-d-xo.html
th-cam.com/video/_TFtG-lHNHI/w-d-xo.html
Thanks for tutorial, I need to delete multiple rows from multiple columns ...like you have deleted France I need to delete multiple country ...how I can do that plzzzzzz help
you just have to repeat filter twice with different values in drop statement ... here is one simple example ..
stackoverflow.com/questions/52456874/drop-rows-on-multiple-conditions-in-pandas-dataframe
stackoverflow.com/questions/29017525/deleting-rows-based-on-multiple-conditions-python-pandas/29017731
@@Python2020 How to Convert XLSX to CSV without losing values from formulas using python
Hi do you know how to check a particular value in a column as filter and if the search value is not present in the column then i will be a copying the new row with the data from another excel? I will be passing the filter condition for filtering the column im not sure how to achieve this data
pandas lambda if else - search in google.. Let me if you still don't find solution
@@Python2020 pandas lambda doesn't suit im trying to pass a filter_search value from source excel to the destination_excel file as a filtering criteria but after filtering if the filter_search value is not present in destination_excel file i want to add that row from source to destination currently im able to filter but im not able to paste when its not finding the filter_search value because of the criteria
@@dhanyajayaprakash8922 -- so data sheet in PANDAS means dataframe, so ifbyou have only one sheet for one dataframe new row from other sheet wouldn't be considered... You can consolidate sheets in single daraframe... Watch video 8.2...hope it helps
hey i have to remove some rows which have red background in excel. how can i do that??
As Per My Knowledge, Pandas can not access formats, access this information for new updates... pandas.pydata.org/pandas-docs/stable/style.html
@@Python2020 so how can i delete rows using python having red color background?
Hello!
Awesome content!
Do you know how to skip rows with Pandas before doing something?
I’ve an excel file that contains two rows that I need to skip and then there’s columns headers in the row 3. And then from the row 4 starts all the data.
Hi Thank you , you can use pandas header to skip rows, or if you don't want to keep few rows find out some criteria to filter and the delete, video 8.4 might be useful on my channel...
@@Python2020 thank you so much. I’ll study more Pandas since I’m going to need it.
Yes I just need to skip, not delete a few rows and then read columns headers. Then based on column name I need to fill data into the file from Airtable 😀
@@vesa-matti86 stackoverflow.com/questions/27325652/python-pandas-read-csv-skip-rows-but-keep-header
Hope this helps
@@Python2020 How to Convert XLSX to CSV without losing values from formulas using python
How can i delete all rows if found string or special character in a particular column
There another video which covers Drop based on condition on my TH-cam channel, you can use contains function for filter and then drop
@@Python2020 thanks bro
How can we set read excel name as to excel name dynamically
How is the name any patten..?? Or you cab try for each file in a folder with filter of file extension
@@Python2020 i want to set read_excel name(eg:pd.read_excel('deepak.xlsx', engine='openpyxl') to df.to_csv('deepak.csv'). now i am doing this manually how can i set this as dynamic
How to Convert XLSX to CSV without losing values from formulas using python
Did you try reading excel as dataframe and write datafeame to cav. .?
@@Python2020 yes