# Does Modifying a DataFrame Affect the View in PySpark?

No, modifying the original **DataFrame** **after creating a view** does **not** affect the view because views in PySpark are **not directly linked** to the DataFrame. Instead, the view **stores the state of the DataFrame at the moment the view is created**.

# Create View and Modify DataFrame

1. **Creating a View and Modifying DataFrame**
    

```python
data = [("Ram", 30), ("Balaram", 25), ("Krishna", 35)]
columns = ["name", "age"]

df = spark.createDataFrame(data, columns)

# Create a temporary view
df.createOrReplaceTempView("people_view")

# Query the view
spark.sql("SELECT * FROM people_view").show()
  
```

**Output**

```plaintext
+-------+---+
|   name|age|
+-------+---+
|    Ram| 30|
|Balaram| 25|
|Krishna| 35|
+-------+---+
```

2. **Modify the Original DataFrame**
    
    ```python
    # Modify the original DataFrame (add a new column)
    df = df.withColumn("city", lit("New York"))
    
    # Show the modified DataFrame
    df.show()
    ```
    
    ```plaintext
    +-------+---+--------+
    |   name|age|    city|
    +-------+---+--------+
    |    Ram| 30|New York|
    |Balaram| 25|New York|
    |Krishna| 35|New York|
    +-------+---+--------+
    ```
    

**Query the View Again**

```plaintext
+-------+---+
|   name|age|
+-------+---+
|    Ram| 30|
|Balaram| 25|
|Krishna| 35|
+-------+---+
```

# How to Update a View When DataFrame Changes?

If you want the view to reflect the updated DataFrame, you must **recreate** the view:

```python
df.createOrReplaceTempView("people_view")  # Recreating the view
```

Now, if you query the view again:

```python
spark.sql("SELECT * FROM people_view").show()
```

**Output (Updated View after Recreation):**

```python
+-------+---+--------+
|   name|age|    city|
+-------+---+--------+
|    Ram| 30|New York|
|Balaram| 25|New York|
|Krishna| 35|New York|
+-------+---+--------+
```

# Key Takeaways

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1739090422354/a1d9397c-b34e-49a3-a96e-6eadb39cdc0a.png align="center")