import pandas as pd
import numpy as np

df = pd.read_excel('sample.xlsx')
df = np.array(df)
print df

where_are_NaNs = np.isnan(df)
df[where_are_NaNs] = -700
print df






8fe3ba888e10f6d91cf6925f241a565b7fe9a188
import pandas as pd
import numpy as np

df = pd.read_excel('sample.xlsx')
df = np.array(df)
print df

where_are_NaNs = np.isnan(df)
df[where_are_NaNs] = -700
print df





