Python pandas Group by

Ex
Group BY

 step   1:df=pd.read_csv('ferrovial.csv')

df
step 2:data=df.groupby('city')
data
#aatlu lkheya pche output nai aave next line add karve
for city,city_df in data:
    print(city)
    print(city_df)
step 3:particular city joiti hoy to aa step add karvu
data.get_group("kerala")
Step 4:data.max() #max value aavse
step 5:data.mean()#mean value aavse
step 6:data.describe() # descibe lkheshu to mean,median,max,min bdhu j aavse
DateCloseHighLowOpenVolumecity
002-01-200712.85012.94012.71012.9003080000.0vado
103-01-200712.66012.86012.60012.8502740000.0vado
204-01-200712.45012.72012.38012.5902330000.0vado
305-01-200712.20012.36012.07012.1701930000.0vado
408-01-200712.19012.28012.15012.2201970000.0vado
509-01-200712.45012.50012.22012.3902560000.0ahem
610-01-200712.28012.48012.26012.4002490000.0ahem
711-01-200712.35012.49012.20012.3101760000.0ahem
812-01-200712.50012.53012.31012.5901600000.0kerala
915-01-200712.65012.76012.59012.6401310000.0kerala
1016-01-200712.43012.74012.36012.5601250000.0surat

Comments

Post a Comment

Popular posts from this blog

Seaborn

Image
0] Countplot [aama x axix pr name che aene cross ma lkhva tay che] sns.countplot(x='Type 1',data=df,palette='rainbow') plt.xticks(rotation=70) plt.rcParams['xtick.labelsize'] = 15 plt.rcParams['axes.labelsize'] = 20 01]ax=df[1:50].plot.area(alpha=0.4, figsize=(5,4))      ax.legend(bbox_to_anchor=(1.0,1.0)) [aama instant,season,yr,mnth,hr........graph ni bhar lkhva mate use tay che ax.legenda vadi line add karvi] 1] sns. barplo t(x='sex',y='total_bill',data=tips) Boxplot 2] sns . boxplot ( data = df ) #pokemon 2]  # Pre-format DataFrame #pokemon stats_df = df . drop ( [ 'Total' , 'Stage' , 'Legendary' ] , axis = 1 ) # New boxplot using stats_df sns . boxplot ( data = stats_df ) 2]sns. boxplot (x='day',y='total_bill',data=tips, palette ="rainbow")  #palette use for color #class 2]sns. boxplot (data=tips,palette="rainbow", orient='h ...
Read more

profile fragment firebase ie image and information vadu page update tay firebase ma

//profile fragment aama image firebase ma update karvanu and name,phone,address,description aatle information firebase ma update tse //aama bundle no use nthi kreyo aama profile na badle galary name aapiyu che and drawer na badle Main2Activity.java name aapiyu che joi aatlo change che yad rakhvu //drawer ma profile name aapi devu step 1:profilefragment.java step 2:profileframent.xml step 3:drawer.java Step 1:profilefragment.java package demoproject.aalap.com.delete /** * A simple {@link Fragment} subclass. */ public class GalleryFragment extends Fragment { View view; private FirebaseDatabase database; private DatabaseReference userReference; //Firebase storage FirebaseStorage firebaseStorage; StorageReference storageReference; String name, address, phone, description, image; CircleImageView imgProfile; EditText edtname, edtdescription, edtphone,edtaddress; Button btnUpdate; //public static final int PICK_IMAGE_REQUEST=9999; pu...
Read more

Json_ login

// json login public class login extends AppCompatActivity {     EditText email, password;     Button login;     InputStream is = null;     JSONObject jobj = null;     String json = "", s1, s2;     public boolean islogin = false;     public static String sharedpref = "MyPref";     public static String adminlogin = "AdminLogin";     public static String adminshare = "AdminPref";     public static String adminemail = "email";     @Override     protected void onCreate(Bundle savedInstanceState) {         super.onCreate(savedInstanceState);         setContentView(R.layout.activity_login);         StrictMode.ThreadPolicy policy = new StrictMode.ThreadPolicy.Builder().permitAll().build();         StrictMode.setThreadPolicy(policy);         email = findVi...
Read more