Python Forum
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Using pandas library
#4
(Oct-25-2020, 09:52 AM)snippsat Wrote: Also when using Pandas is looping through rows/columns rarely the best solution.
In fact Pandas even has a red warning about this.
Pandas Wrote:Iterating through pandas objects is generally slow.
In many cases, iterating manually over the rows is not needed and can be avoided (using) a vectorized solution,
many operations can be performed using built-in methods or NumPy functions, (boolean) indexing.
So as example with your code,could eg use np.where.
import pandas as pd
import numpy as np

numbers = pd.DataFrame([[3],[8],[4],[9],[14],[17]], columns=['Numbers'])
numbers['Odd/Even'] = np.where(numbers['Numbers'] % 2, 'Odd', 'Even')
Output:
>>> numbers Numbers Odd/Even 0 3 Odd 1 8 Even 2 4 Even 3 9 Odd 4 14 Even 5 17 Odd

Thanks for answering but we didn't give students the numpy, is there other ways?
Reply


Messages In This Thread
Using pandas library - by ramitaherwahdan1978 - Oct-25-2020, 06:21 AM
RE: Using pandas library - by bowlofred - Oct-25-2020, 07:27 AM
RE: Using pandas library - by snippsat - Oct-25-2020, 09:52 AM
RE: Using pandas library - by ramitaherwahdan1978 - Oct-25-2020, 12:32 PM
RE: Using pandas library - by jefsummers - Oct-25-2020, 01:18 PM
RE: Using pandas library - by jefsummers - Oct-25-2020, 01:46 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Better python library to create ER Diagram by using pandas data frames as tables klllmmm 0 1,418 Oct-19-2023, 01:01 PM
Last Post: klllmmm
  Questions regarding usage of pandas library Pala 5 1,250 Apr-26-2023, 10:21 PM
Last Post: deanhystad
  PyInstaller, how to create library folder instead of library.zip file ? harun2525 2 4,992 May-06-2017, 11:29 AM
Last Post: harun2525

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020