Excel vs. Python+Pandas. Где обрабатывать данные проще? Обзор и сравнение типовых операций.

#python #pandas #dataanalysis #dataanalytics #datascience Links: Free collection of materials for data analysts: https://t.me/AnalystKlondikeOfficialBot Find a mentor: introduce yourself at https://t.me/AnalystKlondikeAdmin Practical SQL course for data analysts: https://clck.ru/3NjCwX About the data analyst profession, how to become an analyst, useful materials, and courses in our Telegram channel: https://t.me/+CbqLeDIGvB1kYTBi In this video, we'll show you how processing data in Python and Pandas is even easier than in Microsoft Excel. To demonstrate this, we'll perform common data processing operations first in Excel and then in Pandas. You can watch this video even if you don't know anything about Pandas, but if you want to gain more systemic knowledge, our Telegram channel will have links to courses on both Python and Pandas. Timestamps: 00:00 - Start of video 00:06 - Overview of the operations we'll be performing one by one in Excel and Pandas 00:33 - Open to file in Excel and Pandas 00:58 - Show top N rows in Excel and Pandas 01:24 - Rename columns in Excel and Pandas 01:59 - Add a column with autofill from 1 to N in Excel and Pandas 02:35 - Change column order in Excel and Pandas 03:35 - Delete a column in Excel and Pandas 03:52 - Split a column by a column in Excel and Pandas 04:31 - Round values ​​in a column in Excel and Pandas 04:58 - Concatenate rows in 2 columns in Excel and Pandas 05:32 - Remove extra columns in Excel and Pandas 06:04 - IF Formula in Excel and Pandas 07:43 - Filter by 1 Column in Excel and Pandas 08:25 - Filter by Multiple Columns in Excel and Pandas 09:13 - Sorting in Excel and Pandas 09:42 - Grouping/Pivot Table in Excel and Pandas 10:58 - Save to File in Excel and Pandas You can ask questions in the Telegram channel: https://t.me/analyst_klondike Video file: https://t.me/analyst_klondike/58 Python Course for Beginners: https://t.me/analyst_klondike/30 Pandas Course for Beginners: https://t.me/analyst_klondike/54 Royalty Free Music from Tunetank.com Track: Step By Step by Evan Splash https://tunetank.com/track/187-step-b... Sound Effect: Ninja whoosh jump Download from https://tunetank.com