DataFrame.to_records()
Pandas DataFrame.to_records()
converts the DataFrame to an array of NumPy records. The index will be included as the first field in the array of records when requested.
Syntax: DataFrame.to_records (index = True, convert_datetime64 = None, column_dtypes = None, index_dtypes = None )
Parameter:
index: bool, default True
convert_datetime64: Whether to convert the index to datetime.datetime if it is a DatetimeIndex.
column_dtypes: If a string or type, the data type to store all columns
index_dtypes: If a string or type, the data type to store all index levels
Returns: numpy.recarray
Example # 1: Use DataFrame.to_records ()
to convert this Dataframe to an array of records.
# import pandas as pd import pandas as pd # Create DataFrame df = pd.DataFrame ({ ’Weight’ : [ 45 , 88 , 56 , 15 , 71 ], ’Name’ : [ ’Sam’ , ’Andrea’ , ’ Alex’ , ’Robin’ , ’ Kia’ ], ’ Age’ : [ 14 , 25 , 55 , 8 , 21 ]} ) # Create index index_ = pd.date_range ( ’2010-10-09 08:45’ , periods = 5 , freq = ’H’ ) # Set index df.index = index_ # Print DataFrame print (df) |
Output:
We will now use DataFrame.to_records ()
to convert this dataset to a representation of an array of recorded records.
# convert to array of records result = df.to_records () # Print result print (result) |
Output:
As we can see in the output, DataFrame.to_records ()
successfully converted this dataframe to an array of records.
Example # 2: Use DataFrame.to_records ()
to convert this Dataframe to an array of records.
# pandas import as pd import pandas as pd # Create DataFrame df = pd.DataFrame ({ " A " : [ 12 , 4 , 5 , None , 1 ] , "B" : [ 7 , 2 , 54 , 3 , None ], "C" : [ 20 , 16 , 11 , 3 , 8 ], " D " : [ 14 , 3 , None , 2 , 6 ]}) # Create index index_ = [ ’Row_1’ , ’Row_2’ , ’ Row_3’ , ’Row_4’ , ’Row_5’ ] # Set index df.index = index_ # Print DataFrame print (df) |
Output:
We will now use DataFrame.to_records ()
to convert this dataset to a representation of an array of recorded records.
# convert to array of records result = df.to_records () # Print result print (result) |
Output:
As we can see in the output, DataFrame.to_records ()
has successfully converted this dataframe to an array of records.
Shop
Learn programming in R: courses
$FREE
Best Python online courses for 2022
$FREE
Best laptop for Fortnite
$399+
Best laptop for Excel
$
Best laptop for Solidworks
$399+
Best laptop for Roblox
$399+
Best computer for crypto mining
$499+
Best laptop for Sims 4
$
Latest questions
PythonStackOverflow
Common xlabel/ylabel for matplotlib subplots
1947 answers
PythonStackOverflow
Check if one list is a subset of another in Python
1173 answers
PythonStackOverflow
How to specify multiple return types using type-hints
1002 answers
PythonStackOverflow
Printing words vertically in Python
909 answers
PythonStackOverflow
Python Extract words from a given string
798 answers
PythonStackOverflow
Why do I get "Pickle - EOFError: Ran out of input" reading an empty file?
606 answers
PythonStackOverflow
Python os.path.join () method
384 answers
PythonStackOverflow
Flake8: Ignore specific warning for entire file
360 answers
Wiki
Python | How to copy data from one Excel sheet to another
Common xlabel/ylabel for matplotlib subplots
Check if one list is a subset of another in Python
How to specify multiple return types using type-hints
Printing words vertically in Python
Python Extract words from a given string
Cyclic redundancy check in Python
Finding mean, median, mode in Python without libraries
Python add suffix / add prefix to strings in a list
Why do I get "Pickle - EOFError: Ran out of input" reading an empty file?
Python - Move item to the end of the list
Python - Print list vertically