from netCDF4 import Dataset
import matplotlib
import matplotlib.pyplot as plt
import numpy as np
import seaborn as sns
import pandas as pd

fn = '/home/s/Sukanya.Patra/TEST/2023/08/07/20230807_010005.znc'
fn1=fn[-19:-4]
ds = Dataset(fn)


sw=ds.variables['RMSg'][:].data
Z=ds.variables['Zg'][:].data
z=10*np.log10(Z)
t=ds.variables['time'][:].data
v=ds.variables['VELg'][:].data


zdf=pd.DataFrame(z.flatten(),columns=['Z']) 
vdf=pd.DataFrame(v.flatten(),columns=['V']) 
swdf=pd.DataFrame(sw.flatten(),columns=['SW']) 
df=pd.concat([zdf,vdf,swdf],axis=1)