Change language

Python | Pandas DataFrame.to_records

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.

Output:

We will now use DataFrame.to_records () to convert this dataset to a representation of an array of recorded 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)

# 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

Gifts for programmers

Learn programming in R: courses

$FREE
Gifts for programmers

Best Python online courses for 2022

$FREE
Gifts for programmers

Best laptop for Fortnite

$399+
Gifts for programmers

Best laptop for Excel

$
Gifts for programmers

Best laptop for Solidworks

$399+
Gifts for programmers

Best laptop for Roblox

$399+
Gifts for programmers

Best computer for crypto mining

$499+
Gifts for programmers

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

News


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